高少帮忙分析一下系统检查报告

一下是检查报告，请帮忙分析一下系统中存在的问题，及改善建议，多谢
********************************************************************
*** PROD.WORLD                             9/20/2008 9:54:29 AM  ***
********************************************************************

~Time to Connect             : 0 seconds.

~Database Version            :  8.0.5.1.0
~Database Up Since           : 07:44:09 AM, September 18 2008
~Buffer Cache Hit Ratio      : 95.5348
~Library Cache Miss Ratio    : 0.0209
~Dictionary Cache Miss Ratio : 0.2434

[Shared Pool Usage] Exec Time 0 seconds
~ Total Mb Unused : 69.02
~ Total Mb Used   : 884.65
~ Total Mb        : 953.67
~ Shared Pool Percent Used : 92.76


[Archive Log Mode Info] Exec Time 0 seconds
~ Archiver : STARTED
~ Log Mode : ARCHIVELOG
~ log_archive_start (init.ora param) = TRUE

[Archive Log Info] Exec Time 1 seconds
~ Average Log Switches Per Day                          : 235.75
~ Hard Drive Storage (in Mb) for this many archive logs : 2357.49


!  Error using UTL_FILE to examine alert log!
!  Error using UTL_FILE
!  Possible causes:
!  1)  You don't have privileges to execute the UTL_FILE package.
!  2)  UTL_FILE_DIR initialization parameter does not include one of these lines:
!      utl_file_dir=/u04/dbcommon/PROD/bdump
!      utl_file_dir=*
!  3)  alert.log file name is not among the following:
!      (if this is the case please inform Quest support)
!      alert_PROD.log
!      PRODalrt.log

[Redo Log Group Sizes and Quantities] Exec Time 0 seconds
~ Number of Log Groups : 3
! Number of Members per Log Group: 1
~ All redo log members are 10M in size.

[Rollback Segments with wait ratios > 1 %] Exec Time 0 seconds
~ None


