Home » RDBMS Server » Performance Tuning » SYSTEM TS is increasing (10g RAC HP UX)
SYSTEM TS is increasing [message #412236] Wed, 08 July 2009 05:58 Go to next message
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.
Re: SYSTEM TS is increasing [message #412253 is a reply to message #412236] Wed, 08 July 2009 06:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: SYSTEM TS is increasing [message #412261 is a reply to message #412253] Wed, 08 July 2009 07:17 Go to previous message
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
Previous Topic: 9i -> 10g causes JAVA performance problems
Next Topic: Performance question
Goto Forum:
  


Current Time: Sat Dec 03 01:14:17 CST 2016

Total time taken to generate the page: 0.08885 seconds