Skip to Content
0

Oracle 11.2.0.4 - very fast increase of PSAPDAT.

Dec 01, 2016 at 09:24 AM

188

avatar image
Former Member

Dear All,

I would like to ask you about one important thing, every few weeks I see very fast growing data in the Oracle DB (11.2.0.4), table space PSAPDAT. Size of the database this is around 2.0TB, daily grow is more or less around 300MB and suddenly DB growing around 50 or 60 GB per day. Few weeks’ normal work and again fast growing in some day.

Hard to say what can be the reason from business perspective, because system is very intensive used, lot of the data are loaded to the system, lot of the changes etc. When I check growing of the single tables during month, data grow is more or less on around max. 3 GB.

I’m just wondering if it’s not an Oracle error, have you ever seen something just like that? How to find the reason of the fast growing tablespace?

Regards,

Tomasz

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

avatar image
Former Member Dec 01, 2016 at 08:40 PM
0

Hi Tomasz,

Check what are the fast growing tables in this tablespace and what is the growth per day/specific day when business is doing massive data load etc.

Hard to say what can be the reason from business perspective, because system is very intensive used, lot of the data are loaded to the system, lot of the changes etc. When I check growing of the single tables during month, data grow is more or less on around max. 3 GB.
Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 05, 2016 at 08:57 AM
0

Hi Harish,

Thank you for your response. What is the most interesting, most grooving table is EDI40 (standard EDI table), and by the day table growing around 141MB, and whole month around 3.5GB. But as I mentioned someday size of the tablespace grooving around 60GB per day, this is really strange.

When I create new files for tablespace, I’ve always use “autoextend on next 256MB”, but in the other hand when I’ve checked TOP EXTENS tables, for some tables next extent is – 1.700,000 MB. Maybe this is the reason ?

I mean when, lot of the data is loaded to the table EDI40, and next extent is 1.700 MB, then Oracle suddenly increase size of the table space according to the next next extent for table (1.700MB), not for file (256MB) ?

Regards,

Tomasz

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 05, 2016 at 03:48 PM
0

Hi Tomasz,

I suspect the tablespace growth is not because of table growth but because of segments, Can you take a look at fast growing segments as well?

Suggest you to open an incident with BC-DB-ORA component for detailed analysis on this behavior.

Regards,

Harish Karra

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member
Dec 06, 2016 at 08:17 AM
0

Hi,

What you mentioned about the next extent is a bit curious. could you do the following queries:

set pagesize 100

set linesize 100

select tablespace_name, initial_extent, next_extent

from dba_tables

where table_name = 'EDI40';

select tablespace_name, extent_management, allocation_type, segment_space_management
from dba_tablespaces;

Share
10 |10000 characters needed characters left characters exceeded