[Objects with Mixed-Case Names] Exec Time 11 seconds
! Column             APPS.AXBV_ACCOUNTING_ENTRY_LINES._KF:account
! Column             APPS.AXBV_ACCOUNT_BALANCES._KF:account
! Column             APPS.AXBV_CONTROL_ACCOUNTS._KF:account
! Column             APPS.AXBV_NON_CONTROL_ACCOUNTS._KF:account
! Column             APPS.AXFV_ACCOUNTING_ENTRY_LINES._KF:account
! Column             APPS.AXFV_ACCOUNT_BALANCES._KF:account
! Column             APPS.AXFV_CONTROL_ACCOUNTS._KF:account
! Column             APPS.AXFV_NON_CONTROL_ACCOUNTS._KF:account
! Column             APPS.PABV_ACCOUNTING_PERIODS._LA:current_pa_period_flag
! Column             APPS.PABV_ACCOUNTING_PERIODS._LA eriod_status
! Column             APPS.PABV_ASSETS._LA:amortize_flag
! Column             APPS.PABV_ASSETS._LA:capitalized_flag
! Column             APPS.PABV_ASSETS._LA:depreciate_flag
! Column             APPS.PABV_ASSETS._LA:reversal_flag
! Column             APPS.PABV_ASSET_LINES._LA:amortize_flag
! Column             APPS.PABV_ASSET_LINES._LA:transfer_status
! Column             APPS.PABV_ASSET_LINE_DETAILS._LA:reversed_flag
! Column             APPS.PABV_BUDGET_LINES._LA:change_reason
! Column             APPS.PABV_BUDGET_LINES._LA:unit_of_measure
! Column             APPS.PABV_BUDGET_VERSIONS._LA:current_flag
! Column             APPS.PABV_BUDGET_VERSIONS._LA:current_original_flag
! Column             APPS.PABV_BUDGET_VERSIONS._LA:labor_unit_of_measure
! Column             APPS.PABV_BUDGET_VERSIONS._LA riginal_flag
! Column             APPS.PABV_BUDGET_VERSIONS._LA m_product
! Column             APPS.PABV_CLASS_CATEGORIES._LA:autoaccounting_flag
! Column             APPS.PABV_CLASS_CATEGORIES._LA:mandatory_flag
! Column             APPS.PABV_CLASS_CATEGORIES._LA ick_one_code_only_flag
! Column             APPS.PABV_COMMITMENTS._LA:approved_flag
! Column             APPS.PABV_COMMITMENTS._LA:commitment_source
! Column             APPS.PABV_COMMITMENTS._LA:line_type
! Column             APPS.PABV_COST_DISTRIBUTIONS._LA:billable_flag
! Column             APPS.PABV_COST_DISTRIBUTIONS._LA:line_type
! Column             APPS.PABV_COST_DISTRIBUTIONS._LA:reversed_flag
! Column             APPS.PABV_COST_DISTRIBUTIONS._LA:transfer_status
! Column             APPS.PABV_CUSTOMERS._LA roject_cust_relation
! Column             APPS.PABV_CUSTOMER_AGREEMENTS._LA:revenue_limit_flag
! Column             APPS.PABV_CUSTOMER_AGREEMENTS._LA:template_flag
! Column             APPS.PABV_CUSTOMER_AGREEMENT_TYPES._LA:revenue_limit_flag
! Column             APPS.PABV_CUSTOMER_CONTACTS._LA roject_contact_type
! Column             APPS.PABV_CUSTOMER_INVOICES._LA:generation_error_flag
! Column             APPS.PABV_CUSTOMER_INVOICES._LA:transfer_status
! Column             APPS.PABV_EVENTS._LA:bill_hold_flag
! Column             APPS.PABV_EVENTS._LA:rev_distributed_flag
! Column             APPS.PABV_EVENT_TYPES._LA:event_type_class
! Column             APPS.PABV_EXPENDITURES._LA:expenditure_class
! Column             APPS.PABV_EXPENDITURES._LA:expenditure_status
! Column             APPS.PABV_EXPENDITURE_GROUPS._LA:status
! Column             APPS.PABV_EXPENDITURE_ITEMS._LA:Rev_Dist_Rejection
! Column             APPS.PABV_EXPENDITURE_ITEMS._LA:bill_hold_flag
! Column             APPS.PABV_EXPENDITURE_ITEMS._LA:billable_flag
! Column             APPS.PABV_EXPENDITURE_ITEMS._LA:converted_flag
! Column             APPS.PABV_EXPENDITURE_ITEMS._LA:cost_distributed_flag
! Column             APPS.PABV_EXPENDITURE_ITEMS._LA:net_zero_adj_flag
! Column             APPS.PABV_EXPENDITURE_ITEMS._LA:rev_distributed_flag
! Column             APPS.PABV_EXPENDITURE_TYPES._LA:cost_rate_flag
! Column             APPS.PABV_INVOICE_LINES._LA:invoice_line_type
! Column             APPS.PABV_INVOICE_LINES._LA:taxable_flag
! Column             APPS.PABV_PROJECTS._LA m_product
! Column             APPS.PABV_PROJECTS._LA ublic_sector_flag
! Column             APPS.PABV_PROJECTS._LA:template_flag
! Column             APPS.PABV_PROJECTS._LA:wf_status
! Column             APPS.PABV_PROJECT_TYPES._LA:burden_cost_flag
! Column             APPS.PABV_PROJECT_TYPES._LA roject_type_class
! Column             APPS.PABV_RESOURCES._LA:unit_of_measure
! Column             APPS.PABV_RESOURCE_LIST_RESOURCES._LA:enabled_flag
! Column             APPS.PABV_RESOURCE_LIST_RESOURCES._LA:track_as_labor_flag
! Column             APPS.PABV_REVENUE_DISTRIBUTIONS._LA:additional_revenue_flag
! Column             APPS.PABV_REVENUE_DISTRIBUTIONS._LA:transfer_status
! Column             APPS.PABV_TASKS._LA m_product
! Column             APPS.PABV_TASKS._LA:service_type
! Column             APPS.PABV_TRANSACTION_SOURCES._LA:costed_flag
! Column             APPS.PABV_TRANSACTION_SOURCES._LA urgeable_flag
! Column             APPS.PAFV_ACCOUNTING_PERIODS._LA:current_pa_period_flag
! Column             APPS.PAFV_ACCOUNTING_PERIODS._LA eriod_status
! Column             APPS.PAFV_ASSETS._LA:amortize_flag
! Column             APPS.PAFV_ASSETS._LA:capitalized_flag
! Column             APPS.PAFV_ASSETS._LA:depreciate_flag
! Column             APPS.PAFV_ASSETS._LA:reversal_flag
! Column             APPS.PAFV_ASSET_LINES._LA:amortize_flag
! Column             APPS.PAFV_ASSET_LINES._LA:transfer_status
! Column             APPS.PAFV_ASSET_LINE_DETAILS._LA:reversed_flag
! Column             APPS.PAFV_BUDGET_LINES._LA:change_reason
! Column             APPS.PAFV_BUDGET_LINES._LA:unit_of_measure
! Column             APPS.PAFV_BUDGET_VERSIONS._LA:current_flag
! Column             APPS.PAFV_BUDGET_VERSIONS._LA:current_original_flag
! Column             APPS.PAFV_BUDGET_VERSIONS._LA:labor_unit_of_measure
! Column             APPS.PAFV_BUDGET_VERSIONS._LA riginal_flag
! Column             APPS.PAFV_BUDGET_VERSIONS._LA m_product
! Column             APPS.PAFV_CLASS_CATEGORIES._LA:autoaccounting_flag
! Column             APPS.PAFV_CLASS_CATEGORIES._LA:mandatory_flag
! Column             APPS.PAFV_CLASS_CATEGORIES._LA ick_one_code_only_flag
! Column             APPS.PAFV_COMMITMENTS._LA:approved_flag
! Column             APPS.PAFV_COMMITMENTS._LA:commitment_source
! Column             APPS.PAFV_COMMITMENTS._LA:line_type
! Column             APPS.PAFV_COST_DISTRIBUTIONS._LA:billable_flag
! Column             APPS.PAFV_COST_DISTRIBUTIONS._LA:line_type
! Column             APPS.PAFV_COST_DISTRIBUTIONS._LA:reversed_flag
! Column             APPS.PAFV_COST_DISTRIBUTIONS._LA:transfer_status
! Column             APPS.PAFV_CUSTOMERS._LA roject_cust_relation
! Column             APPS.PAFV_CUSTOMER_AGREEMENTS._LA:revenue_limit_flag
! Column             APPS.PAFV_CUSTOMER_AGREEMENTS._LA:template_flag
! Column             APPS.PAFV_CUSTOMER_AGREEMENT_TYPES._LA:revenue_limit_flag
! Column             APPS.PAFV_CUSTOMER_CONTACTS._LA roject_contact_type
! Column             APPS.PAFV_CUSTOMER_INVOICES._LA:generation_error_flag
! Column             APPS.PAFV_CUSTOMER_INVOICES._LA:transfer_status
! Column             APPS.PAFV_EVENTS._LA:bill_hold_flag
! Column             APPS.PAFV_EVENTS._LA:rev_distributed_flag
! Column             APPS.PAFV_EVENT_TYPES._LA:event_type_classifn
! Column             APPS.PAFV_EXPENDITURES._LA:expenditure_class
! Column             APPS.PAFV_EXPENDITURES._LA:expenditure_status
! Column             APPS.PAFV_EXPENDITURE_GROUPS._LA:status
! Column             APPS.PAFV_EXPENDITURE_ITEMS._LA:Rev_Dist_Rejection
! Column             APPS.PAFV_EXPENDITURE_ITEMS._LA:bill_hold_flag
! Column             APPS.PAFV_EXPENDITURE_ITEMS._LA:billable_flag
! Column             APPS.PAFV_EXPENDITURE_ITEMS._LA:converted_flag
! Column             APPS.PAFV_EXPENDITURE_ITEMS._LA:cost_distributed_flag
! Column             APPS.PAFV_EXPENDITURE_ITEMS._LA:net_zero_adj_flag
! Column             APPS.PAFV_EXPENDITURE_ITEMS._LA:rev_distributed_flag
! Column             APPS.PAFV_EXPENDITURE_TYPES._LA:cost_rate_flag
! Column             APPS.PAFV_INVOICE_LINES._LA:invoice_line_type
! Column             APPS.PAFV_INVOICE_LINES._LA:taxable_flag
! Column             APPS.PAFV_PROJECTS._LA m_product
! Column             APPS.PAFV_PROJECTS._LA ublic_sector_flag
! Column             APPS.PAFV_PROJECTS._LA:template_flag
! Column             APPS.PAFV_PROJECTS._LA:wf_status
! Column             APPS.PAFV_PROJECT_TYPES._LA:burden_cost_flag
! Column             APPS.PAFV_PROJECT_TYPES._LA roject_type_class
! Column             APPS.PAFV_RESOURCES._LA:unit_of_measure
! Column             APPS.PAFV_RESOURCE_LIST_RESOURCES._LA:enabled_flag
! Column             APPS.PAFV_RESOURCE_LIST_RESOURCES._LA:track_as_labor_flag
! Column             APPS.PAFV_REVENUE_DISTRIBUTIONS._LA:additional_revenue_flag
! Column             APPS.PAFV_REVENUE_DISTRIBUTIONS._LA:transfer_status
! Column             APPS.PAFV_TASKS._LA m_product
! Column             APPS.PAFV_TASKS._LA:service_type
! Column             APPS.PAFV_TRANSACTION_SOURCES._LA:costed_flag
! Column             APPS.PAFV_TRANSACTION_SOURCES._LA urgeable_flag
! Column             APPS.V_GL_DETAIL.Account Code
! Column             APPS.V_GL_DETAIL.Account Description(Segment3)
! Column             APPS.V_GL_DETAIL.Account Type
! Column             APPS.V_GL_DETAIL.Accounted Cr
! Column             APPS.V_GL_DETAIL.Accounted Dr
! Column             APPS.V_GL_DETAIL.Bal. Type
! Column             APPS.V_GL_DETAIL.Category
! Column             APPS.V_GL_DETAIL.Control Total
! Column             APPS.V_GL_DETAIL.Conversion Currency
! Column             APPS.V_GL_DETAIL.Date
! Column             APPS.V_GL_DETAIL.Eff. Date
! Column             APPS.V_GL_DETAIL.Entered Cr
! Column             APPS.V_GL_DETAIL.Entered Dr
! Column             APPS.V_GL_DETAIL.Entry UserID
! Column             APPS.V_GL_DETAIL.JV Description
! Column             APPS.V_GL_DETAIL.JV Line Description
! Column             APPS.V_GL_DETAIL.JV No.
! Column             APPS.V_GL_DETAIL.JV Period
! Column             APPS.V_GL_DETAIL.Posting Date
! Column             APPS.V_GL_DETAIL.Rate
! Column             APPS.V_GL_DETAIL.Source
! Column             APPS.V_GL_DETAIL.Type
! Table              APPS.temp


