|
Checking Tables and Indexes Next Extent |
|
|
Written by Bartlomiej Oles
|
|
Friday, 15 December 2006 |
Oracle Script :
Tables and Indexes with number of extents more then ... and the next extent size less then 10% of the segment total space. |
|
Last Updated ( Sunday, 25 May 2008 )
|
|
Read more...
|
|
Tablespace size |
|
|
Written by Bartlomiej Oles
|
|
Friday, 15 December 2006 |
|
This script will show you your tablespace size, what percentage is used and free, and the number of fragments that happened. |
|
Last Updated ( Sunday, 25 May 2008 )
|
|
Read more...
|
|
Extens monitoring |
|
|
Written by Bartlomiej Oles
|
|
Friday, 15 December 2006 |
|
Hi
I wold like to start provide some usefull database scripts, sql`s etc. Today you have some for Oracle extents monitoring... Enjoy |
|
Last Updated ( Sunday, 25 May 2008 )
|
|
Read more...
|
|
Where Did Oracle Come From? |
|
|
Written by Steve Callen, stevencallan@hotmail.com
|
|
Tuesday, 03 January 2006 |
|
DBAsupport.com: As an Oracle DBA, you know that Oracle is a relational database management system and that it performs many complex functions well. In the pressure to learn how to be a DBA or what it is you should be doing, it is hard to take the time to sit back and appreciate the origins of the RDBMS model in general and where and how Oracle came into being. It is important to have an appreciation of your profession's history and origins. Often times, we take for granted the functions an RDBMS performs. But where, exactly, did the concept of the relational model come from |
|
Last Updated ( Sunday, 25 May 2008 )
|
|
Read more...
|
|