Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Sun Apr 21, 2019 9:26 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 37 posts ]  Go to page 1, 2, 3  Next
Author Message
 Post subject: Monitoring Oracle
PostPosted: Thu May 12, 2005 8:22 am 
Offline
User avatar

Joined: Fri Mar 18, 2005 12:55 pm
Posts: 18
Location: Paris/France
Hi,

Here are the first XML Files I made to monitor our Oracle Server (8.1.7.2 under Solaris).

To be able to use those template you will have to have the following agent working on the Oracle server :

- Oracle peer Master agent
- Oracle peer encapsulator
- An standard snmp agent, net-snmp for instance.

(I might post a procedure if someone is interested)


The list of template is the following :

The first two of them are based on the infos found here :
http://www-rohan.sdsu.edu/doc/oracle/server803/A53704_01/ch3.htm

* cacti_graph_template_application_oracle_physical_access.xml
This template gives the physical access (block/sec read and write) for each database. This is an overview of the I/O activity of the database. This is not an absolute measurement because of possible OS disk cache.

(see graph 1)

* cacti_graph_template_application_oracle_cache_hit_ratio.xml
This template gives the cache hit ratio for each database. No need to explain this one, on our server it is always above 95% because of the large amount of RAM.

(see graph 2)

* cacti_graph_template_application_oracle_filetable_tablespace_size.xml
This template gives for each TableSpace of each Database, the space used/space allocated in octets. Useful to see if the space allocated is still enough.

(see graph3)

* cacti_graph_template_application_oracle_file_table_physical_access.xml
This template gives for each File (.dbf) of each Database, the block read/sec and block write/sec. This could be useful to optimize the location of files accross the different file systems.

(see graph4)

After you import the templates, you will have 3 more Data queries available for your host :


SNMP - ORACLE - DbSysTable : For graph 1 and 2 (this query gathers infos about the Databases)

SNMP - ORACLE- TableSpace : For graph 3 (this query gathers infos about the tablespaces of the Databases)

SNMP - ORACLE - DbDataFileTable : For the Graph 4 (this query will gather infos about the dbf files)