[Tables with > 5 % chained rows and > 500 total rows] Exec Time 2 seconds
~ None


[Table Partitions with > 5 % chained rows and > 500 total rows] Exec Time 0 seconds
~ None


[Segments with < 10% of extents remaining and (maxextents > 1)] Exec Time 5 seconds
! TABLE PO.POA_BIS_SAVINGS. in TS POD : 50 of 50 extents used.  Total Size : 96 MB


[Segments with > 100 extents] Exec Time 3 seconds
! TABLE APPLSYS.FND_LOGINS: 489 Extents
! TABLE ALR.ALR_ACTION_SET_CHECKS: 143 Extents
! TABLE AP.AP_INV_SELECTION_CRITERIA_ALL: 362 Extents
! TABLE OE.SO_EXCEPTIONS: 205741 Extents
! TABLE OE.SO_LINE_DETAILS: 434 Extents
! TABLE OE.SO_PICKING_BATCHES_ALL: 309 Extents
! TABLE OE.SO_PICKING_LINE_DETAILS: 720 Extents
! TABLE INV.MTL_ATP_RULES: 320 Extents
! TABLE INV.MTL_SUPPLY_DEMAND_TEMP: 175 Extents
! TABLE PO.PO_ACCRUAL_RECONCILE_TEMP_ALL: 353 Extents
! TABLE PO.PO_APPROVED_SUPPLIER_LIST: 150 Extents
! TABLE PO.PO_ASL_ATTRIBUTES: 121 Extents
! TABLE PO.PO_LINES_ALL: 16219 Extents
! TABLE PO.PO_LINE_LOCATIONS_ARCHIVE_ALL: 117 Extents
! TABLE PO.RCV_RECEIVING_SUB_LEDGER: 572 Extents
! TABLE PO.RCV_TRANSACTIONS: 213 Extents
! TABLE BOM.BOM_DELETE_ENTITIES: 745 Extents
! TABLE BOM.BOM_DELETE_ERRORS: 154 Extents
! TABLE BOM.BOM_EXPLOSION_TEMP: 1525 Extents
! TABLE BOM.BOM_INVENTORY_COMPONENTS: 158 Extents
! TABLE BOM.BOM_LISTS: 2230 Extents
! TABLE BOM.BOM_SMALL_EXPL_TEMP: 10642 Extents
! TABLE BOM.BOM_SMALL_IMPL_TEMP: 1473 Extents
! TABLE BOM.CST_ITEM_COSTS: 239 Extents
! TABLE BOM.CST_ITEM_COST_DETAILS: 160 Extents
! TABLE BOM.CST_LISTS: 329 Extents
! TABLE MRP.MRP_END_ASSEMBLIES: 202 Extents
! TABLE INV.MTL_TRANSACTION_ACCOUNTS: 402 Extents
! TABLE INV.MTL_CST_ACTUAL_COST_DETAILS: 321 Extents
! TABLE INV.MTL_MATERIAL_TRANSACTIONS: 480 Extents
! TABLE AZT.PO_LINES_ALL: 1376 Extents
! INDEX APPLSYS.FND_CONCURRENT_REQUESTS_N2: 211 Extents
! INDEX APPLSYS.FND_CONCURRENT_REQUESTS_N3: 226 Extents
! INDEX APPLSYS.FND_CONCURRENT_REQUESTS_N4: 143 Extents
! INDEX APPLSYS.FND_CONCURRENT_REQUESTS_N7: 121 Extents
! INDEX APPLSYS.FND_LOGINS_U1: 1706 Extents
! INDEX APPLSYS.FND_LOGIN_RESPONSIBILITIES_U1: 116 Extents
! INDEX APPLSYS.FND_UNSUCCESSFUL_LOGINS_N1: 223 Extents
! INDEX ALR.ALR_ACTION_SET_CHECKS_N2: 2521 Extents
! INDEX ALR.ALR_ACTION_SET_CHECKS_N3: 304 Extents
! INDEX ALR.ALR_ACTION_SET_CHECKS_N4: 1774 Extents
! INDEX ALR.ALR_ACTION_SET_CHECKS_U1: 1815 Extents
! INDEX ALR.ALR_ACTION_SET_CHECKS_N1: 1982 Extents
! INDEX GL.GL_IMPORT_REFERENCES_N1: 195 Extents
! INDEX AP.AP_INVOICE_DISTRIBUTIONS_N3: 101 Extents
! INDEX AP.AP_INVOICE_DISTRIBUTIONS_N4: 148 Extents
! INDEX AP.AP_INV_SELECTION_CRITERIA_N3: 102 Extents
! INDEX AP.AP_INV_SELECTION_CRITERIA_U1: 125 Extents
! INDEX OE.SO_EXCEPTIONS_N1: 166421 Extents
! INDEX OE.SO_EXCEPTIONS_U1: 1796 Extents
! INDEX OE.SO_HOLD_RELEASES_N1: 149 Extents
! INDEX OE.SO_LINE_DETAILS_N3: 202 Extents
! INDEX OE.SO_LINE_DETAILS_U1: 194 Extents
! INDEX OE.SO_LINE_DETAILS_N1: 328 Extents
! INDEX OE.SO_LINE_DETAILS_N2: 287 Extents
! INDEX OE.SO_PICKING_BATCHES_U1: 155 Extents
! INDEX OE.SO_PICKING_BATCHES_U2: 320 Extents
! INDEX OE.SO_PICKING_LINE_DETAILS_N3: 323 Extents
! INDEX OE.SO_PICKING_LINE_DETAILS_N4: 241 Extents
! INDEX OE.SO_PICKING_LINE_DETAILS_N5: 259 Extents
! INDEX INV.MTL_SUPPLY_DEMAND_TEMP_N1: 2135 Extents
! INDEX PO.PO_ACCRUAL_RECONCILE_TEMP_N1: 429 Extents
! INDEX PO.PO_ACCRUAL_RECONCILE_TEMP_N3: 338 Extents
! INDEX PO.PO_ACCRUAL_RECONCILE_TEMP_N4: 230 Extents
! INDEX PO.PO_ACCRUAL_RECONCILE_TEMP_N5: 938 Extents
! INDEX PO.PO_LINES_N5: 206 Extents
! INDEX PO.PO_LINES_U2: 112 Extents
! INDEX PO.PO_LINES_ARCHIVE_U1: 101 Extents
! INDEX PO.PO_LINE_LOCATIONS_N2: 142 Extents
! INDEX PO.PO_LINE_LOCATIONS_ARCHIVE_N2: 141 Extents
! INDEX PO.PO_LINE_LOCATIONS_ARCHIVE_U1: 122 Extents
! INDEX PO.RCV_RECEIVING_SUB_LEDGER_N1: 403 Extents
! INDEX PO.RCV_TRANSACTIONS_N12: 181 Extents
! INDEX PO.RCV_TRANSACTIONS_N13: 213 Extents
! INDEX PO.RCV_TRANSACTIONS_N15: 326 Extents
! INDEX PO.RCV_TRANSACTIONS_N2: 230 Extents
! INDEX PO.RCV_TRANSACTIONS_N3: 217 Extents
! INDEX PO.RCV_TRANSACTIONS_N4: 173 Extents
! INDEX PO.RCV_TRANSACTIONS_N5: 176 Extents
! INDEX PO.RCV_TRANSACTIONS_N6: 178 Extents
! INDEX PO.RCV_TRANSACTIONS_U1: 167 Extents
! INDEX PO.RCV_TRANSACTIONS_N11: 210 Extents
! INDEX PO.RCV_TRANSACTIONS_N1: 283 Extents
! INDEX BOM.BOM_DELETE_ENTITIES_N1: 249 Extents
! INDEX BOM.BOM_DELETE_ENTITIES_U1: 167 Extents
! INDEX BOM.BOM_EXPLOSION_TEMP_N1: 432 Extents
! INDEX BOM.BOM_EXPLOSION_TEMP_N2: 550 Extents
! INDEX BOM.BOM_EXPLOSION_TEMP_N3: 417 Extents
! INDEX BOM.BOM_EXPLOSION_TEMP_N4: 387 Extents
! INDEX BOM.BOM_EXPLOSION_TEMP_N5: 383 Extents
! INDEX BOM.BOM_LISTS_U1: 2710 Extents
! INDEX BOM.BOM_REFERENCE_DESIGNATORS_N1: 490 Extents
! INDEX BOM.BOM_REFERENCE_DESIGNATORS_U1: 314 Extents
! INDEX BOM.CST_LISTS_U1: 407 Extents
! INDEX MRP.MRP_BOM_COMPONENTS_U1: 115 Extents
! INDEX MRP.MRP_END_ASSEMBLIES_U1: 335 Extents
! INDEX WIP.WIP_REQUIREMENT_OPERATIONS_N1: 105 Extents
! INDEX PO.RCV_SHIPMENT_LINES_N7: 126 Extents
! INDEX INV.MTL_CATALOG_SEARCH_ITEMS_U1: 320 Extents
! INDEX INV.MTL_ATP_RULES_U1: 169 Extents
! INDEX INV.MTL_ATP_RULES_U2: 351 Extents


