SQL Language (MOSC)

MOSC Banner

how does MERGE command work

edited Sep 17, 2010 3:03AM in SQL Language (MOSC) 14 commentsAnswered
Hello, I am trying to explain a sizing discrepancy in two of my tables. For one of them the average row length is 101 and the number of rows is 362mil. Its size - calculated as select sum(bytes) from dba_segments is about 150G. The other table has average row length 33, the number of rows 16mil and the size of about 40G. When I use oracle create_table_cost procedure, the size estimates that I see are  40G (instead of 150G) for the table1 and 900M (instead of 40G) for the table2. I also did a quick calculation just multiplying the record lenght by the number

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center