Home » RDBMS Server » Server Administration » Tablespace usages (ORacle 10g Release 2 with patch set 3, AIX)
Tablespace usages [message #416091] Thu, 30 July 2009 07:40 Go to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Hi M

Can you help me to get the usages of tablespace considering the maxbytes value of DBA_DATA_FILES.

Then i am looking for alert mail if tablespace going to reach it's maxsize values. I have one tablespace have 10 datafile with following condition.

1. Data file autoextend on with max size 5g
2. Data file auoextend off but max size 5g
3. Data file autoextend off with max size 0


Regards,
Mittal

Report message to a moderator

Re: Tablespace usages [message #416096 is a reply to message #416091] Thu, 30 July 2009 07:48 Go to previous message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Not clear.
Explain your question.
Give examples.

Regards
Michel

Report message to a moderator

Previous Topic: Shared Pool Size More Than Expected
Next Topic: How to know which query runs many times
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 04:16:59 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.