This content has been marked as final. Show 7 replies
Looks like you've misaligned the columns in your query. I still see 3584MB in the output, so you did something funny either in the query or in aligning the columns when pasting.
I have realigned to the best possible.
I am sure that the Used Space is reduced.
What may be the reason?
Oracle 11g 18.104.22.168 standard edition
Sorry - something just doesn't make sense.
4G isn't 3584M
Are you using two different databases or something?
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
Your first post doesn't support what you say.
You say you resized the file to 4GB, but your query shows the file size as 3584 MB.
So, the only thing I can say is that you've confused yourself somewhere, as I have done to myself many times before :)
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 /
I realigned to the best possibleuse
for such monospaced texts