Call for Oracle support & training (800) 766-1884
Free Oracle Tips

Home
Corporate Oracle Training
Custom Oracle Training
Oracle New Features Training
Advanced Oracle DBA Classes
Oracle Tuning Courses
Oracle Tips & Tricks
Oracle Training Links
Oracle Training Links
Oracle Training Links

We are top for USA Oracle Training Clients

 

Free Oracle Tips


 
HTML Text AOL

Free Oracle App Server Tips


 
HTML Text

Oracle support

Oracle training

Oracle tuning

Rednecks!

Remote Oracle

Custom Oracle Training

 

   
  Oracle Tips by Burleson

Chapter 6 Oracle Tablespace and File Internals Scripts

CWMLITE  1    1   20,905,984  2,552  20,905,984  2,552  100.000  100.000
DBAUTIL_DATA 1  1  5,939,200    725   5,939,200    725  100.000  100.000
DBAUTIL_INDEX 1 1  9,625,600  1,175   9,625,600  1,175  100.000  100.000
DRSYS   1     1   12,845,056  1,568  12,845,056  1,568  100.000  100.000
EXAMPLE 1     1      262,144     32     262,144     32  100.000  100.000
INDX   1      1   26,148,864  3,192  26,148,864  3,192  100.000  100.000
SYSTEM 1      1      540,672     66     540,672     66  100.000  100.000
TOOLS  1      3    8,192,000  1,000   7,274,496    888   88.800   71.602
UNDOTBS 1     4  208,338,944 25,432 114,098,176 13,928   54.766   52.329
UNDO_TBS2 1   1   19,595,264  2,392  19,595,264  2,392  100.000  100.000
UNDO_TBS3  1  1   19,595,264  2,392  19,595,264  2,392  100.000  100.000
USERS      1  1   25,952,256  3,168  25,952,256  3,168  100.000  100.000

Ideally, the tablespace data files will show only one extent. This means there will be one line in the report for each tablespace data file, and the biggest area will match the free area. Practically, there will be several extents if the tablespace has been used for any length of time, and the free area (which corresponds to total freespace in the tablespace) and the biggest area (which corresponds to the biggest area of contiguous free space) will not be equal.


The above text is an excerpt from:
 

Mike Ault’s Oracle Internals Monitoring & Tuning Scripts
 


http://www.rampant-books.com/book_2003_2_ault_internals.htm
 

See the Oracle script collection::
 


 

 
 
 

Oracle performance tuning book

 

 

Oracle performance tuning software

 
Oracle performance tuning software
 
Oracle performance Tuning 10g reference poster
 
Oracle training in Linux commands
 
Oracle training Excel
 
 
 
 

 

email BC:


Copyright © 1996 -  2014 by Burleson Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.