Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Slow sqlplus connection

Re: Slow sqlplus connection

From: Stefan Knecht <>
Date: Sun, 8 Jul 2007 12:27:02 +0200
Message-ID: <>

Running a truss on the sqlplus process might provide some further insight what it's being waited on. Just remember to trace accross forks (using -f ).


On 7/3/07, Graham Ross <> wrote:
> All,
> I currently have a strange problem and I wonder if anyone on the list has
> seen this.
> We currently have a RAC database ( running on an AIX 5.3server. I backed up the database using RMAN to TSM, and from this backup
> wanted to build a copy of the live database on an alternate server. There
> were some problems involved in this in that a) there already existed a
> database on the server with the same name and dbid of the live system (I
> inherited this), and b) there was no connection between the live and the
> test servers.
> I shut down the existing copy of live, and moved all the files out of
> harms way, and then restored and recovered the backup converting it to a
> single instance, (the other copy is a full RAC copy). So far so good. I
> then changed the name and dbid using nid and brought the database up. It
> came up successfully, but now connecting the database via sqlplus was taking
> exactly 75 seconds. While it all worked fine after that, it is annoying
> and having an adverse impact on our testing. Changing the tcp_keepinit
> kernel parameter from 150 to 20 took the connection time from 75 to 10
> seconds. This is better, but still not a fix.
> I can't help thinking that there is some process trying to start and
> failing, and I can't for the life of me think of what it could be. I
> expect it's something blindingly obvious, but I'd be delighted to hear any
> suggestions.
> Thanks in advance,
> graham
> ___________________________________________________________
> Yahoo! Answers - Got a question? Someone out there knows the answer. Try
> it
> now.
> --


Stefan P Knecht
Infrastructure Managed Services

Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg

Phone +41-44-808 70 20
Fax +41-808 70 12
Mobile +41-79-571 36 27


Received on Sun Jul 08 2007 - 05:27:02 CDT

Original text of this message