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

What is high watermark in oracle ?

Prabhat Sahu

 Profile Answers by Prabhat Sahu Questions by Prabhat Sahu

• Oct 15th, 2018

-- High Level Watermark: ------------------------- --> HLW is a term used with table segment in DB to show the amount of datablock occupied(level) by the table data. --> As per PCTUSED and PCTFREE ...

Prabhat Sahu

• Oct 4th, 2017

-- High Level Watermark: ------------------------- --> HLW is a term used with table segment in DB to show the amount of datablock occupied(level) by the table data. --> As per PCTUSED and PCTFREE ...

Answer Question  Select Best Answer

What is the difference between log sequence number and checkpoint id? How it is used for instance recovery?

vishal gajage

• Jun 21st, 2017

Log Sequence Number is assigned to every redo log file after full the redo log file....and SCN number is generated after every commit

aditya verma

• May 11th, 2017

Logs sequence no is the value which is mention in header of every datafile. Below is the situations when SCN changed.
After every commit the transaction.
Log switch.
Backup completion.

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

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

Which parameter specifies the number of DBWn processes?

mosinpatel

• Jan 18th, 2018

SQL> show parameter db_writer_processes
NAME TYPE VALUE
------------------------------------ ----------- -------
db_writer_processes integer 1

srinivasarao

• Mar 22nd, 2015

DB_WRITER_PROCESS=""

Answer Question  Select Best Answer

ORACLE database is comprised of three types of files. One or more Data files, two are more Redo Log files, and one or more Control files.

Naresh

• Feb 14th, 2018

Use DBMS_CRYPTO for encrypt and decrypt the objects

Harshad Khuspe

• Dec 27th, 2015

Components of Physical Databases are Oracle files which are in disk. i.e. Datafiles, Online Redolog files, Archive log files, Parameter file, Password File, Controlfile etc.

Answer Question  Select Best Answer

Tablespaces and the Database's Schema Objects.

mosin

• Jan 18th, 2018

Tablespace
Segments
Extent

Heena

• Sep 17th, 2017

Tablespaces, Segments, Extent, Data blocks

Answer Question  Select Best Answer

ranjithsv

• Oct 2nd, 2013

Its relation between SGA and 5 Mandatory Background process
SMON,PMON,DBWR,LGWR,CKPT

ARUN BHUKKER

 Profile Answers by ARUN BHUKKER Questions by ARUN BHUKKER

• Oct 19th, 2012

A background process maintain relationship between memory structure and physical structure of Oracle server. Started when Oracle instance is started. Consist of 5 mandatory and some optional backgro...

Answer Question  Select Best Answer

Prabhat Sahu

• Oct 21st, 2017

B-Tree Index:
1. Oracle Default index.
2. Cardinality is High, means less duplicate(more unique records) (i.e. Rowid)

Bitmap Index:
1. Cardinality is Low, means more duplicate.(most of the values are repetative)
2. Flag related columns ( i.e. M/F, Y/N, 1/0 )

Vineet

• Oct 12th, 2017

1. B-tree Index has high cardinality values, where as Bitmap Index has low Cardinality values.

Answer Question  Select Best Answer

A data file can be associated with only one database. Once created a data file can't change size.One or more data files form a logical unit of database storage called a tablespace.

ranjithsv18

• Oct 2nd, 2013

Block size available from 2k,4k,8k,16k and 32k.

As per oracle point of view Default (or) standard block size is 8k for Data files.The initialization parameter

db_block_size=8k (8192)remaining size are non-standard blok size. Extents size 64k.

(Datafile

NAGARAJ OCP

• Dec 27th, 2011

In data files, we cant change the extent management, type of it. But we can change the storage space for it if we need after the database (tablespace) creation.

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

Heena

• Sep 17th, 2017

Database writer process(DBWn)

sriram

• May 17th, 2016

DBWR is one of the BG processed of Oracle DB. It writes modifies the data in data base buffer cache

Answer Question  Select Best Answer

When does the LGWR writes all redo-enteries to the redo-log buffer?

Suresh

• Oct 31st, 2017

1) When user hits commit
2) When there is 1/3rd full in redo log cache
3) One every 3 seconds

During this above situation LGWR writes redo log entries into redo log files from redo log cache !!

Mayur Pimpalkar

• Dec 24th, 2015

Lwgr process writes redo entries to online redolog files not to redobuffer.

Answer Question  Select Best Answer