Q&A Categories

Memory-Management

Why we do use very small size of RAM compairing then HARD DISK?

Why we do use very small size of RAM compairing then HARD DISK? '

Answers No Answers In: Memory-Management By: samir [ Grey Star Level] Sep 7, 2010

Why query fails sometimes

Why query fails sometimes '

Answers No Answers In: Memory-Management By: sunil [ Grey Star Level] Sep 6, 2010

Why query fails sometimes ?

Why query fails sometimes ?  Rollback  segment  dynamically  extent  to handle larger transactions entry loads. A  single  transaction may wipeout all available...

Answers No Answers In: Memory-Management By: samir [ Grey Star Level] Sep 6, 2010

Which parameter in Storage clause will reduce no. of rows per block?

Which parameter in Storage clause will reduce no. of rows per block?  PCTFREE parameter Row size also reduces no of rows per block.'

Answers No Answers In: Memory-Management By: bipin [ Grey Star Level] Sep 5, 2010

Which parameter in Storage clause will reduce number of rows per block

Which parameter in Storage clause will reduce number of rows per block '

Answers No Answers In: Memory-Management By: faiz [ Grey Star Level] Sep 5, 2010

When will be a segment released

When will be a segment released '

Answers No Answers In: Memory-Management By: yogesh [ Grey Star Level] Sep 3, 2010

When will be a segment released ?

When will be a segment released ?  When Segment is dropped.When Shrink (RBS only)When truncated (TRUNCATE used with drop storage option)'

Answers No Answers In: Memory-Management By: sam [ Grey Star Level] Sep 3, 2010

What is  Database Buffers ?

What is  Database Buffers ?  Database buffers are cache in the SGA used to hold the data blocks that are read  from  the  data  segments in the database such as tables, indexes...

Answers No Answers In: Memory-Management By: deva [1 Grey Star Level] Sep 1, 2010

What is use of LOG (Ver 7) option in  EXP command ?

What is use of LOG (Ver 7) option in  EXP command ?  The name of the file which log of the export will be written.'

Answers No Answers In: Memory-Management By: Anu [ Grey Star Level] Aug 31, 2010

What is use of Rollback Segments In Database ?

What is use of Rollback Segments In Database ?  They allow the database to maintain read consistency between multiple transactions.'

Answers No Answers In: Memory-Management By: neha [ Grey Star Level] Aug 31, 2010

Didn't find what you were looking for?

Add your Question to the site.

You must be Logged In to Add a Question.

Not a member yet? Sign Up Now »

Star Points Scale

Earn points for Asking and Answering Questions!

Grey Sta Levelr [1 - 25 Grey Star Level]
Green Star Level [26 - 50 Green Star Level]
Blue Star Level [51 - 500 Blue Star Level]
Orange Star Level [501 - 5000 Orange Star Level]
Red Star Level [5001 - 25000 Red Star Level]
Black Star Level [25001+ Black Star Level]