Sudden Space increase in a table space

Posted on 2013-06-03
Medium Priority
Last Modified: 2013-06-24

There is a sudden spike in the space used up in one of the table spaces. 300 Gig increase in 2 days. Is there a way to find which table(s) the data went into or Identify the program that resulted in the data spike..

Please advice..

Question by:gs79
LVL 78

Accepted Solution

slightwv (䄆 Netminder) earned 2000 total points
ID: 39217677
Are you running AWR?

Check out the queries here:
LVL 35

Expert Comment

ID: 39223076
With that much growth, you may be able to find it with just looking at the largest objects in the tablespace.  You can do that with this query:
SELECT owner, 
       SUM(bytes) tot_size 
FROM   dba_extents 
WHERE  tablespace_name = '<ts>' 
GROUP  BY owner, 
ORDER  BY tot_size DESC 

Open in new window

You need to replace <ts> with the name of the tablespace.

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question