Home » RDBMS Server » Server Administration » Transaction table
Transaction table [message #257914] Thu, 09 August 2007 10:28 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Hi there,

One quest abt transation table.What is the location of transation table?Is it on data dictionary or within undo tablespace itself ?
Re: Transaction table [message #257930 is a reply to message #257914] Thu, 09 August 2007 11:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which transaction table are you talking about?
There is one in each header of data block.
There is one in each rollback segment header.

Regards
Michel
Re: Transaction table [message #257935 is a reply to message #257930] Thu, 09 August 2007 11:32 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Ok,so there are two transaction tables.Is there any docs available which clearly explain this concept.

I was reffering to rollback segments.Does that transaction table resides in each segment or on file header.
Re: Transaction table [message #257951 is a reply to message #257935] Thu, 09 August 2007 12:13 Go to previous message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Metalink notes 1011108.6, "General Overview of Rollback Segments", 69464.1, "Rollback Segment Configuration & Tips"
Quote:
rollback segment header

Regards
Michel
Previous Topic: How Can Create Table With diffrent TableSpaces in oracle 10g
Next Topic: Oracle 11g available for download on Linux
Goto Forum:
  


Current Time: Mon Dec 05 09:13:06 CST 2016

Total time taken to generate the page: 0.10164 seconds