[it認證]oracle診斷案例-sql_trace-資料下載頁
2025-08-21 13:41本頁面
【正文】 trace shows the failing sql statement as: delete from sdo_geom_metadata_table where sdo_owner = user solution description (1) create a synonym for sdo_geom_metadata_table under system which points to . 對于本例，.是相對簡單的情況.(2) now the user can be dropped connected as system. related documents ora604 and ora942 reported during drop user casca如果未使用spatial選項，能刪除sql connect / as sysdbaconnected.sql select * from dba_sdo_geom_metadata order by owner。 select * from dba_sdo_geom_metadata order by owner*error at line 1:ora00942: table or view does not existora04063: view has errorssql select object_name from dba_objects where object_name like %sdo%。object_nameall_sdo_geom_metadataall_sdo_index_infoall_sdo_index_metadatadba_sdo_geom_metadatadba_sdo_index_infodba_sdo_index_metadata....dba_sdo_geom_metadatadba_sdo_index_info...sdo_within_distanceuser_sdo_geom_metadatauser_sdo_index_infouser_sdo_index_metadata88 rows selected.sql drop user mdsys cascade。user dropped.sql select owner,type_name from dba_types where type_name like sdo%。no rows selectedsql sql alter session set sql_trace=true。session altered.sql drop user wapm。user dropped.sql alter session set sql_trace=false。session altered.sql exitdisconnected from oracle8i enterprise edition release 64bit productionwith the partitioning optionjserver release 64bit production這時用戶得以順利drop使用sql_trace能跟蹤數據庫的非常多后臺操作有利于我們發(fā)現問題的所在非常多時候，我們想要研究oracle的內部活動或后臺操作也能通過sql_trace跟蹤sql_trace/10046 是oracle提供的最為有效的診斷工具之
黨政相關相關推薦
鄂ICP備17016276號-1