Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Blog Directory  >  Software Blogs  >  Programming Blogs  >  Oracle Database Administration programming Blog  > 

2013-09-05 13:28
LatchOracle SGA consists of numerous data structures such as Buffer Cache, Shared pool, Library cache, Dictionary cache, redo log buffer etc. Many oracle processes need to access these SGA d… Read More
2013-08-01 11:18
The segment shrink is done online. During shrink operation, the conventional DML operations can coexist but parallel DMLs cannot.During segment shrink, data will be moved as part of the comp… Read More
2011-02-10 11:46
Problem: I have lost some of the archivelog files without taking backup. If I run the rman to backup available archive logs, it throws error that the archivelog_seq# is not available.Solutio… Read More
2010-07-17 13:08
It has become easier to drop a database from Oracle 10g. Use the DROP DATABASE command to drop the database. It removes the datafiles, redologs, controlfiles and init parameter files.$ sqlpl… Read More
2010-03-02 11:12
RMAN Incremental Backups backup only the blocks that were changed since the lastest base incremental backups. But RMAN had to scan the whole database to find the changed blocks. Hence the in… Read More
2010-02-24 22:19
RMAN List Command queries the target control file or the recovery catalog for the historical information on the backups. The various options you can use with List command and their uses are… Read More
2010-02-24 19:46
The following are the commands you can type from the RMAN prompt.{allocatealterbackupbeginlineblockrecovercatalogchangeconnectcopycreatecrosscheckconfigureduplicatedebugdeletedropexitendinli… Read More
2010-02-09 22:41
Step 1: Set the following environment variablesORACLE_SIDORACLE_HOMENLS_DATE_FORMATStep 2: Access to privileged OS account or user with Sysdba privilege. Only users with Sysdba privilege can… Read More
2010-01-19 21:01
The password file is used to authenticate the users connecting to the database as Sysdba or Sysoper. The password file is created with the orapwd utility as follows,$ cd $ORACLE_HOME/dbs$ o… Read More
2010-01-08 13:36
The following V$views are used for managing ASM.View NameDescriptionInstanceV$ASM_DISKGROUPDiskgroups discovered by ASMDBV$ASM_DISKDisks discovered by ASM including disks that are not part o… Read More

Share the post

Oracle Database Administration


Subscribe to Oracle Database Administration

Get updates delivered right to your inbox!

Thank you for your subscription