[Objects which can't extend because there is not
enough room in the tablespace] Exec Time 182 seconds
! AZT.AAA in tablespace AZ_DCONV
!   Tot Exts : 15  Next Ext (Kb): 12784  Kb Avail TS : 12304
!   Max(File Growth Remaining) : 7 mb
! AZT.AZT_AARSRGP in tablespace AZ_DCONV
!   Tot Exts : 16  Next Ext (Kb): 19176  Kb Avail TS : 12304
!   Max(File Growth Remaining) : 7 mb
! AZT.AZT_INVENTORY_AGING_REPORT in tablespace AZ_DCONV
!   Tot Exts : 18  Next Ext (Kb): 43152  Kb Avail TS : 12304
!   Max(File Growth Remaining) : 7 mb
! AZT.AZT_INVENTORY_EXPOSURE_REPORT in tablespace AZ_DCONV
!   Tot Exts : 17  Next Ext (Kb): 28768  Kb Avail TS : 12304
!   Max(File Growth Remaining) : 7 mb
! AZT.AZT_INV_AGING_QTY_RECEIPT in tablespace AZ_DCONV
!   Tot Exts : 17  Next Ext (Kb): 28768  Kb Avail TS : 12304
!   Max(File Growth Remaining) : 7 mb
! AZT.AZT_INV_AGING_RCV_DATE in tablespace AZ_DCONV
!   Tot Exts : 16  Next Ext (Kb): 19176  Kb Avail TS : 12304
!   Max(File Growth Remaining) : 7 mb
! AZT.AZT_INV_AGING_RCV_NUNIQUE in tablespace AZ_DCONV
!   Tot Exts : 15  Next Ext (Kb): 12784  Kb Avail TS : 12304
!   Max(File Growth Remaining) : 7 mb
! DATACONV.MTL_SYSTEM_ITEMS_TEMP_211099 in tablespace AZ_DCONV
!   Tot Exts : 1  Next Ext (Kb): 12784  Kb Avail TS : 12304
!   Max(File Growth Remaining) : 7 mb


