Situation Here is we have increased initial extents of each table to 10 MB in Production server . now we would like to monitor how much space has been occupied in each table .
could u suugest me the sql query .
when exactly do we need to increase the initial extent?
what difference does it make if the initial extent is increased or no?
another question, if i increase the initial extent and i have set the pctincrease to a number greater than zero, does that mean that the next extents will grow also? ( i mean the extents already created).