 |  |  |  |  |  |  |  |
!! Size of a table
Please support our Oracle advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
Please help me out to find the actual size of the table .
i have used two methods one is (num_rows*avg_row_len)/1024 .
other one vsize(columns1) (for each column in table).
but both the methods are not giving me the right answer help me if u know actual method to find the table size using table overhead ,pctfree and pctused parameters
i have used two methods one is (num_rows*avg_row_len)/1024 .
other one vsize(columns1) (for each column in table).
but both the methods are not giving me the right answer help me if u know actual method to find the table size using table overhead ,pctfree and pctused parameters
|
Similar Threads
- display:block to show a table? (JavaScript / DHTML / AJAX)
- Set, View, Change, or Remove Special Permissions for Files and Folders in Windows XP (Windows tips 'n' tweaks)
- Refresh a table (Java)
- table shrinking (HTML and CSS)
- table and the index size(individually). (MS SQL)
- table and the index size(individually). (MS SQL)
- rounding corners of a table (HTML and CSS)
- html table to .csv (HTML and CSS)
- compile error-chained hash table c++ (C++)
- Need help with HTMl Table echoing? (PHP)
Other Threads in the Oracle Forum
- Previous Thread: Export into xml
- Next Thread: How can i view tables in the databse
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Oracle Posts
- Today's Posts
- Unanswered Threads
2009predictions acquisition amazon.com bartz bernanke cia citrix cloudcomputing crm database dell economy editor enterprise enterprise2.0 enterprisesoftware federalreserve forbes hp ibm intellipedia internet larryellison layoffs linux loughridge mediawiki michaeljackson microsoft neverland nortel notebooks oil operatingsystem oracle palm rimm saas salesforce sap seagate socialcomputing sql sun sybase technologystocks virtualiron virtualization vmware wiki wikipedia xen yahoo zoho
