Hello to all,
I have to improve performance when I storing the data and I do not know exactly
where to start.
I query dba_segments&dba_extents and I found that I have segments whit more then 20 extents and pct_increase =50.
I ran a query that gave me the fragmentation of free space in the tablespace
GROUP BY tablespace_name
ORDER BY 1;
The output is:
My questions are:
1.How can I find how bad a segment is fragmented?
2.How can modify the storage parameters for a tablespace very fast?