OraFAQ Forum: Performance Tuning » SYSTEM TS is increasing

Home » RDBMS Server » Performance Tuning » SYSTEM TS is increasing (10g RAC HP UX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SYSTEM TS is increasing [message #412236]

Wed, 08 July 2009 05:58

madhavamanohar
Messages: 58
Registered: February 2009

Member

Hi All,

My system tablespace is increasing too much.

Can you please tell me..Why its increasing. Will system tablespace wiil increase?
Only three users is having as default TS as SYSTEM.

Its RAC HP UX 10g.

Below are increasing.

select OBJECT_NAME,OBJECT_TYPE,LAST_DDL_TIME from dba_objects where owner='SYSTEM' order by LAST_DDL_TIME;
REPCAT$_REPCATLOG TABLE 03-MAY-09
SYS_LOB0000600349C00039$$ LOB 08-JUL-09
SYS_MTABLE_00009291D_IND_1 INDEX 08-JUL-09
TEST_EXPDP TABLE 08-JUL-09
SYS_C00146004 INDEX 08-JUL-09
SYS_MTABLE_00009291D_IND_2 INDEX 08-JUL-09

OBJECT_NAME OBJECT_TYPE LAST_DDL_TIME
-------------------------------------------------- ------------------- ------------------
SYS_LOB0000600390C00039$$ LOB 08-JUL-09
SYS_EXPORT_FULL_01 TABLE 08-JUL-09
SYS_MTABLE_000092946_IND_2 INDEX 08-JUL-09
SYS_C00146014 INDEX 08-JUL-09
SYS_MTABLE_000092946_IND_1 INDEX 08-JUL-09
SYS_LOB0000600431C00039$$ LOB 08-JUL-09
SYS_C00146024 INDEX 08-JUL-09
SYS_MTABLE_00009296F_IND_1 INDEX 08-JUL-09
SYS_MTABLE_00009296F_IND_2 INDEX 08-JUL-09
SYS_EXPORT_FULL_02 TABLE 08-JUL-09

494 rows selected.
Thanks in advance.

Report message to a moderator

Re: SYSTEM TS is increasing [message #412253 is a reply to message #412236]

Wed, 08 July 2009 06:36

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Only three users is having as default TS as SYSTEM.

Only ONE should: SYS.

What are the owners of the objects?

Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Regards
Michel

Report message to a moderator

Re: SYSTEM TS is increasing [message #412261 is a reply to message #412253]

Wed, 08 July 2009 07:17

madhavamanohar
Messages: 58
Registered: February 2009

Member

SYS SYSTEM AND OUTLN

BUT FOR sys and syatem only last DDL happend..!
WRH$_ACTIVE_SESSION_HISTORY_PK INDEX PARTITION 08-JUL-09
WRH$_TABLESPACE_STAT TABLE PARTITION 08-JUL-09
WRH$_TABLESPACE_STAT TABLE PARTITION 08-JUL-09
WRH$_SYS_TIME_MODEL TABLE PARTITION 08-JUL-09
WRH$_SYS_TIME_MODEL TABLE 08-JUL-09
WRH$_OSSTAT_PK INDEX PARTITION 08-JUL-09
WRH$_OSSTAT_PK INDEX PARTITION 08-JUL-09
WRH$_OSSTAT TABLE 08-JUL-09
WRH$_OSSTAT TABLE PARTITION 08-JUL-09
WRH$_OSSTAT TABLE PARTITION 08-JUL-09
WRH$_TABLESPACE_STAT_PK INDEX PARTITION 08-JUL-09

OBJECT_NAME OBJECT_TYPE LAST_DDL_TIME
-------------------------------------------------- ------------------- ------------------
WRH$_TABLESPACE_STAT TABLE 08-JUL-09
WRH$_SYS_TIME_MODEL TABLE PARTITION 08-JUL-09
WRH$_TABLESPACE_STAT_PK INDEX PARTITION 08-JUL-09
WRH$_INST_CACHE_TRANSFER TABLE 08-JUL-09
WRH$_INST_CACHE_TRANSFER TABLE PARTITION 08-JUL-09
WRH$_INST_CACHE_TRANSFER TABLE PARTITION 08-JUL-09
WRH$_SERVICE_WAIT_CLASS_PK INDEX PARTITION 08-JUL-09
WRH$_SERVICE_WAIT_CLASS_PK INDEX PARTITION 08-JUL-09
WRH$_SYS_TIME_MODEL_PK INDEX PARTITION 08-JUL-09
WRH$_SYS_TIME_MODEL_PK INDEX PARTITION 08-JUL-09
WRH$_SERVICE_WAIT_CLASS TABLE PARTITION 08-JUL-09

OBJECT_NAME OBJECT_TYPE LAST_DDL_TIME
-------------------------------------------------- ------------------- ------------------
WRH$_SERVICE_WAIT_CLASS TABLE PARTITION 08-JUL-09
WRH$_SERVICE_WAIT_CLASS TABLE 08-JUL-09
WRH$_INST_CACHE_TRANSFER_PK INDEX PARTITION 08-JUL-09
WRH$_INST_CACHE_TRANSFER_PK INDEX PARTITION 08-JUL-09

Report message to a moderator

Previous Topic:	9i -> 10g causes JAVA performance problems
Next Topic:	Performance question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 16:21:08 CST 2024