13.6 The Recycle Bin

 < Day Day Up > 



 Oracle Database 10 Grid   Oracle Database 10g introduces a recycle bin, much like the recycle bin in the Windows operating system. This feature is certainly very useful from the perspective of database administration but could cause problems with space and perhaps performance if the recycle bin is not regularly monitored and cleared.

Check the contents of the recycle bin by selecting from the RECYCLEBIN or USER_RECYCLEBIN views.

This chapter covered some sometimes rather vague aspects of Oracle Database logical object tuning and had some necessary repetition from previous chapters. The next chapter will look into block-level tuning regardless of the object type.



 < Day Day Up > 



Oracle High Performance Tuning for 9i and 10g
Oracle High Performance Tuning for 9i and 10g
ISBN: 1555583059
EAN: 2147483647
Year: 2003
Pages: 164

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net