Anuj Singh Oracle DBA
Sunday, 23 July 2023
ORA-19906: recovery target incarnation changed during recovery
›
ORA-19906: recovery target incarnation changed during recovery http://anuj-singh.blogspot.com/2021/10/rman-restore-database.html RMAN> ru...
Tuesday, 18 July 2023
Oracle initialization parameter changes from AWR
›
Oracle initialization parameter changes Oracle initialization parameter changes Oracle initialization parameter changes Oracle initia...
Monday, 17 July 2023
ORACLE event to Sql ....
›
ORACLE event to Sql .... VARIABLE BgnSnap NUMBER VARIABLE EndSnap NUMBER VARIABLE DID NUMBER VARIABLE INST_NUMBER number VARIABLE x VARCH...
Thursday, 13 July 2023
How do I find my own session's serial# ?
›
How do I find my own session's serial# ? My session col USERNAME for a20 col event for a30 select sid, serial#, username ,sq...
Tuesday, 4 July 2023
Oracle metadata for FUNCTION
›
Oracle metadata for FUNCTION set linesize 300 pagesize 300 col USERNAME for a20 col PASSWORD_LIFE_TIME for a20 SET LONG 10000 LON...
Friday, 23 June 2023
Oracle Create spfile from memory
›
Oracle Create spfile from memory create spfile from memory; create spfile from memory * ERROR at line 1: ORA-32002: cannot create SP...
Tuesday, 6 June 2023
ORA-12838: cannot read/modify an object after modifying it in parallel
›
ORA-12838: cannot read/modify an object after modifying it in parallel INSERT /*+ APPEND */ INTO spm_test_tab SELECT level, ...
‹
›
Home
View web version