In some scenarios , my database may be hung and as a DBA ,I have terminate all Oracle processes associated with my hung database. Steps to kill oracle process and release memory associated by oracle server 1. Kill all Oracle processes associated with the ORACLE_SID Executing following command we can check all oracle process associated [...]
Published by Paresh Sarma //
How Recovery Manager (RMAN) perform backup of target database ? Following is an example for taking backup of target database with RMAN.For easy understanding,assume target database orcltarget01 and catalog database as orclrman. Simple steps to backup the database with Recovery Manager Steps -I : Execute the following command windows C:\> set ORACLE_SID=orcltarget01 Steps -II : [...]
Published by Paresh Sarma //
Recovery Manager configuration is very simple and straightforward process.Two ways we can configure RMAN backup. Command line version Web-based GUI through EM database control There are many parameters of RMAN can control for better utilization and performance of backup and recovery process.The parameters can be configured through Oracle Enterprise Manager or RMAN command line option. [...]
Published by Paresh Sarma //
The undo data is used for the following database operations Rollback of a transaction Read consistency of DML operations and queries Database recovery operations Flashback functionality like analyzing data as of an earlier point in time and recover from logical corruptions using Flashback features Configuring the Undo tablespace In oracle database 10g, if undo tablespace [...]
Published by Paresh Sarma //
There are different ways to kill oracle sessions From SQL*PLUS From UNIX From Windows Killing Oracle Session from SQL*PLUS Executing ALTER SYSTEM KILL SESSION command from SQL*PLUS prompt , we can kill oracle session. Before going to kill oracle session , we have to identify those using the following DDL statement. SELECT sid, serial#, osuser, [...]
Published by Paresh Sarma //
The sharing of SQL areas reduces memory use on the database server and it increases system throughput ,finally it impact on performance of the database . Before executing SQL statements ,which is issued by users or applications as well as the recursive SQL statements by a DDL statement, oracle evaluates it as identical or similar. [...]
Published by Paresh Sarma //
Before going to differentiate the SQL hard parse and SQL Soft parse , we will understand what is hard and soft Parse. We know that before going to execute a SQL statement oracle parsed it . In case of hard parse following steps occurs. Loading SQL -The SQL source code is loaded into shared pool [...]
Published by Paresh Sarma //
Automatic Workload Repository(AWR) is a new features of Oracle 10G, used to database monitoring. Oracle 10G,introduces two new background process to work for Automatic Workload Repository (AWR) , includes: Memory Monitor(MMON) Memory Monitor Lite(MMNL) These two processes work together to collect performance statistics directly from the System Global Area(SGA). The MMON process gather statistical information [...]
Published by Paresh Sarma //
Monitoring database for potential database problems impact the availability or performance of the database. Oracle DBA can use third-party tolls ,Oracle Enterprise manager suite or custom made scripts to gather database performance statistics and analyze those information for successfully maintenance of oracle database. Oracle 10g, introduces several new features for DBAs to easily collect and [...]
Published by Paresh Sarma //
Instance failure prevents the synchronization of the database’s datafiles and control file before the instance is shutdown. Oracle automatically recovers the instance failure when starting up the database with the STARTUP command. The main purpose of the instance failure is to bring the control file and database file to the same SCN. Instance recover occurs [...]
Published by Paresh Sarma //
