Background Processors

Background Processors PMON : It is responsible for following actions releases the locks and resources held by abruptly terminated sessions Note: whenever any user performs DML transactions on a table, oracle will apply lock. This is to maintain read consistency authenticates the user registers the listener information with the instance …

Read More »

SMON’s instance recovery with example

EXAMPLE 1

SMON’s instance recovery with example EXAMPLE : 1 In the above diagram, assume that 1,2 and 3 transactions are commited and 4 is going on. Also as checkpoint occurred at log switch, complete data of 1 and 2, also part of 3 were written to datafiles Assume LGWR is writing …

Read More »

COMPONENTS OF ORACLE DATABASE ARCHITECTURE

REDOLOG FILES & CONTROL FILES INTERVIEW QUESTIONS

COMPONENTS OF ORACLE DATABASE ARCHITECTURE USER PROCESS : It is the process which places request from client side and will be created when user starts any application. SERVER PROCESS : It is the process which will do work on behalf of user process on server side. PRIVATE GLOBAL AREA (PGA) …

Read More »

LOGICAL STRUCTURES OF DATABASE

LOGICAL STRUCTURES OF DATABASE

LOGICAL STRUCTURES OF DATABASE The following are the logical structures of database and will be helpful in easy manageability of the database TABLESPACE – an alias name to a group of datafiles (or) group of segments (or) a space where tables reside SEGMENT – group of extents (or) object that …

Read More »

PHASES OF SQL EXECUTION

SELECT STATEMENT PROCESSING

PHASES OF SQL EXECUTION Any SQL statement will undergo following phases to get executed PARSING : This phase will perform following actions Syntax checking of the SQL statement Semantic checking of the statement i.e. checking for the privileges using base tables Diving the statement into literals EXECUTION : This phase …

Read More »

OPERATING SYSTEM FUNCTIONALITY THEORY

OPERATING SYSTEM FUNCTIONALITY

 OPERATING SYSTEM FUNCTIONALITY Whenever user sends a request, primary search for the data will be done in RAM. If the information is available, it will be given to the user. Otherwise, secondary search will be done in hard disk and copy of that info will be placed in RAM before …

Read More »

Upgrading to Oracle Database 10G to 11G

Upgrading to Oracle Database 10g to 11g

Upgrading to Oracle Database 10g to 11g Upgrade Oracle Database 10g to 11g Manual Upgrade We are going to use Manual Upgrade Install 11g database software in different ORACLE_HOME from source Database [email protected]:/opt/app/oracle/product/11.1/rdbms/admin> pwd /opt/app/oracle/product/11.1/rdbms/admin [email protected]:/opt/app/oracle/product/11.1/rdbms/admin> ls -lt utlu111i.sql -rw-r–r– 1 oracle oinstall 138636 2007-07-11 09:01 utlu111i.sql [email protected]:/opt/app/oracle/product/11.1/rdbms/admin> pwd /opt/app/oracle/product/11.1/rdbms/admin …

Read More »

Creating a Physical Standby Database – Data Gaurd

Creating a Physical Standby Database - Data Gaurd

Creating a Physical Standby Database This chapter steps you through the process of creating a physical standby database. It includes the following main topics: Preparing the Primary Database for Standby Database Creation Step-by-Step Instructions for Creating a Physical Standby Database Post-Creation Steps The steps described in this chapter configure the …

Read More »

Partitioned Tables and Indexes

Partitioned Tables and Indexes

Partitioned Tables And Indexes Maintenance of large tables and indexes can become very time and resource consuming. At the same time, data access performance can reduce drastically for these objects. Partitioning of tables and indexes can benefit the performance and maintenance in several ways. Partition independence means backup and recovery …

Read More »

Performance Tuning using SQL Tuning Advisor

Performance Tuning using SQL Tuning Advisor

SQL Tuning Advisor SQL Tuning Advisor analyzes individual SQL statements, and recommend SQL profiles, statistics, indexes, and restructured SQL to SQL performance. The optimizer uses the current object’s statistics and the SQL structure to generate the execution plan for a SQL statement. It is important that the optimizer determines the …

Read More »
DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.
close-link
GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Enquiry
Submit
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe