Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: DATABASE SLOW

RE: DATABASE SLOW

From: H elp_me <good_dba_at_hotmail.com>
Date: Wed, 28 Apr 2004 16:51:28 +0000
Message-ID: <BAY14-F13rU1YImWd1G00031274@hotmail.com>

 

Hello Seema,

Are you trying to connect over the network or locally on that box ?

Did you check for network collisions ?

Nikunj

  >From: "Seema Singh" <oracledbam_at_hotmail.com> >Reply-To: oracle-l_at_freelists.org >To: oracle-l_at_freelists.org >Subject: DATABASE SLOW
>Date: Wed, 28 Apr 2004 11:37:00 -0400 >>Hi, >I have one instance on SUN
box.># of users connecting to box =max 25 >Oracle version =8.1.7.0.0 >Sytem rebooted yesterday. >When I am trying to connect sqlplus internal,its taking longer >time.Yesterday after reboot system was performing very good.Nothing change >after that. >System ideal =99% >Memory only available =46mb (total mem-1.5gb) >>database stats shows fine except buffer hit ratio. >>Wondering why connect time is very very slow. >ANy thought?
>>_________________________________________________________________ >Get rid
of annoying pop-up ads with the new MSN Toolbar FREE!
>http://toolbar.msn.com/go/onm00200414ave/direct/01/
>>---------------------------------------------------------------- >Please
see the official ORACLE-L FAQ: http://www.orafaq.com
>---------------------------------------------------------------- >To
unsubscribe send email to: oracle-l-request_at_freelists.org >put 'unsubscribe'in the subject line. >-- >Archives are at http://www.freelists.org/archives/oracle-l/ >FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------



MSN Toolbar provides one-click access to Hotmail from any Web page FREE download![1] Received on Wed Apr 28 2004 - 11:55:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US