You are here:

Oracle/table size is increasing abnormally


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.


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.



All Answers

Answers by Expert:

Ask Experts


Peter Choi


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 All rights reserved.