GeekArticles
FAQ
Oracle FAQ
FAQ
Oracle FAQToatl free space and largest extents
Hi Tom,
I am new to this blog. I have one doubt regarding fragmentation.
select TABLESPACE_NAME,
sum(BYTES),
max(BYTES)
from dba_free_space
group by TABLESPACE_NAME;
If we give this query we will get sum(BYTES)-s...
Sponsored Links
Related Topics
Subscribe via RSS
Oracle FAQ
- Synchronize data from remote location
- Oracle Fundamentals
- How to connect SQLPlus without tnsnames.ora
- Best Practices for App Server Keep Alive
- bind variables in triggers
- how to avoid outer joins
- One 900 column table versus ten 90 column tables.
- Does select generate undo ?
- Performance Question
- Help analyze statspack report
