Re: delay starting sqlplus in 8.1.6

Matt,

Does HP-UX have the equivilant of 'truss' on Solaris or strace on Linux, and does the script connect to a dedicated server process?

If so, use truss on the shadow process to find out what the session is actually doing.

This is assuming you have already checked v$session_wait to see what the session may be waiting on.

Jared

On Fri, 19 May 2000, Adams, Matthew (GEA, 088130) wrote:

> As part of our monitoring system, we have a
> script that runs sqlplus, selects * from v$bgprocess,
> and then exits. This lets us know oracle is available.
>
> Now that we have started running 8.1.6, we have noticed
> that after the database has been up and running for a few
> hours, occasionally, it takes 5 minutes or more for this
> script to accomplish its task. It doesn't happen every time,
> just often enough to be really annoying.
>
> The OS is hp-ux 11 (N-Class & L-class machines).
>
> Has anybody seen similar behavior with 8.1.6?
> Seen a solution?
>
> ----
> R. Matt Adams GE Appliances
> It is now safe to switch your computer off.
>
> --
> Author: Adams, Matthew (GEA, 088130)
> INET: MATT.ADAMS_at_APPL.GE.COM
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;) jkstill_at_teleport.com Received on Sat May 20 2000 - 14:37:39 CDT