What is the main difference between the functions of DB_BUFFER_CACHE and LIBRARY_CACHE?

sumer77

 Profile Answers by sumer77 Questions by sumer77

• Oct 24th, 2008

DB Buffer cache:  when a query is executed then server process looks for block in buffer cache. If the block is not available in buffer cache then server process reads the block from data files.L...

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

How will you identify database size when you create a database first time?

Caesar Dutta

• Nov 6th, 2017

Select sum(bytes) from dba_segments

SURAJ BANSODE

• Oct 14th, 2016

To find the size of database we need to Sum (datafiles+redo log files+temp files+control files)

Answer Question  Select Best Answer

sumer77

 Profile Answers by sumer77 Questions by sumer77

• Mar 22nd, 2009

Sum of bytes from dba_extents will provide the database size.      

Sridhar.K

• Oct 15th, 2007

COLUMN "Total Mb" FORMAT 999,999,999.0COLUMN "Redo Mb" FORMAT 999,999,999.0COLUMN "Temp Mb" FORMAT 999,999,999.0COLUMN "Data Mb" FORMAT 999,999,999.0PromptPromp...

Answer Question  Select Best Answer