hi All,
the tablespaces on PRD server(ECC 6, Oracle 10 g, Window server 2003)
Tablespace name Size(MB) Free(MB) Used(%) Autoextend Total size(MB) Sum of all free fragments(MB) Total used (%) #Files #Segments #Extents Status Contents PSAPSR3 148,192.00 673.5 100 YES 180,000.00 32,481.50 82 16 155,048 226,940 ONLINE PERMANENT PSAPSR3700 65,740.00 291.88 100 YES 130,000.00 64,551.88 50 13 801 8,231 ONLINE PERMANENT PSAPSR3USR 30 22.81 24 YES 10,000.00 9,992.81 0 1 70 114 ONLINE PERMANENT PSAPTEMP 6,990.00 6,990.00 0 YES 10,000.00 10,000.00 0 1 0 0 ONLINE TEMPORARY PSAPUNDO 8,860.00 7,974.31 10 YES 10,000.00 9,114.31 9 1 21 484 ONLINE UNDO SYSAUX 1,020.00 42.56 96 YES 10,000.00 9,022.56 10 1 916 2,666 ONLINE PERMANENT SYSTEM 870 17.44 98 YES 10,000.00 9,147.44 9 1 1,212 2,813 ONLINE PERMANENT
SAPSR3 and PSAPSR3700 is used 100%, now what i have to do mean simply add the file or extent the value of used tablespaces.
Regards,
Diya