Re: Connect time one more Architecture Problem

Respected DBAs,

Thank for Your response.
Actually that was the question ask in my interview, I told them that we could check listener.log and it might also be possible that there were already so many clients were connected to oracle database so listener had lot of load. They said OK but then they asked what if there was something wrong with architecture here and dba should check architecture. But what and how, that was their question......... architecture problem means any problem in processes........... but what should a dba can do if there is any problem with processes like if any process is not working properly. Is there any manual for

that..............................

joel garry wrote:
> peter wrote:
> > Respected DBAs,
> >
> > I asked that before and I am asking this again that if user( any user
> > whether on client or server ) is taking more time to connect to
> > database on my network nearly 10 min., where my network is working
> > fine, there is some problem in architecture of Oracle 9i.What should a
> > DBA can do in this situation.Pls help..................................
>
> How is the user connecting? A particular tool? You are saying that
> on the server where the database is, using sqlplus, everyone is taking
> 10 minutes to connect? And then they are running fine?
>
> Are there big .dat files in $ORACLE_HOME/otrace/admin? Are there
> errors in your alert log?
>
> jg
> --
> @home.com is bogus.
> Life itself is a loan.
Received on Wed Jun 07 2006 - 04:40:36 CDT