GeekArticles
FAQ
Oracle FAQToatl free space and largest extents
Author: asktom.oracle.com |
Published: 10th May 2008 |
Visited: 147 times |
Add CommentFiled in: Oracle FAQHi 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...
Read Article Sponsored Links
Related Articles
• Why a transaction cannot reuse space that was deleted from Tom, in your recent presentation in Hartford you were discussing the difference in refreshing materialized views from version 9 to 10 in that it went from a truncate/insert to a delete/insert which caused some confusion. You also mentioned in the c ...
• The Joys and Dangers of Impedence-Free Societies A couple of weeks ago, when I was in New York for the AJAXWorld conference, the city welcomed me with a major downpour most of the time I was there. The metaphor about storm clouds building over Wall Street wa ...
• Download the Free Web Application Security eKit: Discover how IBM Rational AppScan Standard Edition can help you detect vulnerabilities in your Web applications in the Web Application Security eKit. IBM Rational AppScan is a leading suite of automated Web application security solutions that scan and test for common Web application vulnerabilities. ...
• Review: Money for Content and Your Clicks For Free In this article, Steve reviews JD Frazer's (User Friendly Cartoonist) book on turning web sites, blogs, and podcasts into cash. The book includes a lot of useful knowledge for any developer/bloggers seeking to earn some income from their online writ ...
• Emacs command mark the block (Ctrl+Space) does not work QC#: 5871 Version: 7.0 Status: Open defect, requires resolution Description: The Emacs key mapping has very limited functionality. In some cases it's a very frustrating when even basic commands does not work properly, e.g. mark beginning or end of the ...