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_snapshot
awr snapshot details
dbtimevalue
dbtimevalue
snap_waiteven snap_waitevent
totsql to
check heavy operations in the db.
dbtimevalue to check waitevents for
historical time
dbtime to
check top queries
sgausage
to check sga/pga usage over time
shparam
to check db shared memory_utli i
osload to
check historical server load/CUP utilization
tdba_hist_snapshot to check redo/commit
tdba_hist_snapshot_full to check logon/cpu/load and other OS
related hist info
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.
Audit
audittype
to check if standard/fga/unified/mixed mode audit
auditopts to check all standard audit options
enabled
User MGMT
privscheck to check user lastlogin,status,object details etc.
RAC
diskgroup to check diskgroup and LUN details
No comments:
Post a Comment