oracle-dba

Popular Posts

Your DB Scripts Here

update db scripts page
Overview of ORA-1000 Maximum Number of Cursors Exceeded

Problem Description: ==================== One of the most common errors that occurs is an ORA-01000: ORA-01000: "maximum open cursor...
Database Activities

Activities Here
Link to Tape backup Library for Oracle Database

backup incremental level 0 database using target database control file instead of recovery catalog RMAN-00571: ============================...
How to find current session ID

How to find current session ID Way1: select sid from v$session where sid=(select sid from v$mystat where rownum =1); Way2: select sid...

export PS1=`hostname`:$(whoami)\['$ORACLE_SID'\]'$ '

Posted by Abul