How does the SMON process performs recovery after instance failure?

ranjithsv18

• Oct 2nd, 2013

When hardware failure, software failue and shutdown abnormally happen... SMON taking care of Instance failure, coalesce failure space and deallocating temp segment start to recover instance Roll fw...

Nagaraj OCP

• Dec 27th, 2011

When shutdown abort happens, oracle server gets crashed. To recover from the crash, SMON will check the online Redo data files and last SCN no in the Redo log files and SCN number in the undo tablespa...

Answer Question  Select Best Answer

How we can determine the physical architecture of oracle?

ranjithsv

• Oct 2nd, 2013

Datafiles(*.dbf),
Controlfiles(*.ctl),
Redologfiles(*.log),
Archivelogfiles(*.arc)

ARUN BHUKKER

 Profile Answers by ARUN BHUKKER Questions by ARUN BHUKKER

• Oct 19th, 2012

Oracle architecture consist of four structures: 1. Memory structure (SGA, PGA) 2. Process structure (user process, server process, background process) 3. Physical structure (data files, redo log files...

Answer Question  Select Best Answer

sandeep

• Apr 26th, 2013

Ps -ef | grep oracle

chittu.kotian

 Profile Answers by chittu.kotian Questions by chittu.kotian

• May 16th, 2012

On Unix the command is ps -aef | grep -i pmon

Answer Question  Select Best Answer

What is the use of archive log file? How will you apply archive log file? How does archive log file helps to make backup consistent?

ARUN BHUKKER

 Profile Answers by ARUN BHUKKER Questions by ARUN BHUKKER

• Oct 19th, 2012

A Archive log file is used to archive the filled redo log files. and used in recovery.

It is used in recovery but not in instance recovery.
Rest it is used to make database consistent after recovery by matching header of data file and control file checkpoint information.

rsona

 Profile Answers by rsona Questions by rsona

• Mar 2nd, 2011

Hello Ganesh,Q : What is the use of archive log file? A : It is used for Point In Time Database Instance Recovery.     Q : How will you apply archive log file? A : Archive Log need...

Answer Question  Select Best Answer

Where does the process dumps information about the error?

ARUN BHUKKER

 Profile Answers by ARUN BHUKKER Questions by ARUN BHUKKER

• Oct 19th, 2012

Errors are stored in alert.log file it can be shecked using the parameter background_dump_dest

Use show parameter background_dump_dest
for path of the alert.log in trace directory

matabrez

 Profile Answers by matabrez Questions by matabrez

• Jan 10th, 2011

Alerts will log to alert.log  and alert trace files will be saved in  $ORACLE_HOME/admin/bdump directory.

Answer Question  Select Best Answer

A schema is collection of database objects of a User.

ARUN BHUKKER

 Profile Answers by ARUN BHUKKER Questions by ARUN BHUKKER

• Oct 19th, 2012

A schema is the set of objects (tables, views, indexes, etc) that belongs to an user account. It is often used as another way to refer to an Oracle account. Most Oracle database installations traditio...

Mohammad Mujeeb

• Oct 25th, 2011

Schema is a collect of object (table,view,cluster etc) that belongs to an user account.

Answer Question  Select Best Answer

The Information in a redo log file is used only to recover the database from a system or media failure prevents database data from being written to a database's data files.

Dinesh Chandra

• Aug 27th, 2012

Redo log records the changes made in database. Redo logs is mainly used to recover data.

rohitmisri

 Profile Answers by rohitmisri Questions by rohitmisri

• Jun 17th, 2010

Hi,Redo log information is the one of the major pard of the database , at any time if the oracle server instance get aborted and then it need recovery, so at that time redo log plays a role to recover...

Answer Question  Select Best Answer

Private database link is created on behalf of a specific user. A private database link can be used only when the owner of the link specifies a global object name in a SQL statement or in the definition of the owner's views or procedures.

Ravikumar

• Oct 18th, 2011

Database link is created by a user in his schema,it has 2 types

1.private database link
2.public database link /global

private database link is access the object in separate user

syntax:

create database link connect to username identified by password using 'db_name';

kailasTile

 Profile Answers by kailasTile Questions by kailasTile

• Oct 14th, 2011

Private database link is created by a user in his schema. While creating the link, the keyword GLOBAL is not used. The syntax for creation is CREATE DATABASE LINK myPrivateDBLink connect to identified by using ;
Private DB links can not be used by other schema's.

Answer Question  Select Best Answer

Hi,

If a user executes a query which is already being used by a view exactly will oracle use already existing view to retrieve data or use the query executed by user?

Regards,
Shashi

Aayudh

• Aug 24th, 2011

Oracle uses query executed by user because when you use a view name in an other query, it simply transform query. select empid,name from emp; --- original create view emp_view as select empid,name f...

Answer Question  Select Best Answer

Yes.

matabrez

 Profile Answers by matabrez Questions by matabrez

• Jan 10th, 2011

Yes one tablespace can hold objects from different schemas.Eg. when we create any schema (user) than we can assign default tablespace like this for any user user we can use same tablespace. Eg. SYSTE...

Answer Question  Select Best Answer

ORACLE database's data is stored in data blocks. One data block corresponds to a specific number of bytes of physical database space on disk.

matabrez

 Profile Answers by matabrez Questions by matabrez

• Jan 10th, 2011

Smallest logical of Oracle database. In Oracle 10g default data block size is 8192 byres means 8k.
Other data block size are 2k, 4k, 8k, 16k, 32kWe have only these available data blocks in oracle database.

C.Ramesh

• Oct 27th, 2007

Oracle Data Blocks is logical storage unit of Oracle and One Oracle Data Blocks containts multiple of Operating system Blocks. Data blocks contains contigous of Bytes.

Answer Question  Select Best Answer

Synonyms are used to : Mask the real name and owner of an object.Provide public access to an objectProvide location transparency for tables, views or program units of a remote database.Simplify the SQL statements for database users.

harrykhokhar

 Profile Answers by harrykhokhar Questions by harrykhokhar

• Jun 1st, 2010

Synonyms are alternative names for the objects like views, indexes, etc.

Answer Question  Select Best Answer

A view is a virtual table. Every view has a Query attached to it. (The Query is a SELECT statement that identifies the columns and rows of the table(s) the view uses.)

pravesh28

 Profile Answers by pravesh28 Questions by pravesh28

• Mar 27th, 2010

View means virtualit is virtual table drived from base tableview doesnt contain any data view is mirrar image of data that we  can set the its size

C.Ramesh

• Oct 17th, 2007

View is a Virtual Table. It likes like a table. View provide additional level tabel security and providing selected columns only and it accessing different tables no need to joins of different tables. Views also stores data like (Materialized Views) it can be referesh methods like fast, complete.

Answer Question  Select Best Answer

A table is the basic unit of data storage in an ORACLE database. The tables of a database hold all of the user accessible data. Table data is stored in rows and columns.

pravesh28

 Profile Answers by pravesh28 Questions by pravesh28

• Mar 27th, 2010

Table is manager which contain row and colomnin which store data ande retrive data

thumatinagaraju

 Profile Answers by thumatinagaraju Questions by thumatinagaraju

• Oct 24th, 2006

Table is data base object which stores the data in the logical representatiom in form of rows n coluns which is existing in two dimension form... and is stored in the databse.

Answer Question  Select Best Answer

From where does PMON gets the informance about failure? How is the user process terminited?

premk

 Profile Answers by premk Questions by premk

• Dec 23rd, 2009

When user process is terminated abruptly due to power cut or any other factors then oracle database instance goes down then PMON mandatory background process is activated i.e it will then writes the c...

aabishkar

 Profile Answers by aabishkar Questions by aabishkar

• Sep 28th, 2009

When a user process fails or when it is killed, it then cleans up the cache and frees resources that the process used. PMON checks server processes and restarts them if they have failed.

Answer Question  Select Best Answer

No Limit.

jjvetri

 Profile Answers by jjvetri Questions by jjvetri

• Aug 5th, 2009

You can create any number of check constraintsseparated by AND, OR, or NOT to create more complex conditions.

Answer Question  Select Best Answer

mmaz2002

 Profile Answers by mmaz2002 Questions by mmaz2002

• Jul 15th, 2009

All Extent info is maintained in Dictionary which is infact a dis-advantage, Also in case of a huge insert operation undo is generated.

deep chandan

 Profile Answers by deep chandan Questions by deep chandan

• Dec 30th, 2008

The main advantage of using dictionary managed tablespaces is that in this we can give the size of the extents according to our need. We can modify extent size but in locally managed tablespace extents are of uniform size.

Answer Question  Select Best Answer

Each databases logically divided into one or more tablespaces one or more data files are explicitly created for each tablespace.

swetashashi

 Profile Answers by swetashashi Questions by swetashashi

• Apr 16th, 2009

Databases, tablespaces, and datafiles are closely related, but they have important differences:1) An Oracle database consists of at least two logical storage units called tablespaces, which collective...

swetashashi

 Profile Answers by swetashashi Questions by swetashashi

• Apr 16th, 2009

Each databases logically consists of one or moretablespaces One or more data files are explicitly createdfor each tablespace.

Answer Question  Select Best Answer

what is remote login user and local user in database?And sid is used when user want to login as local user and Glodal database name is used when user wants to login as remote user..What does it mean ?

cmanan

 Profile Answers by cmanan Questions by cmanan

• Jul 10th, 2008

When you have distributed environment,you may access one database from other.This is normally done  via db link.So lets say you have flight database and customer dabatabase.Now from customer data...

Answer Question  Select Best Answer