Entries tagged as Oracle DBA

Advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode

On June 23, 2009 / By admin / In Oracle DBA / No Comments
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?   Complete database recovery from disk failure is possible only in ARCHIVELOG mode. Online database backup is possible only in ARCHIVELOG mode. Read More...
Tags:

Full Backup when the database is open

On June 23, 2009 / By admin / In Oracle DBA / No Comments
Can Full Backup be performed when the database is open ?   No. Read More...
Tags:

Undocumented commands in Oracle

On June 22, 2009 / By admin / In Oracle DBA / No Comments
Are there any undocumented commands in Oracle?   Sure there are, but it is hard to find them. Look at these examples: From Server Manager (Oracle7.3 and above): ORADEBUG HELP It looks like one can change memory locations with the ORADEBUG POKE command. Anyone brave enough to test this one for us? Previously this functionality Read More...
Tags:

Use ORADEBUG from Server Manager

On June 22, 2009 / By admin / In Oracle DBA / No Comments
How does one use ORADEBUG from Server Manager/ SQL*Plus?   Execute the “ORADEBUG HELP” command from svrmgrl or sqlplus to obtain a list of valid ORADEBUG commands. Look at these examples: SQLPLUS> REM Trace SQL statements with bind variables SQLPLUS> oradebug setospid 10121 Oracle pid: 91, Unix process pid: 10121, image: oracleorcl SQLPLUS> oradebug EVENT Read More...
Tags:
« Browse Newer Entries
Browse Older Entries »

SEO Powered By SEOPressor