Home » RDBMS Server » Server Administration » DDL statements and buffer cache
DDL statements and buffer cache [message #387078] Tue, 17 February 2009 20:03 Go to next message
tjay
Messages: 37
Registered: September 2008
Member
Hi

During DDL statements for example: create table statement.

Is the segment created inside the buffercache first and after a checkpoint it is written to disk?

Is this the correct order for DDL statements except Direct Path Load?
Re: DDL statements and buffer cache [message #387136 is a reply to message #387078] Wed, 18 February 2009 00:39 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is the segment created inside the buffercache first and after a checkpoint it is written to disk?

No but maybe the segment header.

Quote:
Is this the correct order for DDL statements except Direct Path Load?

Correct for what? To create a new empty table, most likely.

Regards
Michel
Previous Topic: Linux to Solaris migration (merged)
Next Topic: xdb schema
Goto Forum:
  


Current Time: Sun Dec 04 00:03:37 CST 2016

Total time taken to generate the page: 0.29213 seconds