OraFAQ Forum: Performance Tuning » How to tune memory size in oracle 8i (merged)

Home » RDBMS Server » Performance Tuning » How to tune memory size in oracle 8i (merged)

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

How to tune memory size in oracle 8i (merged) [message #407860]

Fri, 12 June 2009 01:00

sanjay6713
Messages: 40
Registered: June 2009
Location: INDIA

Member

NPROC USERNAME SIZE RSS MEMORY TIME CPU
57 oracle8i 4698M 4185M 98% 0:03.20 0.1%

I want to reduce memory size in the above column,
And how to kill the below job process .After killing the pid's also...its coming up again,,
please help me out,,

bash-2.03$ ps -ef|grep ora_snp
oracle8i 7299 1 0 11:08:09 ? 0:00 ora_snp2_
oracle8i 7297 1 0 11:08:09 ? 0:00 ora_snp1_
oracle8i 7283 1 0 11:07:04 ? 0:00 ora_snp0_
oracle8i 7301 1 0 11:08:09 ? 0:00 ora_snp3_

Thanks in Adv.

Report message to a moderator

Re: How to tune memory size in oracle [message #407863 is a reply to message #407860]

Fri, 12 June 2009 01:14

brillix
Messages: 6
Registered: June 2009

Junior Member

What you are trying to do, why you are killing oracle precesses
Be more specific

Report message to a moderator

Re: How to tune memory size in oracle [message #407866 is a reply to message #407860]

Fri, 12 June 2009 01:19

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1/ Reduce SGA
2/ Reduce job_queue_processes value
But why do you want to kill these processes?

I think you should read
Database Concepts
Database Administrator's Guide or at least 2 Day DBA

I hope you are not managing production. I suggest you to follow Oracle course or hire a DBA, you do handle Oracle processes at OS level.

Regards
Michel

[Updated on: Fri, 12 June 2009 01:19]

Report message to a moderator

Re: How to tune memory size in oracle [message #407867 is a reply to message #407863]

Fri, 12 June 2009 01:21

sanjay6713
Messages: 40
Registered: June 2009
Location: INDIA

Member

thank you for response. Firstly.I want to reduce the memory utilization by oracle processes it has reached now to 98%.

Second thing is i had dout on job queue processes for consumning more memory, and wnated to kill them but waz unable to do.

Report message to a moderator

Re: How to tune memory size in oracle [message #407869 is a reply to message #407867]

Fri, 12 June 2009 01:30

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Job processes do not consume (about) anything but when they are executing a job. If you want to reduce their number do as I said.

Regards
Michel

Report message to a moderator

Re: How to tune memory size in oracle [message #407870 is a reply to message #407866]

Fri, 12 June 2009 01:32

sanjay6713
Messages: 40
Registered: June 2009
Location: INDIA

Member

thank you for the advice.I m done wit DBA crse as i m new to Oracle and also handling production, i m pretty much confident to handle the other DB issues.
I request 2 guide few major issues like tuning and recovery.

Report message to a moderator

Re: How to tune memory size in oracle [message #407871 is a reply to message #407870]

Fri, 12 June 2009 01:41

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

I request 2 guide few major issues like tuning and recovery.

Database Performance Tuning Guide but of course OraFAQ Performance Tuning and Tuning High-Volume SQL Wiki page are good reading.
Database Backup and Recovery Basics for the first steps.

Regards
Michel

Report message to a moderator

Re: How to tune memory size in oracle [message #407872 is a reply to message #407871]

Fri, 12 June 2009 01:48

sanjay6713
Messages: 40
Registered: June 2009
Location: INDIA

Member

Thanks a lot for the valueable advice and reference links.

My present priority is to reduce the memory size that it has consumed.
when i give the command prstat -a, i get the foll. o/p

NPROC USERNAME SIZE RSS MEMORY TIME CPU
56 oracle8i 4470M 3979M 98% 0:03.50 0.8%
36 root 199M 71M 1.7% 0:02.00 0.0%
1 daemon 2084K 108K 0.0% 0:00.00 0.0%

Here how to reduce the memory contention and how to chk whr is the root cause,,,!!!

Report message to a moderator

How to tune memory size in oracle 8i [message #407873 is a reply to message #407860]

Fri, 12 June 2009 02:28

sanjay6713
Messages: 40
Registered: June 2009
Location: INDIA

Member

I wanted to know whts the root causes for the memory consumptions,,in oracle8i

When i give the cmd $prstat -a, i get the foll. o/p

NPROC USERNAME SIZE RSS MEMORY TIME CPU
60 oracle8i 4937M 4398M 98% 0:03.34 0.2%
37 root 201M 72M 1.6% 0:02.00 0.1%
1 daemon 2084K 108K 0.0% 0:00.00 0.0%

In the above u can see the memory is reaching 98% for oracle8i user. how to tune it.!!!

For More Info, foll.is my current status.

************************************************************
bash-2.03$ /usr/bin/prstat -s size -n 5 1 1
PID USERNAME SIZE RSS STATE PRI NICE TIME CPU PROCESS/NLWP
7158 oracle8i 231M 210M sleep 59 0 0:00.00 0.0% oracle/14
6373 oracle8i 230M 206M sleep 59 0 0:00.00 0.0% oracle/18
6375 oracle8i 230M 205M sleep 59 0 0:00.00 0.0% oracle/14
6377 oracle8i 230M 205M sleep 58 0 0:00.03 0.0% oracle/14
6371 oracle8i 229M 205M sleep 58 0 0:00.00 0.0% oracle/4
Total: 95 processes, 315 lwps, load averages: 0.00, 0.01, 0.02

bash-2.03$ ptree 7158
189 /usr/sbin/inetd -s
7128 in.telnetd
7130 -sh
7135 bash
7157 sqlplus
7158 oraclekesd (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

bash-2.03$ ptree 6373
6373 ora_dbw0_kesd

bash-2.03$ ptree 6375
6375 ora_lgwr_kesd

bash-2.03$ ptree 6377
6377 ora_ckpt_kesd

bash-2.03$ ptree 6371
6371 ora_pmon_kesd

bash-2.03$

*************************************************

I m not sure y the RSS column in the above is taking so much size.
Please help in tracking and resolving it.

Thanks in Adv.

Report message to a moderator

Re: How to tune memory size in oracle 8i [message #407874 is a reply to message #407873]

Fri, 12 June 2009 02:42

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Do not crosspost and repeat your topic.
It is useless (as they will be merged) and counterproductive (as the time I spend managing your post, I don't spend it posting useful answer).

Regards
Michel

Report message to a moderator

Re: How to tune memory size in oracle 8i [message #407876 is a reply to message #407873]

Fri, 12 June 2009 02:46

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

As I said:

Quote:

1/ Reduce SGA

Oracle use shared memory, this one is attached in every Oracle process and so you have it in every Oracle process but it is one.
Actual Oracle process size is (about) SIZE-RSS.

Regards
Michel

Report message to a moderator

Re: How to tune memory size in oracle 8i [message #407885 is a reply to message #407876]

Fri, 12 June 2009 03:53

sanjay6713
Messages: 40
Registered: June 2009
Location: INDIA

Member

Thanks for Info, but thing is we are not using the SGA parameter.
instead we are using only the below parameters,,

****************************
db_block_size = 8192
log_buffer = 163840
shared_pool_size = 60227737
db_block_buffers = 14731

********************************

Report message to a moderator

Re: How to tune memory size in oracle 8i [message #407899 is a reply to message #407885]

Fri, 12 June 2009 04:38

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes, you use them (and you post them), you need to read the links I posted you, managing Oracle is not shooting in the dark.

Regards
Michel

Report message to a moderator

Previous Topic:	Dynamic_sampling and partitioning
Next Topic:	HINT INDEX Usage

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 16:22:05 CST 2024