K
K
Kvert0072014-10-06 13:37:53
Oracle
Kvert007, 2014-10-06 13:37:53

Why is oracle database 11g eating disk space fast?

Hello! There is a DB Orakl 11g. The base is not big. One job is constantly running, which performs selects, updates and deleting records in some table. A stored procedure is also called that creates/deletes or modifies the user's schema. The problem is that this job or procedure quickly consumes hard disk space. Audit is disabled. Who can tell what is the reason?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
V
Vladimir, 2014-10-06
@Kvert007

Maybe undo tablespace takes up a lot of space?

K
Kvert007, 2014-10-07
@Kvert007

fulfilled

SELECT DISTINCT STATUS,TABLESPACE_NAME, SUM(BYTES)/1024/1024, COUNT(*) 
FROM DBA_UNDO_EXTENTS 
GROUP BY STATUS, TABLESPACE_NAME;

I got the size of EXPIRED and UNEXPIRED, they are only 1 and 9 MB each, so that's not the point.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question