Re: Long Time connecting to Database
Date: Tue, 7 Oct 2008 23:35:19 +1100
I had the same issue on AIX when several databases were placed on a server using LOCK_SGA and PRE_PAGE_SGA set to true and total SGA size was almost the same amount of memory allocated for server unit. With high activity of databases every connection even under sysdba was causing enormous paging and long time of connection.
2008/9/22 Bala <oratips_at_gmail.com>
> Connecting to 10g Database from -- sqlplus/front end application/ or
> locally as sysdba -- is taking a very long time -- upto 8 mts.
> How do i troubleshoot this issue ? Any help or insight is highly
> Unix -- HP Unix 11.31/ 10.2.0.4
> Bala Rao
-- Regards, Andrey Goryunov -- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 07 2008 - 07:35:19 CDT