You are hereScripts / Oracle Space Management
Oracle Space Management
Oracle database space monitoring scripts that an oracle database administrator would be interested in. For example tablespace monitoring, extent monitoring etc.
ORA-06502 PL/SQL: numeric or value error
ORA-6502 mostly occurs during execution of code in an oracle database due to a bug in the SQL or PL/SQL code. The primary reason this oracle error occurs is when you try to assign a value to a numeric variable but the value is larger than the variable can handle. ORA-06502 oracle error also occurs if you are trying to assign a non-numeric value to a numeric variable
Oracle segments with maximum extents : Top10
Oracle Database Administration Script that produces a listing of top 10 segments with large number of extents. If you do not get any output, it would mean that all your objects have extents less than 10.