Script Repository

#00b0f0

pgausage                    to check database status
cpuusage                    to check current r/w ops
perf_status                 to check for performance improvement
db_spec                      to check database specifications
redo_nums                  redo information

##AWR

snaps                            awr snapshot details
awr_snapshot               awr snapshot details
db-aas                           DB- AAS  

                                        snapshot - begin/end

tdba_hist_snapshot_full  to check logon/cpu/load and other OS related hist info 
snap_waiteven                snap_waitevent
dbtimevalue                    to check waitevents for historical time
dbtime                             to check top queries

osload                           to check historical server load/CUP utilization  

totsql                            to check heavy operations in the db.
tdba_hist_snapshot         to check redo/commit 

shparam                        to check db shared memory_utli i 
sgausage                        to check sga/pga usage over time

sqlid_info                 to check child# and plan
nums_sql                  to analyze sql_id
sqlid_wait                 to analyze sql_id
sqlid_object :            object involved with sql_id
sql_card   :                 to check objects cardinality/explain plan

table spec                 table spec
table specification    table specification
table stat history       table stat history


  index details              index detail

 SQL analysis

  Unstable plan                   oracle plan change in last 24 hours
  extensive_sql                      oracle ash extensive sqls (same as above)
  awr_sql_execution_tot      to check number of active plans and time spent
  awrstat_timeseen               to check avg time and LIP for each plan
  sql_relative_card                to check relative cardiality for each plan
  sql_check                            to check any ative baseline or profile assigned before adding one.

 

sess_details                           to find useful info of current active sessions in the database.
long_running_msg                long running query in db

Audit
secusage                            to check standard security features enabled YES/NO

audittype                           to check  if standard/fga/unified/mixed mode audit
auditopts                            to check all standard audit options enabled 
auditopts_type                   Check standard audit with filter like user,table etc.

ta_failedlogin                         traditional db audit failed login attempt in last 1 minute

os_auditmon_action               parse os audit logs for all the actions 
os_auditmon_user                  parse os audit logs for particular user actions

ua_rolehisotry                       unified audit for grant/revoke permission
ua_userhistory                       unified audit to check create/drop user audit
ua_failedlogin                       unified audit failed attempts in 24 hours 
ua_auditopts                          Check UA audit with filter like user,table,log etc.

User MGMT

 privscheck                 to check user lastlogin,status,object details etc.

RAC

diskgroup                   to check diskgroup and LUN details

Performance Tunning

locking                          to check locked object with lmode plus blocking as well
blocking                        blocking session, OEM 
blocking_chain             Multi level blocks
blocking_chain2           Multilevel blocking with waiter and holder

 

 

ts_usage_graph             Tablespace usage graph 
shrink_ts                       Shrink tablespace.  prompt for ts
shrink_ts_ALL             Shrink ts all in db

 

redo_num                      Redo dest and available path 

arc_hour                        Hourly archive generate rate 
arc_day                         Daily archive generate rate 
arc_pivot                      Archive generate day/hour     
arc_history_pivot          Archive generate day/hour from v$log_history, usually double calc
arc_status                      Archive status - avaialbe, backed up, deleted etc.. 
arc_dest                        Arch dest.. all.. local, standby, gg etc..   

 

 Futurepot.com/2026/04/

ua_auditopts                          to check standard security features enabled YES/NO
blocking                        blocking session, OEM 
blocking                        blocking session, OEM 
blocking_chain             Multi level blocks
blocking_chain2           Multilevel blocking with waiter and holder

locking                          to check locked object with lmode plus blocking as well
blocking                        blocking session, OEM 
blocking_chain             Multi level blocks
blocking_chain2           Multilevel blocking with waiter and holder

locking                          to check locked object with lmode plus blocking as well
blocking                        blocking session, OEM 
blocking_chain             Multi level blocks
blocking_chain2           Multilevel blocking with waiter and holder

locking                          to check locked object with lmode plus blocking as well
blocking                        blocking session, OEM 
blocking_chain             Multi level blocks
blocking_chain2           Multilevel blocking with waiter and holder

locking                          to check locked object with lmode plus blocking as well
blocking                        blocking session, OEM 
blocking_chain             Multi level blocks
blocking_chain2           Multilevel blocking with waiter and holder

locking                          to check locked object with lmode plus blocking as well
blocking                        blocking session, OEM 
blocking_chain             Multi level blocks
blocking_chain2           Multilevel blocking with waiter and holder

locking                          to check locked object with lmode plus blocking as well
blocking                        blocking session, OEM 
blocking_chain             Multi level blocks
blocking_chain2           Multilevel blocking with waiter and holder