Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

db sanity check

470229Apr 2 2006 — edited Apr 2 2006

Hi All,

I would like to develop sanity check script for our product Oracle Db.
It should be put on crontab, worked periodically.
How can I retrieve simple pl/sql query(for example how many connections and user..) elapsed time?. Is it possible to achieve this goal by using UNIX scripts(perl, bash etc..) and specific pl/sql statement or have I write to application with java or C?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 30 2006

Added on Apr 2 2006

#general-database-discussions

1 comment

408 views