Home » RDBMS Server » Performance Tuning » scripts on tablespaces,Indexes and DBJobs (linux 4.0 with oracle 10g)
scripts on tablespaces,Indexes and DBJobs [message #539976] Thu, 19 January 2012 10:22 Go to next message
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.
Re: scripts on tablespaces,Indexes and DBJobs [message #539985 is a reply to message #539976] Thu, 19 January 2012 10:33 Go to previous messageGo to next message
Michel Cadot
Messages: 59993
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: scripts on tablespaces,Indexes and DBJobs [message #539986 is a reply to message #539976] Thu, 19 January 2012 10:34 Go to previous messageGo to next message
BlackSwan
Messages: 23150
Registered: January 2009
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/
Re: scripts on tablespaces,Indexes and DBJobs [message #541165 is a reply to message #539986] Sun, 29 January 2012 00:39 Go to previous messageGo to next message
faiz123
Messages: 4
Registered: January 2012
Location: Hyderabad,India
Junior Member

Thanks Micheal..Got it...
Re: scripts on tablespaces,Indexes and DBJobs [message #541175 is a reply to message #539976] Sun, 29 January 2012 02:53 Go to previous message
John Watson
Messages: 4859
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.)
Previous Topic: Subquery Transformation
Next Topic: Performance tuning in View
Goto Forum:
  


Current Time: Fri Dec 19 21:59:29 CST 2014

Total time taken to generate the page: 0.13519 seconds