IN ORACLE MILIEU …

Beyond Knowledge

Category Archives: Oracle Database 9i

Exchange Partition in Oracle

5 Comments Posted by on March 30, 2011

Some times we faced a need to convert our existing table from non-partition table to a partition table or vice-versa. Or moving a partition of one partition table to another partition. Or make one of the table as a partition of some partition table. Or make a partition of one of the partition table as [...]

Oracle Database 10g, Oracle Database 9i , ,

Virual Index and Invisible Index

Leave a Comment Posted by on March 23, 2011

Oracle has come up with a feature called virtual index in oracle 9i. This feature allow us to test an index on a table without actually adding an index on the table. The table will be visible only in our session and will be used by our queries only (if optimizer decide it to use). [...]

Oracle Database 10g, Oracle Database 11g, Oracle Database 9i ,

Oracle Database 9i Interview Questions

3 Comments Posted by on November 1, 2010

Intention of this post is to get as much interview question for Oracle DBA as possible to help you get the idea about the type of questions you can expect in interviews and exams. This will help you in increasing the knowledge about oracle database 9i as some of the questions may be new to [...]

Interview Questions, Oracle Database 9i ,

OPATCH Utility (Oracle RDBMS Patching)

15 Comments Posted by on August 19, 2008

Introduction: This post has been written on request of one of regular visitor of my blog (Altaaf). This post is all about Oracle Patching Utility (OPATCH) and various options that can be used along with Opatch. We will begin the discussion by knowing what exactly is Opatch? – OPatch is a java based utility that [...]

Oracle Database 10g, Oracle Database 11g, Oracle Database 9i , ,

Shared Memory and Semaphores – Oracle Database

Leave a Comment Posted by on June 27, 2008

Introduction: Some times if the database shut down is not graceful, shared memory wont be released. In that case if you try to login and start the database you will get following error. -bash-2.05b$ sqlplus /nolog SQL*Plus: Release 8.1.7.0.0 – Production on Thu Jun 26 12:57:25 2008 (c) Copyright 2000 Oracle Corporation.  All rights reserved. [...]

Oracle Database 10g, Oracle Database 9i , , ,

Interested Transaction List (ITL)

9 Comments Posted by on June 16, 2008

Introduction This post gives a brief idea about how Oracle locks the rows on behalf of the transactions. Before going further on locking, it will be good for you to check the previous post on transaction management to understand the isolation levels of Oracle. Here we will discuss an important area present inside Oracle block [...]

Oracle Database 10g, Oracle Database 9i , ,

Oracle Database Recovery Details

5 Comments Posted by on May 29, 2008

Recovery Fundamentals: This post is to give you information about various recovery fundamental details and how recovery works. We will start by looking at various SCNs and where they are stored. There are 3 SCNs basically in control file Checkpoint SCN Stop SCN Thread checkpoint SCN Checkpoint SCN is the datafile checkpoint SCN when checkpoint [...]

Oracle Database 9i , ,

Excess redo log generation during Hot Backup – Oracle 9i

24 Comments Posted by on May 27, 2008

Many of you must have heard or experienced that while taking hot backup of database LGWR process writes aggressively. Meaning that more redo data has been written to redo log file and consecutively more archive logs gets generated. Here is the common misconception we have in our mind. If some one ask, why excessive redo [...]

Oracle Database 9i , , ,

Oracle 9i Undo Management

3 Comments Posted by on April 14, 2008

Introduction So much to tell about undo management that even this post is not sufficient to explain the concept. Well a small effort to explain the undo concept in Oracle Database 9i. Lets start with the main funda and then we will see how automatic undo management and manual undo management differs. We will also [...]

Oracle Database 9i , , , ,

Oracle Database 9i – Basic Architecture

19 Comments Posted by on April 9, 2008

Introduction This post is regarding the basic database architecture for 9i. Its been very late to upload this basic stuff, but I realized that it would be an incomplete blog without having even a brief architecture. So here it is. Below is the figure which gives a overview of “Inside Oracle”. An Oracle database is [...]

Oracle Database 9i , , , , ,

← Older posts

Follow

Get every new post delivered to your Inbox.

Join 136 other followers