Query Oracle 10g, record counts.

[adhillon]

Hi Everyone,

I am unable to figure out that how to connect to Oracle 10g db, and query the COUNT TSQL.
I would like to record the three COUNTs in one graph.

1. select count (*) from tbl_name; (ALL Count)
2. select count (*) from tbl_name where status = 'UP'; (UP Count)
3. select count (*) from tbl_name where status = 'DOWN'; (DOWN Count)

I am running windows version of Cacti 0.8.8b.

Please suggest.
Thank you.

[BSOD2600]

1) http://docs.cacti.net/
2) create a script which runs those queries and outputs the numbers in a format Cacti wants.
3) create the data templates, graphs, etc for the script.

[adhillon]

Could you share a sample script which connect to Oracle db, and run a simple query. I am not well versed with the scripting. That would be of great help.
Thank you.