DDL statements and buffer cache [message #387078] |
Tue, 17 February 2009 20:03 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68666 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
|
|
|