Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

System Tablespace has grown to 15gb on production

MaahjoorMay 29 2016 — edited May 30 2016

dear all,

i have oracle database 12c enterprise edition 64 bit on windows server 2012 64 bit.

my system table space is grown to 15gb. i think i was using some bench-marking which create objects there.

how to cleanup? i follow Tom Keats blog, https://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:153612348067

now, i get the following results,

VALUE

--------------------------------------------------------------------------------

8192

1 row selected.

	Smallest
	Size Current	Poss.
FILE_NAME	Poss.	Size Savings

-------------------------------------------------- -------- -------- --------

F:\APP\ADMINISTRATOR\ORADATA\ORCL\DATAFILE\O1_MF_S 16,001 16,020	19
YSTEM_CC8DPP9F_.DBF

F:\APP\ADMINISTRATOR\ORADATA\ORCL\DATAFILE\O1_MF_U	2	5	3
SERS_CC8DWJ4X_.DBF

F:\APP\ADMINISTRATOR\ORADATA\ORCL\DATAFILE\O1_MF_U	87	645	558
NDOTBS1_CC8DWKLJ_.DBF

F:\APP\ADMINISTRATOR\ORADATA\ORCL\DATAFILE\O1_MF_S	1,150	1,210	60
YSAUX_CC8DKTH7_.DBF

	--------
sum	640

4 rows selected.

CMD

---------------------------------------------------------------------------

alter database datafile

'F:\APP\ADMINISTRATOR\ORADATA\ORCL\DATAFILE\O1_MF_SYSTEM_CC8DPP9F_.DBF'

resize 16001m;

alter database datafile
'F:\APP\ADMINISTRATOR\ORADATA\ORCL\DATAFILE\O1_MF_USERS_CC8DWJ4X_.DBF'
resize 2m;

alter database datafile

'F:\APP\ADMINISTRATOR\ORADATA\ORCL\DATAFILE\O1_MF_UNDOTBS1_CC8DWKLJ_.DBF'

resize 87m;

alter database datafile

'F:\APP\ADMINISTRATOR\ORADATA\ORCL\DATAFILE\O1_MF_SYSAUX_CC8DKTH7_.DBF'

resize 1150m;

4 rows selected.

should i run the above statements? what would be the effect of it? this is my production server.

i am afraid if any data loss would occur in the result of running the above alter statements. please guide me.

Regards.

This post has been answered by Maahjoor on May 30 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 27 2016

Added on May 29 2016

#general-database-discussions

16 comments

481 views