TABLES
To work out the sizings of x number of records then need to be added to a table, use the following ...
Analyze the table or partition. Find the avg_row_len, from either dba_tables or tab_tab_partitions. Then calculate the space required by ...
space_required = avg_row_len * number_of_rows
This formula is really simple and is not perfect as it doesn't take block headers, pct_free etc into consideration, but should be good as a guide.
skip to main |
skip to sidebar
Labels
- architecture (2)
- bug (1)
- certification (1)
- character set (2)
- constaints (1)
- database links (2)
- dba (2)
- ddl (1)
- discoverer (1)
- Discussion (3)
- dml (1)
- dynamic sql (1)
- exceptions (1)
- execute immediate (1)
- faq (1)
- flashback (2)
- hardware (2)
- hints (3)
- keyboard (2)
- locks (1)
- mac (2)
- materialized views (1)
- partitions (3)
- performace (3)
- performance (1)
- plsql (4)
- recovery (2)
- redo (1)
- sizing (1)
- SQL (8)
- star (1)
- storage (1)
- table (1)
- tables (1)
- tablespaces (2)
- temp tablespace (1)
- transformation (1)
- tuning (1)
- UNDO (4)
- unix (1)
- upgrade (1)
- waits (1)
- wrapper (1)
- xplan (2)
me
