Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> was (RE: SGADEF file?) is How to best detect database health

was (RE: SGADEF file?) is How to best detect database health

From: Kevin Closson <kevinc_at_polyserve.com>
Date: Tue, 29 Aug 2006 10:13:25 -0700
Message-ID: <5D2570CAFC98974F9B6A759D1C74BAD0E5AE4D@ex2.ms.polyserve.com>

          

        I will agree with Mr. Bobak. Connect to test that the database is not only started but is accessible to a non-privileged username.

...this is a great thread, but it has moved more into database health than "is the instance up", which was the initial thread. So let me ask, is connecting as a non-priveledged user really good enough? So you get a session. Are the datafiles online? Can you parse a SQL statement? etc ?

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 29 2006 - 12:13:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US