This content has been marked as final. Show 7 replies
No, I am not using two different database.
Also I have used 4G only while resizing the datafile.
At the time I resized to 4G and turned autoextend off, it was displaying Used space as 3584MB
But today when I checked. It it is reduced.
And for another datafile of same tablespace, I made auto extend on. But the Total Size was 512M and used was 0M
But today when I checked Total became 1024M and Used remained 0M
Also, the front end application works fine.
I am just shock with the used space.
Every three days, datafile undergo shrinking by oracle shrink command.
Will this impact on the used space?
Edited by: Madhu.149 on Oct 5, 2012 5:55 PM
demonstrate the output:
SET ECHO OFF SET FEEDBACK 6 SET HEADING ON SET LINESIZE 180 SET PAGESIZE 50000 SET TERMOUT ON SET TIMING OFF SET TRIMOUT ON SET TRIMSPOOL ON SET VERIFY OFF CLEAR COLUMNS CLEAR BREAKS CLEAR COMPUTES COLUMN owner FORMAT a20 HEADING "Owner" COLUMN tablespace_name FORMAT a30 HEADING "Tablespace Name" COLUMN segment_type FORMAT a18 HEADING "Segment Type" COLUMN bytes FORMAT 9,999,999,999,999 HEADING "Size (in Bytes)" COLUMN seg_count FORMAT 9,999,999,999 HEADING "Segment Count" BREAK ON report ON owner SKIP 2 COMPUTE sum LABEL "" OF seg_count bytes ON owner COMPUTE sum LABEL "Grand Total: " OF seg_count bytes ON report SELECT owner , tablespace_name , segment_type , sum(bytes) bytes , count(*) seg_count FROM dba_segments GROUP BY owner , tablespace_name , segment_type ORDER BY owner , tablespace_name , segment_type /