FAQ
Hi Bala,

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.

HTH,

Andrey Goryunov

2008/9/22 Bala
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
appreciated.

Unix -- HP Unix 11.31/ 10.2.0.4

--
Bala Rao
--
Regards,
Andrey Goryunov

--
http://www.freelists.org/webpage/oracle-l

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 6 of 6 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedSep 22, '08 at 1:55p
activeOct 7, '08 at 12:35p
posts6
users6
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase