CODEWITHSUNDEEP
shelloracle11gmonitoring
Sai Ye Yan Naing Aye
Sai Ye Yan Naing Aye

Reputation: 6738

Can I collect oracle database 11g R2 information using shell script?

I want to develop database monitoring tool. In my development, I want to use shell script to collect database information (e.g hit rate of SGA,Session,Lock,etc.). But I'm a newbie of shell script and oracle database.I used oracle database 11g R2 enterprise edition. Can I collect oracle database 11g R2 information using shell script? Can anybody share me some ideas and references.

Upvotes: 0

Views: 653

Answers (1)

user330315
user330315

Reputation:

Yes, that's possible.

You need to put together a bunch of SQL statements that query the relevant system views (V$...).

The from within the shell script you call sqlplus and spool the output of the statements to a text file.

Upvotes: 1

Related Questions