Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Multiple extents on SYS tables

Multiple extents on SYS tables

From: Derek Runstadler <drunstad_at_my-deja.com>
Date: Mon, 18 Oct 1999 17:11:00 GMT
Message-ID: <7ufkar$pka$1@nnrp1.deja.com>


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. Received on Mon Oct 18 1999 - 12:11:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US