Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Multiple extents on SYS tables
Please see the following report of multiple extents
for SYS table, cluster, index.
We are not currently receiving any errors.
Is there a potential problem?
If so, how do you recommend fixing the situation?
Thank you, Derek
Objects with Multiple Extents Page: 1
Owner Name Type Extents Max ------------- -------------------- ------ ------ ------ SYS ACCESS$ Table 9 ###### SYS ARGUMENT$ Table 4 ###### SYS ATTRCOL$ Table 56 ###### SYS ATTRIBUTE$ Table 4 ###### SYS CCOL$ Table 14 249 SYS CDEF$ Table 14 249 SYS CLU$ Table 56 ###### SYS COL$ Table 56 ###### SYS COLLECTION$ Table 4 ###### SYS COLTYPE$ Table 56 ###### SYS COM$ Table 3 ###### SYS CON$ Table 11 249 SYS C_COBJ# Cluster 14 249 SYS C_FILE#_BLOCK# Cluster 12 249 SYS C_OBJ# Cluster 56 ###### SYS C_TOID_VERSION# Cluster 4 ###### SYS C_TS# Cluster 5 249 SYS C_USER# Cluster 5 249 SYS DEPENDENCY$ Table 6 ###### SYS FET$ Table 5 249 SYS ICOL$ Table 56 ###### SYS IDL_CHAR$ Table 2 ###### SYS IDL_SB4$ Table 3 ###### SYS IDL_UB1$ Table 10 ###### SYS IDL_UB2$ Table 12 ###### SYS IND$ Table 56 ###### SYS I_ACCESS1 Index 4 ###### SYS I_ARGUMENT1 Index 4 ###### SYS I_CCOL1 Index 10 249 SYS I_CCOL2 Index 10 249 SYS I_CDEF1 Index 9 249 SYS I_CDEF2 Index 10 249 SYS I_CDEF4 Index 11 249 SYS I_COBJ# Index 4 249 SYS I_COL1 Index 54 ###### SYS I_COL2 Index 22 ###### SYS I_COL3 Index 21 ###### SYS I_COM1 Index 2 ###### SYS I_CON1 Index 12 249 SYS I_CON2 Index 11 249 SYS I_DEPENDENCY1 Index 4 ###### SYS I_DEPENDENCY2 Index 5 ###### SYS I_FILE#_BLOCK# Index 7 249 SYS I_ICOL1 Index 7 249 SYS I_IDL_CHAR1 Index 2 249 SYS I_IDL_SB41 Index 2 249 SYS I_IDL_UB11 Index 2 249 SYS I_IDL_UB21 Index 2 249 SYS I_IND1 Index 4 249 SYS I_OBJ# Index 6 249 SYS I_OBJ1 Index 7 249 SYS I_OBJ2 Index 10 ###### SYS I_OBJAUTH1 Index 4 249 SYS I_OBJAUTH2 Index 4 249 SYS I_SOURCE1 Index 12 ###### SYS I_STMT_AUDIT_OPTION_MAP Index 2 249 SYS I_SYN1 Index 2 249 SYS I_SYSAUTH1 Index 2 249 SYS I_USER# Index 2 249 SYS I_USER1 Index 2 249 SYS I_VIEW1 Index 5 249 SYS KOTAD$ Table 2 249 SYS KOTTD$ Table 2 249 SYS LIBRARY$ Table 56 ###### SYS LOB$ Table 56 ###### SYS METHOD$ Table 4 ###### SYS NTAB$ Table 56 ###### SYS OBJ$ Table 13 ###### SYS OBJAUTH$ Table 3 249 SYS PARAMETER$ Table 4 ###### SYS R00 Rollback 2 20 SYS R01 Rollback 6 249 SYS R02 Rollback 4 249 SYS R03 Rollback 4 249 SYS R04 Rollback 4 249 SYS RBSBIG Rollback 4 249 SYS REFCON$ Table 56 ###### SYS RESULT$ Table 4 ###### SYS SEG$ Table 12 249 SYS SOURCE$ Table 28 ###### SYS SYN$ Table 3 249 SYS SYSAUTH$ Table 2 249 SYS SYSTEM Rollback 13 249 SYS TAB$ Table 56 ###### SYS TS$ Table 5 249 SYS TSQ$ Table 5 249 SYS TYPE$ Table 4 ###### SYS TYPE_MISC$ Table 56 ###### SYS UET$ Table 12 249 SYS USER$ Table 5 249 SYS VIEW$ Table 30 ######
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Oct 18 1999 - 12:11:00 CDT