Anuj Singh Oracle DBA
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_...
session_wait_history.sql
›
SET TIME ON VERIFY OFF COLUMN event FORMAT A30 HEADING 'Event' TRUNCATE COLUMN wait_state ...
Saturday, 2 October 2021
RMAN: restore database
›
Oracle RMAN: restore database .. https://anuj-singh.blogspot.com/2010/01/oracle-datafile-need-recovery.html export TWO_TASK= export N...
4 comments:
‹
›
Home
View web version