Skip to Content
0
Former Member
Feb 18, 2011 at 11:59 AM

Tablespaces 100% used

515 Views

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