Oracle Instance health

From: Eric <eric.ross.c_at_gmail.com>
Date: Mon, 20 Aug 2007 14:35:54 -0700
Message-ID: <1187645754.469359.164220@k79g2000hse.googlegroups.com>

Hello there

I'm trying to figure out how to test if an Oracle instance is healthy. I mean, if it will respond to some basic query.

If I execute one query in one of the schemas in the instance, can I be sure that the others schemas are in good shape? Or I need to test explicitly every schema (One connection to each one and one query in every conection?)

BTW, what kind of basic query can I execute to test the instance (or schema)? Something that is quick enough to not stress the data base, but good enough to be sure that the instance is running.

Well, if someone has another idea of how to test (remotely) an Oracle instance I'll appreciate the info.

Thanks in advance.
Eric Received on Mon Aug 20 2007 - 16:35:54 CDT