OraFAQ Forum: Server Administration » Oracle10g too slow in Sun solaris, using memory of Oracle, prstat -t

Home » RDBMS Server » Server Administration » Oracle10g too slow in Sun solaris, using memory of Oracle, prstat -t

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle10g too slow in Sun solaris, using memory of Oracle, prstat -t [message #178703]

Thu, 22 June 2006 04:26

voca79
Messages: 4
Registered: June 2006
Location: VietNam

Junior Member

I'm runing Oracle10g on sun solaris 9 for many users, i have a problem. If about 100 users using is not problem. but about 500 users connect to Oracle database is too slow and cannot connect to database.
I use "prstat -t" command in solaris, I see results:

NPROC USERNAME SIZE RSS MEMORY TIME CPU
45 root 307M 135M 1.1% 0:00:43 1.5%
63 oracle 15G 12G 98% 0:00:13 0.2%
10 nobody 308M 55M 0.4% 0:00:00 0.0%
1 daemon 2480K 1760K 0.0% 0:00:00 0.0%

Oracle process used almost memory, and I don't know how to solve this problem yet.

would anyone help me?
Thanks a lot.
Voca

Report message to a moderator

Re: Oracle10g too slow in Sun solaris, using memory of Oracle, prstat -t [message #178706 is a reply to message #178703]

Thu, 22 June 2006 04:33

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Down-tune your database parameters. Especially parameters like SGA_TARGET, PGA_AGGREGATE_TARGET, DB_CACHE_SIZE, *_POOL_SIZE, etc.

Report message to a moderator

Re: Oracle10g too slow in Sun solaris, using memory of Oracle, prstat -t [message #178824 is a reply to message #178706]

Thu, 22 June 2006 23:50

voca79
Messages: 4
Registered: June 2006
Location: VietNam

Junior Member

Thanks for Frank Naude' answer,
I already checked SGA, PGA memory, and set them about 45% RAM memory (4G).

But it still too slow. Do you/anyone have any way?

Many thanks.

Voca.

Report message to a moderator

Re: Oracle10g too slow in Sun solaris, using memory of Oracle, prstat -t [message #179008 is a reply to message #178703]

Fri, 23 June 2006 21:05

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

In ANY computer system, the 4 best/worst possible bottlenecks are
1) CPU
2) RAM
3) DISK
4) Network

Each of these require a different metric to know if they in saturation to the point of being overloaded.
Hire a decent Unix SA to assist with identifying which of these is the problem for your situation.

Report message to a moderator

Re: Oracle10g too slow in Sun solaris, using memory of Oracle, prstat -t [message #179124 is a reply to message #178824]

Sun, 25 June 2006 22:00

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

voca79 wrote on Thu, 22 June 2006 23:50

Thanks for Frank Naude' answer,
I already checked SGA, PGA memory, and set them about 45% RAM memory (4G).

How exactly have you already checked this? What is your sga_target? pga_aggregate_target? Total RAM on the server? Are you using sga and pga targets or are you manually setting specific parameters? Give us some more details.

Wait..is that 4G total RAM on the server, but you are telling Oracle to use 12 or 15 GB? Why would you tell oracle to use 4 times the RAM on your machine?

Report message to a moderator

Re: Oracle10g too slow in Sun solaris, using memory of Oracle, prstat -t [message #179156 is a reply to message #179124]

Mon, 26 June 2006 02:19

voca79
Messages: 4
Registered: June 2006
Location: VietNam

Junior Member

Hi Frank Naude,

I configured SGA memory a bout 45% of RAM (about 1,3GB).
But when i use prstat -t command in Sun Solaris, i see RSS memory about 12 to 15GB. What is RSS memory ? Is it affect to the rate processing of database?

Thanks.
Vo.

Report message to a moderator

Previous Topic:	only sys
Next Topic:	PLS-00123

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:31:21 CDT 2024