I am still working on other monitors I will post later on.
I think those informations could still be relevant to other version of Oracle server, but the OID may (or not, I didn't check) have changed.


Feedback appreciated.


Olivier


Attachments:
File comment: graph 3 - TableSpace used vs allocated
graph3 - TableSpace size used vs allocated.JPG
graph3 - TableSpace size used vs allocated.JPG [ 40.19 KiB | Viewed 87988 times ]
File comment: graph 2 - Database Cache Hit Ratio (%)
graph2 - Database Cache Hit Ratio.JPG
graph2 - Database Cache Hit Ratio.JPG [ 62.27 KiB | Viewed 87988 times ]
File comment: graph 1 - Database Physical Accesses (Block/sec)
graph1 - Database Physical Accesses.JPG
graph1 - Database Physical Accesses.JPG [ 75.45 KiB | Viewed 87988 times ]


Last edited by o_dupuis on Thu May 12, 2005 8:23 am, edited 1 time in total.
Top
 Profile  
 
 Post subject: The last graph
PostPosted: Thu May 12, 2005 8:23 am 
Offline
User avatar

Joined: Fri Mar 18, 2005 12:55 pm
Posts: 18
Location: Paris/France
Here is the graph 4.


Attachments:
File comment: graph 4 - dbf File Block accesses (read/write)
graph4 - dbf_File_Block_Accesses.JPG
graph4 - dbf_File_Block_Accesses.JPG [ 73.72 KiB | Viewed 87990 times ]
Top
 Profile  
 
 Post subject:
PostPosted: Thu May 12, 2005 10:40 am 
Offline
Cacti Guru User
User avatar

Joined: Fri Sep 19, 2003 8:36 am
Posts: 2326
Location: Sophia-Antipolis, France
Thanks for the templates :D

Some how-to have been posted here in the past : http://forums.cacti.net/viewtopic.php?t=829 and http://forums.cacti.net/viewtopic.php?t=6209

_________________

HOWTOs :
Templates :


Top
 Profile  
 
 Post subject: ?
PostPosted: Fri May 13, 2005 4:25 am 
Offline

Joined: Thu May 12, 2005 9:14 am
Posts: 8
i can't see any templates to download.... :)
only jpg files

where i can download them?

best regards


Top
 Profile  
 
 Post subject: Templates
PostPosted: Fri May 13, 2005 8:49 am 
Offline
User avatar

Joined: Fri Mar 18, 2005 12:55 pm
Posts: 18
Location: Paris/France
Oops, I forgot the most important, silly me...


Attachments:
File comment: This template gives for each TableSpace of each Database, the space used/space allocated in octets.
cacti_graph_template_application_oracle_filetable_tablespace_size.xml [16.57 KiB]
Downloaded 6157 times
File comment: This template gives the cache hit ratio for each database
cacti_graph_template_application_oracle_cache_hit_ratio.xml [21.05 KiB]
Downloaded 4115 times
File comment: This template gives the physical access (block/sec read and write) for each database
cacti_graph_template_application_oracle_physical_access.xml [20.81 KiB]
Downloaded 4418 times
Top
 Profile  
 
 Post subject: And last but not least
PostPosted: Fri May 13, 2005 8:50 am 
Offline
User avatar

Joined: Fri Mar 18, 2005 12:55 pm
Posts: 18
Location: Paris/France
The last template.

Thanks Suzumushi


Attachments:
File comment: This template gives for each File (.dbf) of each Database, the block read/sec and block write/sec
cacti_graph_template_application_oracle_file_table_physical_access.xml [13.32 KiB]
Downloaded 3981 times
Top
 Profile  
 
 Post subject:
PostPosted: Wed May 18, 2005 4:40 am 
Offline

Joined: Wed May 18, 2005 4:36 am
Posts: 5
Location: PARIS / FRANCE
Hello,

Thank's for the template, but how can i fill Index Type and Index values ? Can you explain it ? :oops:

Pierre


Top
 Profile  
 
 Post subject:
PostPosted: Thu May 19, 2005 4:54 am 
Offline

Joined: Wed Jan 26, 2005 10:31 pm
Posts: 5
thank first.
today i try to import template of oracle xml files, there is no any error information , and i cannot see any template at cacti, In the other xml template case , i can import success,

would u give me a hand , or someone know why ? thank a lot , :o


Top
 Profile  
 
 Post subject:
PostPosted: Thu May 19, 2005 5:13 am 
Offline
User avatar

Joined: Fri Mar 18, 2005 12:55 pm
Posts: 18
Location: Paris/France
Hi,


doucetp :
Could you be a bit more precise about the problem you have with the index type and Index value, I can't figure out where you need to fill this (screenshot welcome ;) ).

kevinchang:
Could you tell me which template gives you trouble, it will be easier to help you.

Olivier


Top
 Profile  
 
 Post subject: Please, post Data queries
PostPosted: Thu May 19, 2005 5:31 am 
Offline

Joined: Sun May 01, 2005 5:50 am
Posts: 1
Hi!

Can you post de Data queries for Oracle templates¿¿

Thanks.
:lol:


Top
 Profile  
 
 Post subject: Thanks naska
PostPosted: Thu May 19, 2005 8:02 am 
Offline
User avatar

Joined: Fri Mar 18, 2005 12:55 pm
Posts: 18
Location: Paris/France
Yes, of course without the data queries, it won't work :D. Sorry I thought it was exported via the Export command.

Here they are :

1st :
oracle_DataFileTable.xml
associated with graph : Application - Oracle - File Table - Physical Access

2nd :
oracle_Table.xml
associated with graph :
Application - Oracle - Block Get Rate
Application - Oracle - Block Visit per transaction
Application - Oracle - Cache Hit Ratio
Application - Oracle - Physical Access
Application - Oracle - Redo Logs Wait Ratio

3rd :
oracle_TableSpaceTable.xml
associated with graph :
Application - Oracle - TableSpace Size



Sorry, it must have been confusing for people who tried to use the graph templates.


Attachments:
oracle_TableSpaceTable.xml [2.68 KiB]
Downloaded 4033 times
oracle_Table.xml [4.65 KiB]
Downloaded 3572 times
oracle_DataFileTable.xml [3.21 KiB]
Downloaded 3278 times
Top
 Profile  
 
 Post subject:
PostPosted: Thu May 19, 2005 8:32 am 
Offline

Joined: Wed Apr 20, 2005 9:07 am
Posts: 11
Location: France
I have any question with your template...

first, can you post the procedure you asked in your first post ? :roll:
installation of the oracle software, and configuration frighten me a little... :(

and are these template can run under windows???? :roll:


thanks in advance....

ProxyO


Top
 Profile  
 
 Post subject:
PostPosted: Thu May 19, 2005 9:01 am 
Offline
User avatar

Joined: Fri Mar 18, 2005 12:55 pm
Posts: 18
Location: Paris/France
Hi,

I have no time at the moment to make a procedure (sorry), the links fmangeant posted are very well documented :

http://forums.cacti.net/viewtopic.php?t=829
http://forums.cacti.net/viewtopic.php?t=6209

I think you will find all the infos to make oracle agent work.

About working under Win32, these templates are based on SNMP, not scripts run by the "cacti server" so it should work without problem.

Olivier


Top
 Profile  
 
 Post subject:
PostPosted: Fri May 20, 2005 2:22 am 
Offline

Joined: Wed May 18, 2005 4:36 am
Posts: 5
Location: PARIS / FRANCE
Thank's olivier,


Now with Data Queries, all info are being graphed except "Cache It Ratio".
I think something is missing for this graph .

Bye
Pierre


Attachments:
gkrellShoot_05-20-05_092514.jpg
gkrellShoot_05-20-05_092514.jpg [ 32.75 KiB | Viewed 87551 times ]
Top
 Profile  
 
 Post subject:
PostPosted: Fri May 20, 2005 4:38 am 
Offline
User avatar

Joined: Fri Mar 18, 2005 12:55 pm
Posts: 18
Location: Paris/France
Hi Pierre,

Do you use the Create->New Graph menu on the left handside of the screen ? If not, have a try. This Cache Hit Ratio template works exactly the same way the others do, so if you get "Application - Oracle - Block Get Rate", or "Application - Oracle - Physical Access" working, you 'should' also get the cache hit ratio.


Olivier


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 37 posts ]  Go to page 1, 2, 3  Next

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group