Home » Open Source » Programming Interfaces » How to Automate Daily Monitoring Excel sheet
How to Automate Daily Monitoring Excel sheet [message #456662] Wed, 19 May 2010 03:00 Go to next message
kiran_j
Messages: 7
Registered: April 2010
Location: Pune
Junior Member
Hi,

I am performing the daily monitoring of an oracle database.
for that i am running some queries for Actual Size(GB) of database,Number of Invalid Objects,Lib Cache hit ratio,Buf cache Hit ratio etc.

we have one excel sheet format so every day i am running these queries and copying the results into that excel sheet manually.

So can anybody tell me how to automate this.


Regards,
Kiran
Re: How to Automate Daily Monitoring Excel sheet [message #456665 is a reply to message #456662] Wed, 19 May 2010 03:43 Go to previous messageGo to next message
Michel Cadot
Messages: 66686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can access Oracle database from Excel using VBA and ODBC.
You can also create a macro that will execute each time you open the excel sheet and update all the fields.

Regards
Michel
Re: How to Automate Daily Monitoring Excel sheet [message #456669 is a reply to message #456665] Wed, 19 May 2010 03:52 Go to previous messageGo to next message
kiran_j
Messages: 7
Registered: April 2010
Location: Pune
Junior Member
Hi,

@Michal

Thanks for giving me hint.

but i am not very much familiar with macro.
can you please give me some good links where i can get how to start or write macros.

Regards,
Kiran
Re: How to Automate Daily Monitoring Excel sheet [message #456675 is a reply to message #456669] Wed, 19 May 2010 03:58 Go to previous message
Michel Cadot
Messages: 66686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think you will find many examples in Excel or VBA forums, see Microsoft site.

Regards
Michel
Previous Topic: Data provider internal error(-3000) [System.String]
Next Topic: ORA-28150 when I use proxy user by JDBC , but sqlplus not
Goto Forum:
  


Current Time: Fri Nov 15 20:41:06 CST 2019