OraFAQ Forum: Performance Tuning » scripts on tablespaces,Indexes and DBJobs

Home » RDBMS Server » Performance Tuning » scripts on tablespaces,Indexes and DBJobs (linux 4.0 with oracle 10g)

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

scripts on tablespaces,Indexes and DBJobs [message #539976]

Thu, 19 January 2012 10:22

faiz123
Messages: 4
Registered: January 2012
Location: Hyderabad,India

Junior Member

Hi all,

I am new to orafaq forum.

I am working in a small org with the db size of 75GB.
I would appreciate if someone can answer the following questions for me...

I am looking for scripts that can send alerts for the following

We have Autoextend on enabled on all the datafiles.

1)Tablespace- monitoring script to see all the datafiles in the tablespaces are below 10GB

2)Indexes Verify if any indexes are broken and corrupted

3)DB Jobs Verify to see if any DB Jobs are running longer than 30 min

Thanks in Advance.

Faiz.

Report message to a moderator

Re: scripts on tablespaces,Indexes and DBJobs [message #539985 is a reply to message #539976]

Thu, 19 January 2012 10:33

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Welcome to the forum.
We will help you but we will NOT do your job.
Post what you tried and where you are stuck and we will help you to go further.

Oracle dictionary views are described in Database Reference.
You can quickly find the purpose of view or search for some dictionary views using the DICT view itself.
For instance, to know where free space is recorded you can use:

SQL> col comments format a50 word_wrap
SQL> select * from dict where lower(comments) like '%free%space%';
TABLE_NAME                     COMMENTS
------------------------------ --------------------------------------------------
USER_FREE_SPACE                Free extents in tablespaces accessible to the user
DBA_FREE_SPACE                 Free extents in all tablespaces
DBA_LMT_FREE_SPACE             Free extents in all locally managed tablespaces
DBA_DMT_FREE_SPACE             Free extents in all dictionary managed tablespaces

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel

Report message to a moderator

Re: scripts on tablespaces,Indexes and DBJobs [message #539986 is a reply to message #539976]

Thu, 19 January 2012 10:34

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I am sorry to see that you are unwilling or incapable of using SEARCH or GOOGLE

http://www.orafaq.com/wiki/Scripts

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: scripts on tablespaces,Indexes and DBJobs [message #541165 is a reply to message #539986]

Sun, 29 January 2012 00:39

faiz123
Messages: 4
Registered: January 2012
Location: Hyderabad,India

Junior Member

Thanks Micheal..Got it...

Report message to a moderator

Re: scripts on tablespaces,Indexes and DBJobs [message #541175 is a reply to message #539976]

Sun, 29 January 2012 02:53

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

Senior Member

Quote:

I am looking for scripts that can send alerts for the following

Have you looked at the alert system? There are pre-configured alerts for many conditions, listed in the v$alert_types view. Enable them by setting thresholds with the dbms_server_alert package.If you have Enterprise Edition licences, you can automate notifications by email with OEM, on Standard Edition you have to write your own alert handler (not so difficult.)

Report message to a moderator

Previous Topic:	Subquery Transformation
Next Topic:	Performance tuning in View

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 25 10:47:46 CST 2025