I need help with Database Question…!!
Working with Dictionary and Oracle Managed Files
As the DBA for your company, you have decided to install a new version of the Oracle Enterprise database to replace the current database version being used. The old database has become a constant headache and seems to be causing an overload on the disk drive’s I/O channels. Further analysis has also shown that two primary large tables are the main points of access. These tables are CUST_REC and ACCT_RECV tables. You also have a new server with three large-capacity disk drives: F, G, and H. Briefly, provide the following information:
Describe how you plan to rectify the I/O problem with the new Oracle10g database using the UMF method.
Describe how you would solve the same problem using the OMF method.
Place and save your answers in a Word document.
0 comments