Re: Multiple extents on SYS tables

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 19 Oct 1999 19:45:21 +0800
Message-ID: <380C59D1.4E83@yahoo.com>

Derek Runstadler wrote:
>
> 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
> ********************************************************
> Minimum number of Extents = 2
> Printing a flag where Max_Extents - Extents <= 2
>
> 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.

I wouldn't worry about it too much...Oracle reads the data dictionary almost exclusively using index reads and thus extents is not such an issue. You may want to alter the 'next' extent to ensure that you don't run out (which WOULD be an issue)

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Tue Oct 19 1999 - 06:45:21 CDT