on 08-13-2008 1:35 PM
A developer used the max_row_per_page configuration set to 50% to apred out the data of a 500 MB table.His boss thought this was a waste of space since the table now took up 1000MB.Why would someone do this?
The same developer created an index on the table using fill_factor of 50%.This caused the index to use twice as many index pages.Why would he do that?
Hi,
Are you working on SYBASE database ?
you may post it there...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi there,
what the heck is the "max_row_per_page configuration" ??
I'm pretty sure that I know quite a bit about segment storage option in Oracle, but this setting is totally new to me.
Could it be that you mean something like PCTFREE/PCTUSED?
Usually one might think on trying to influence such low level storage to archieve things like less locking contention on a single block or to avoid chained rows.
Anyhow, with the advent of ASSM the need for such action has greatly decreased.
regards,
Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Why not ask the developer why he did that?
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.