DBA Scripts Repository

Active Session Waits Ash Datapump Jobs Db Usage Hwm Dynamic Memory Event Histogram Feature Usage Flashback Db Info Generate Multiple Awr Reports Job Chain Rules Job Chain Steps Job Chains Job Classes Job Programs Job Running Chains Job Schedules Jobs Jobs Running Lock Tree Scheduler Attributes Segment Advisor Services Session Waits Sga Buffers Sga Dynamic Components Sga Dynamic Free Memory Sga Resize Ops Sysaux Occupants Test Calendar String Window Groups Windows

Admin Privs Autotask Change Window Schedules Autotask Job History Autotask Schedule Database Block Corruption Default Passwords Diag Info Extended Stats Fda Fda Tables Fda Ts Identify Trace File Job Credentials Job Output File Job Run Details Memory Dynamic Components Memory Resize Ops Memory Target Advice Network Acl Privileges Network Acl Privileges By Host Network Acls Result Cache Objects Result Cache Report Result Cache Statistics Result Cache Status Session Fix Statistics Global Prefs System Fix System Fix Count Temp Free Space

Cdb Resource Plan Directives Cdb Resource Plans Cdb Resource Profile Directives Clustering Dimensions Clustering Joins Clustering Keys Clustering Tables Credentials Host Aces Host Acls Lockdown Profiles Login Pdb Spfiles Pdbs Plugin Violations Priv Captures Redaction Columns Redaction Policies Redaction Value Defaults Services

Lockdown Rules Max Pdb Snapshots Pdb Snapshot Mode Pdb Snapshots

Auto Index Config Auto Indexes

Blockchain Tables Certificates Sql Macros

Disable Chk Disable Fk Disable Pk Disable Ref Fk Enable Chk Enable Fk Enable Pk Enable Ref Fk

Deploy App Deploy App.Py Session-Snapper Start-Domain Start-Forms-Reports Start-Node-Manager Stop-Domain Stop-Forms-Reports Stop-Node-Manager

Analyze All Base64Decode Base64Encode Blob To Clob Blob To File Clob To Blob Clob To File Column Comments Comments Compile All Compile All Bodies Compile All Funcs Compile All Procs Compile All Specs Compile All Trigs Compile All Views Conversion Api Csv Date Api Dict Comments Digest Auth Api Drop All File To Blob File To Clob Find Object Gen Health Get Pivot Get Stat Login Part Hv To Date Print Table Proc Defs Rebuild Index Smart Quotes Api Soap Api String Agg String Api Switch Schema Table Comments Table Defs Table Differences Ts Move Api

Access Active Sessions Active User Sessions Cache Hit Ratio Call Stack Code Dep Code Dep Distinct Code Dep On Code Dep Tree Column Defaults Controlfiles Datafiles Db Cache Advice Db Info Db Links Db Links Open Db Properties Default Tablespaces Df Free Space Directories Directory Permissions Directory Permissions All Dispatchers Error Stack Errors Explain File Io Find Packaged Proc Fk Columns Fks Free Space Health Hidden Parameters High Water Mark Hot Blocks Identify Trace File Index Extents Index Monitoring Status Index Partitions Index Usage Invalid Objects Jobs Jobs Running Large Lob Segments Large Segments Latch Hit Ratios Latch Holders Latches Library Cache License Locked Objects Locked Objects Internal Logfiles Longops Lru Latch Ratio Max Extents Min Datafile Size Monitor Monitor Memory Monitoring Status My Roles Nls Params Non Indexed Fks Obj Lock Object Privs Object Status Objects Open Cursors Open Cursors By Sid Open Cursors Full By Sid Options Packaged Procs Param Valid Values Parameter Diffs Parameters Parameters Non Default Part Tables Patch Registry Pga Target Advice Pipes Profiler Run Details Profiler Runs Profiles Proxy Sessions Proxy Users Rbs Extents Rbs Stats Recovery Status Recyclebin Redo By Day Redo By Hour Redo By Min Registry History Role Privs Roles Search Source Segment Size Segment Stats Segments In Ts Session Events Session Events By Sid Session Events By Spid Session Io Session Pga Session Rollback Session Stats Session Stats By Sid Session Undo Session Waits Sessions Sessions By Machine Sessions By Osuser Sessions By Sid Show Indexes Show Space Show Tables Source Spfile Parameters Sql Area Sql Text Sql Text By Sid Statistics Prefs Synonyms To Missing Objects System Events System Parameters System Privs System Stats Table Dep Table Extents Table Growth Table Indexes Table Partitions Table Stats Table Triggers Tables With Locked Stats Tables With Zero Rows Tablespaces Temp Extent Map Temp Free Space Temp Io Temp Segments Temp Usage Tempfiles Tempseg Usage Top Latches Top Sessions Top Sql Trace Run Details Trace Runs Ts Datafiles Ts Extent Map Ts Free Space Ts Full Ts Thresholds Ts Thresholds Reset Ts Thresholds Set Default Tuning Undo Segments Unusable Indexes Unused Space User Hit Ratio User Objects User Roles User Sessions User System Privs User Temp Space User Ts Quotas User Undo Space Users Users With Role Users With Sys Priv

Dba Ords Client Roles Dba Ords Clients Dba Ords Handler Content Dba Ords Handlers Dba Ords Modules Dba Ords Objects Dba Ords Privilege Mappings Dba Ords Privilege Modules Dba Ords Privilege Roles Dba Ords Privileges Dba Ords Roles Dba Ords Schemas Dba Ords Templates Dba Ords Views User Ords Client Roles User Ords Clients User Ords Handler Content User Ords Handlers User Ords Modules User Ords Objects User Ords Privilege Mappings User Ords Privilege Modules User Ords Privilege Roles User Ords Privileges User Ords Roles User Ords Schemas User Ords Templates User Ords Views

Locked Objects Rac Longops Rac Monitor Memory Rac Session Undo Rac Session Waits Rac Sessions Rac

Active Plan Consumer Group Usage Consumer Groups Plan Directives Resource Plans

Backup Build Api Build Api2 Create Data Db Link Ddl Directory Ddl Drop Cons On Table Drop Fks On Table Drop Fks Ref Table Drop Indexes Fks On Table Ddl Fks Ref Table Ddl Index Monitoring Off Index Monitoring On Job Ddl Logon As User Logon As User Orig Monitoring Off Monitoring On Network Acls Ddl Object Grants Profile Ddl Rbs Structure Recreate Table Role Ddl Sequence Ddl Synonym By Object Owner Ddl Synonym Ddl Synonym Public Remote Ddl Table Constraints Ddl Table Ddl Table Grants Ddl Table Indexes Ddl Table Triggers Ddl Tablespace Ddl Tablespace Structure Trigger Ddl User Ddl View Ddl

Grant Delete Grant Execute Grant Insert Grant Select Grant Update Package Synonyms Schema Write Access Sequence Synonyms Table Synonyms View Synonyms

Deploy App Deploy App.Py Start-Domain Start-Forms-Reports Start-Node-Manager Stop-Domain Stop-Forms-Reports Stop-Node-Manager