Anuj Singh Oracle DBA
Friday, 11 November 2022
Oracle long running SQL
›
Oracle long running SQL ... long running SQL long running SQL queries set pages 300 lines 300 col OPNAME for a10 col SID form 9999 col ...
ORA-12537: TNS:connection closed
›
ORA-12537: TNS:connection closed sqlplus 'sys@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=xyrac02.***.***.*******.com)(Port=1521)...
Oracle Hub Report
›
Oracle Performance Hub Report. Performance Hub Report Oracle Database - Enterprise Edition - Version 12.1.0.2 and later <<<<...
Wednesday, 5 October 2022
How to Recover a Table from Oracle 12c via RMAN Backup ?
›
How to Recover a Table from an Oracle 12c RMAN Backup How to Recover a Table from Oracle 12c via RMAN Backup ? on same server . Table ...
Monday, 19 September 2022
Oracle >18c Rman Duplication of a PDB To another CDB
›
Oracle >18c Rman Duplication of a PDB To another CDB .. Oracle >18c Rman Duplication of a PDB To another CDB PDB Duplication sourc...
Friday, 16 September 2022
RMAN JOBs in Detail and monitoring
›
RMAN JOBs in Detail and monitoring define 1='14-09-20 15:19:57' --- Change based on your requirement -- open_time >sysdate -1...
Wednesday, 14 September 2022
dbms_xplan.display_cursor with gather_plan_statistics hint
›
dbms_xplan.display_cursor with gather_plan_statistics hint gather_plan_statistics hint -- Table Create ---- create table teststats as s...
‹
›
Home
View web version