OraFAQ Forum: Server Administration » USERS tablespace is filling fast

Home » RDBMS Server » Server Administration » USERS tablespace is filling fast (oracle 11 g r2 RAC of 2 nodes, solaris 10 and ASM)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

USERS tablespace is filling fast [message #679415]

Fri, 28 February 2020 03:51

janakors
Messages: 230
Registered: September 2009

Senior Member

hi There

my USers tablespace is filling very fast and last day it has consumed 30G of data.i havn't created this database and my EM is also not working now at SQL prompt how can i check that what is going on in this tablespace ? so how can i check what is filling my data

Regards

Report message to a moderator

Re: USERS tablespace is filling fast [message #679417 is a reply to message #679415]

Fri, 28 February 2020 04:01

John Watson
Messages: 8461
Registered: January 2010
Location: Global Village

Senior Member

You had better begin by querying a few views. These would be a good start:
dba_free_space
dba_tablespace_usage_metrics
dba_segments

Report message to a moderator

Re: USERS tablespace is filling fast [message #679421 is a reply to message #679417]

Fri, 28 February 2020 04:39

janakors
Messages: 230
Registered: September 2009

Senior Member

Thank u John but when i try to run query i get error "

ORA-01000: Maximum open curosr exceeded

Report message to a moderator

Re: USERS tablespace is filling fast [message #679430 is a reply to message #679421]

Fri, 28 February 2020 05:33

cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester

Senior Member

Something is running in the background and chewing up all the resources.
Try restarting the DB.
If that doesn't work try starting in restricted mode: startup restrict;

Report message to a moderator

Previous Topic:	Oracle Server 11g times out after only a few min online
Next Topic:	Calculating the size of the depending on the AUTOEXTENSIBALE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 27 07:38:25 CST 2021