[Jobs] Exec Time 0 seconds
~ None


[redundant object privs with conflicting grant option] Exec Time 26 seconds
! Object SYS.DUAL: SELECT granted to PUBLIC
!   granted by SYSTEM without grant option
!   granted by SYS with grant option


[Profiles that are not granted to any user] Exec Time 0 seconds
~ None


[Tablespace Fragmentation] Exec Time 192 seconds
~ A common set of extent sizes is a good way to reduce tablespace fragmentation.
~ Sometimes fragmentation can be improved with 'Alter tablespace coalesce'.
~ Tablespace fragmentation should not be a problem if you use locally managed tablespaces.
~

======================================================================
== TableSpace Name                     %         # of        # of   ==
==                                 Fragmented    Extents     Holes  ==
======================================================================
! APPLSYSX                            41            376      262
! BOMD                                55            127      157
! BOMX                                64            223      396
! OEX                                100            293    65215


[Tablespaces with less than 10% free space] Exec Time 171 seconds
! AKX                       : 9.6% Free Space,  MB Free / Total : 1 / 10
! APX                       : 6% Free Space,  MB Free / Total : 42 / 700
! ARX                       : 8.3% Free Space,  MB Free / Total : 46 / 550
! AZ_DCONV                  : 8.9% Free Space,  MB Free / Total : 49 / 543
! CND                       : 1.2% Free Space,  MB Free / Total : 0 / 19
! GLX                       : 8% Free Space,  MB Free / Total : 40 / 500
! INVD                      : 5.1% Free Space,  MB Free / Total : 279 / 5500
! INVX                      : 9.9% Free Space,  MB Free / Total : 680 / 6850
! OED                       : 2.5% Free Space,  MB Free / Total : 172 / 6900
! POD                       : 9.5% Free Space,  MB Free / Total : 369 / 3900
! POX                       : 5.6% Free Space,  MB Free / Total : 129 / 2290

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/2830/viewspace-479912/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/2830/viewspace-479912/