1. Forum
  3. T24 Technical Discussions
  5. T24 Administration
  7. High growth of SYSTEM tablespace in oracle databas
× Discuss about Archiving, Close of Business, Delivery Setup, Security Management System, Global Processing etc…

High growth of SYSTEM tablespace in oracle databas

  • javedt24
  • Topic Author
  • Offline
  • New Member
  • New Member
More
14 years 4 months ago #6510 by javedt24
High growth of SYSTEM tablespace in oracle databas was created by javedt24
Hi there

We are using Temenus T24 R6. As a database , we are using Oracle 10g R2 in AIX Environment.
sometime I have noticed abnormal growth of System Tablespace in my oracle database. I am trying to search out the reason behind this. Can anybody share me the Idea regarding system tablespace abnormal growth.

Regards

Jav

Please Log in or Create an account to join the conversation.

More
12 years 6 months ago #13197 by Nett
Replied by Nett on topic High growth of SYSTEM tablespace in oracle databas
Do you use Expdp to export you data?

Please Log in or Create an account to join the conversation.

  • javedt24
  • Topic Author
  • Offline
  • New Member
  • New Member
More
12 years 6 months ago #13199 by javedt24
Replied by javedt24 on topic High growth of SYSTEM tablespace in oracle databas
Hi
Thanks for your mail.
Yes We are using expdp. We hove found out the reason of abnormal growth of system tablepace. Some time expdp got cancel implicit that time an object is created with GB space in system tablespace. So I have to notice DBA_DATAPUMP_JOBS data dictionary , if there any jobs name found with disable status , I should drop it. And in this way I had solved the problem.

Please Log in or Create an account to join the conversation.

  1. Forum
  3. T24 Technical Discussions
  5. T24 Administration
  7. High growth of SYSTEM tablespace in oracle databas
Time to create page: 0.035 seconds