Anuj Singh Oracle DBA
Sunday, 12 December 2021
Awr topsegments space used ----
›
from Awr top segments space used .... Awr topsegments space used from https://github.com/karlarao/run_awr-quickextract/blob/master/run_awr_...
Wednesday, 8 December 2021
long running query session longops
›
long running query session longops .... long running query session longops -- http://anuj-singh.blogspot.com/2014_08_25_archive.html se...
Wednesday, 17 November 2021
Which sql is causing my cluster waits?
›
Which sql is causing my cluster waits? from Cluster Waits to sql define p_inst=1 define p_days=7 column dt heading 'Date/Hour...
Wednesday, 3 November 2021
Archivelog info..
›
Archivelog info.. set linesize 300 pagesize 300 col name for a90 col first_time for a16 select thread#,sequence#, name ,creator -- , to...
Friday, 15 October 2021
Oracle Undo Tablespace recovery
›
Oracle Undo TTablespace recovery oracle@apt-amd-02:/opt/app/oracle/oradata/orcl> !sql sqlplus / as sysdba SQL*Plus: Release 11.2.0.1...
My alias
›
alias alias alias +='pushd .' alias -='popd' alias ..='cd ..' alias ...='cd ../..' alias apt-win1='rd...
DBMS_REPAIR SCRIPT (Doc ID 556733.1)
›
BEGIN DBMS_REPAIR.ADMIN_TABLES ( TABLE_NAME => 'REPAIR_TABLE', TABLE_TYPE => dbms_repair.repair_table, ACTION => dbms_...
‹
›
Home
View web version