Out of Space in the Woodscrew Tablespace

 < Day Day Up > 



Availability can be significantly hampered by routine database management tasks. Take something as straightforward as datafile management. Where the files reside, how big they are, and on what disks, can lead to significant availability problems.

Horatio's Woodscrew database recently ran out of disk space while autoextending a datafile in the WS_APP_DATA tablespace. They had turned autoextend on so that they would not have to be faced with disk management. But business has been booming, and the orders and customer tables are growing dramatically. In addition, new reports are being generated by upper management looking to mine the data for more edge in the marketplace. In a word, the single datafile on a single disk volume has begun to fall short of their needs. They recently had disk problems, and the system administrator is reporting excessive I/O on WS_APP_DATA datafiles. A disk burnout is imminent.

However, reorganizing the datafiles across new disk volumes not only means an explicit investigation into which tables, exactly, are getting hit the hardest, but also the outage that would be required while the tablespace is reorganized across new datafiles on new volumes. Such a massive undertaking could take days.

start sidebar
Use ASM to Simplify Disk and File Management

In Oracle Database 10g, automatic storage management, or ASM, greatly simplifies file management by removing the burden of laying out files to avoid hot spots, and also by simplifying file creation and sizing. ASM is a volume manager for Oracle files, which gives the ability to stripe and mirror files with very little effort on the part of the DBA or the sysadmin. In addition, ASM is constantly monitoring for I/O hot spots, and it will automatically direct reads of allocation units or segments to disks that are least heavily used, to avoid the occurrence of hot spots and maintain I/O performance. Aside from this, if a disk fails, or if a new disk is added to an ASM disk group, ASM will automatically rebalance the existing files, to maintain the distribution of I/O. ASM will be discussed in more detail in Chapter 3.

end sidebar



 < Day Day Up > 



Oracle Database 10g. High Availablity with RAC Flashback & Data Guard
Oracle Database 10g. High Availablity with RAC Flashback & Data Guard
ISBN: 71752080
EAN: N/A
Year: 2003
Pages: 134

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