Home » RDBMS Server » Server Administration » Pl Answer This simple Question Of : Rollback Segment
Pl Answer This simple Question Of : Rollback Segment [message #63710] Sun, 31 October 2004 19:33 Go to next message
BhavinShah
Messages: 105
Registered: February 2004
Senior Member
Hi,

Frends This is a simple question ..But I want to get rid of that..

When I am inserting data in a table...where goes that data before commit ?? in rollback segment or in buffer cahche ??

scenario : I have a table of 1 Mb and now I am inserting one row in that table.so before commiting that row whole 1Mb table will goes to ROLLBACK SEGMENT or only one row will go in rollback segment??

if whole 1Mb data will go in rollback segment then when inserting data in rollback segment you need more size of rollback segment rather than update or delte statement.. is am True??

Pl. get out of me from this confusion...

Bhavin..

 

 

 

 

Report message to a moderator

Re: Pl Answer This simple Question Of : Rollback Segment [message #63715 is a reply to message #63710] Sun, 31 October 2004 23:59 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Read this to get a complete understanding.

hth

Report message to a moderator

Previous Topic: problems in installing oracle 8i
Next Topic: ORA-01185 when trying to add log file group
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 06:22:52 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.