You are here:

Oracle/table size is increasing abnormally

Advertisement


Question
Hi Peter,

I have a table the growth of it's normal in the morning but later in the afternoon the table size is increasing abnormally. Could you please explain me what could be the reason for it.

Regards,
Kumar

Answer
HI Kumar,

If your table is being used as a temporary table to store values, then it's possible that it can grow quickly. You need to understand the application that is using the table to understand why the sudden growth. If the table continues to growing daily, you will definitely want to (a) re-size it accordingly; (b) find out from the application and  business users what they are doing to cause the growth.

I hope this helps given the scant pieces of information available.

Peter

Oracle

All Answers


Answers by Expert:


Ask Experts

Volunteer


Peter Choi

Expertise

I am a senior Oracle DBA, PeopleSoft HCM specialist and Project Manager with 15+ years experience. I have been working with PeopleSoft (HRMS/HCM 5, 7, 7.x and 8.9, 9.x), Oracle RDBMS (7.3 - 11gR2) on various Unix and MS-Windows platforms, and some Oracle Application Server (9i - 11gR1). I also have experience with the configuration and administration of PeopleSoft's Internet Architecture (PIA) and the Oracle 11g Fusion Middleware and Oracle Business Intelligence (OBI).

©2016 About.com. All rights reserved.