oracle DBA日常脚本

脚本目录 Constriants ...........\Disable_Chk.sql ...........\Disable_FK.sql ...........\Disable_PK.sql ...........\Disable_Ref_FK.sql ...........\Enable_Chk.sql ...........\Enable_FK.sql ...........\Enable_PK.sql ...........\Enable_Ref_FK.sql Miscellaneous .............\Analyze_All.sql .............\Compare_Schemas.sql .............\Compile_All.sql .............\Compile_All_Bodies.sql .............\Compile_All_Funcs.sql .............\Compile_All_Procs.sql .............\Compile_All_Specs.sql .............\Compile_All_Trigs.sql .............\Compile_All_Views.sql .............\conversion_api.sql .............\drop_all.sql .............\dsp.pkb.txt .............\dsp.pks.txt .............\err.pkb.txt .............\err.pks.txt .............\ftp.pkb .............\ftp.pks .............\Gen_Health.sql .............\get_pivot.sql .............\login.sql .............\proc_defs.sql .............\Rebuild_Index.sql .............\soap_api.sql .............\switch_schema.sql .............\table_defs.sql .............\Table_Differences.sql .............\trc.pkb .............\trc.pks Monitoring ..........\Access.sql ..........\Cache_Hit_Ratio.sql ..........\Call_Stack.sql ..........\Code_Dep.sql ..........\Column_Defaults.sql ..........\Comments.sql ..........\DB_Info.sql ..........\Dict_Comments.sql ..........\Dispatchers.sql ..........\Errors.sql ..........\Error_Stack.sql ..........\Explain.sql ..........\File_IO.sql ..........\FKs.sql ..........\Free_Space.sql ..........\Free_Space_TableSpace.sql ..........\Health.sql ..........\High_Water_Mark.sql ..........\Index_Extents.sql ..........\Index_Partitions.sql ..........\Jobs.sql ..........\Jobs_Running.sql ..........\Latches.sql ..........\Latch_Hit_Ratios.sql ..........\Latch_Holders.sql ..........\Library_Cache.sql ..........\License.sql ..........\Locked_Objects.sql ..........\Login.sql ..........\longops.sql ..........\LRU_Latch_Ratio.sql ..........\Max_Extents.sql ..........\Monitor.sql ..........\Monitoring_Status.sql ..........\Monitor_Memory.sql ..........\Non_Indexed_FKs.sql ..........\Object_Status.sql ..........\Obj_Lock.sql ..........\Open_Cursors.sql ..........\Pipes.sql ..........\RBS_Extents.sql ..........\RBS_Stats.sql ..........\Recovery_Status.sql ..........\Roles.sql ..........\Search_Source.sql ..........\Sessions.sql ..........\Show_Space.sql ..........\Source.sql ..........\SQL_Area.sql ..........\SQL_Text.sql ..........\System_Parameters.sql ..........\Table_Dep.sql ..........\Table_Extents.sql ..........\Table_Indexes.sql ..........\Table_Partitions.sql ..........\Table_Stats.sql ..........\Temp_Segments.sql ..........\Top_SQL.sql ..........\TS_Extent_Map.sql ..........\TS_Full.sql ..........\Tuning.sql