一下是检查报告,请帮忙分析一下系统中存在的问题,及改善建议,多谢
********************************************************************
*** 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
********************************************************************
*** 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
![13.gif](https://i-blog.csdnimg.cn/blog_migrate/6e36ba67cef0c93d6b0b247c2bba0efc.png)
! 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
![33.gif](https://i-blog.csdnimg.cn/blog_migrate/b968e3c74f55b41e8be1caa4cbbe7ad2.png)
! Column APPS.PABV_BUDGET_VERSIONS._LA
![13.gif](https://i-blog.csdnimg.cn/blog_migrate/6e36ba67cef0c93d6b0b247c2bba0efc.png)
! Column APPS.PABV_CLASS_CATEGORIES._LA:autoaccounting_flag
! Column APPS.PABV_CLASS_CATEGORIES._LA:mandatory_flag
! Column APPS.PABV_CLASS_CATEGORIES._LA
![13.gif](https://i-blog.csdnimg.cn/blog_migrate/6e36ba67cef0c93d6b0b247c2bba0efc.png)
! 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
![13.gif](https://i-blog.csdnimg.cn/blog_migrate/6e36ba67cef0c93d6b0b247c2bba0efc.png)
! 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
![13.gif](https://i-blog.csdnimg.cn/blog_migrate/6e36ba67cef0c93d6b0b247c2bba0efc.png)
! 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
![13.gif](https://i-blog.csdnimg.cn/blog_migrate/6e36ba67cef0c93d6b0b247c2bba0efc.png)
! Column APPS.PABV_PROJECTS._LA
![13.gif](https://i-blog.csdnimg.cn/blog_migrate/6e36ba67cef0c93d6b0b247c2bba0efc.png)
! 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
![13.gif](https://i-blog.csdnimg.cn/blog_migrate/6e36ba67cef0c93d6b0b247c2bba0efc.png)
! 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
![13.gif](https://i-blog.csdnimg.cn/blog_migrate/6e36ba67cef0c93d6b0b247c2bba0efc.png)
! Column APPS.PABV_TASKS._LA:service_type
! Column APPS.PABV_TRANSACTION_SOURCES._LA:costed_flag
! Column APPS.PABV_TRANSACTION_SOURCES._LA
![13.gif](https://i-blog.csdnimg.cn/blog_migrate/6e36ba67cef0c93d6b0b247c2bba0efc.png)
! Column APPS.PAFV_ACCOUNTING_PERIODS._LA:current_pa_period_flag
! Column APPS.PAFV_ACCOUNTING_PERIODS._LA
![13.gif](https://i-blog.csdnimg.cn/blog_migrate/6e36ba67cef0c93d6b0b247c2bba0efc.png)
! 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
![33.gif](https://i-blog.csdnimg.cn/blog_migrate/b968e3c74f55b41e8be1caa4cbbe7ad2.png)
! Column APPS.PAFV_BUDGET_VERSIONS._LA
![13.gif](https://i-blog.csdnimg.cn/blog_migrate/6e36ba67cef0c93d6b0b247c2bba0efc.png)
! Column APPS.PAFV_CLASS_CATEGORIES._LA:autoaccounting_flag
! Column APPS.PAFV_CLASS_CATEGORIES._LA:mandatory_flag
! Column APPS.PAFV_CLASS_CATEGORIES._LA
![13.gif](https://i-blog.csdnimg.cn/blog_migrate/6e36ba67cef0c93d6b0b247c2bba0efc.png)
! 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
![13.gif](https://i-blog.csdnimg.cn/blog_migrate/6e36ba67cef0c93d6b0b247c2bba0efc.png)
! 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
![13.gif](https://i-blog.csdnimg.cn/blog_migrate/6e36ba67cef0c93d6b0b247c2bba0efc.png)
! 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
![13.gif](https://i-blog.csdnimg.cn/blog_migrate/6e36ba67cef0c93d6b0b247c2bba0efc.png)
! Column APPS.PAFV_PROJECTS._LA
![13.gif](https://i-blog.csdnimg.cn/blog_migrate/6e36ba67cef0c93d6b0b247c2bba0efc.png)
! 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
![13.gif](https://i-blog.csdnimg.cn/blog_migrate/6e36ba67cef0c93d6b0b247c2bba0efc.png)
! 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
![13.gif](https://i-blog.csdnimg.cn/blog_migrate/6e36ba67cef0c93d6b0b247c2bba0efc.png)
! Column APPS.PAFV_TASKS._LA:service_type
! Column APPS.PAFV_TRANSACTION_SOURCES._LA:costed_flag
! Column APPS.PAFV_TRANSACTION_SOURCES._LA
![13.gif](https://i-blog.csdnimg.cn/blog_migrate/6e36ba67cef0c93d6b0b247c2bba0efc.png)
! 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/