Home » RDBMS Server » Performance Tuning » How to tune memory size in oracle 8i (merged)
How to tune memory size in oracle 8i (merged) [message #407860] Fri, 12 June 2009 01:00 Go to next message
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.
Re: How to tune memory size in oracle [message #407863 is a reply to message #407860] Fri, 12 June 2009 01:14 Go to previous messageGo to next message
brillix
Messages: 6
Registered: June 2009
Junior Member
What you are trying to do, why you are killing oracle precesses
Be more specific
Re: How to tune memory size in oracle [message #407866 is a reply to message #407860] Fri, 12 June 2009 01:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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.



Re: How to tune memory size in oracle [message #407869 is a reply to message #407867] Fri, 12 June 2009 01:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: How to tune memory size in oracle [message #407870 is a reply to message #407866] Fri, 12 June 2009 01:32 Go to previous messageGo to next message
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.
Re: How to tune memory size in oracle [message #407871 is a reply to message #407870] Fri, 12 June 2009 01:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I request 2 guide few major issues like tuning and recovery.


Regards
Michel
Re: How to tune memory size in oracle [message #407872 is a reply to message #407871] Fri, 12 June 2009 01:48 Go to previous messageGo to next message
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,,,!!!



How to tune memory size in oracle 8i [message #407873 is a reply to message #407860] Fri, 12 June 2009 02:28 Go to previous messageGo to next message
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.

Re: How to tune memory size in oracle 8i [message #407874 is a reply to message #407873] Fri, 12 June 2009 02:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: How to tune memory size in oracle 8i [message #407876 is a reply to message #407873] Fri, 12 June 2009 02:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: How to tune memory size in oracle 8i [message #407885 is a reply to message #407876] Fri, 12 June 2009 03:53 Go to previous messageGo to next message
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

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

Re: How to tune memory size in oracle 8i [message #407899 is a reply to message #407885] Fri, 12 June 2009 04:38 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Dynamic_sampling and partitioning
Next Topic: HINT INDEX Usage
Goto Forum:
  


Current Time: Thu Dec 08 00:24:11 CST 2016

Total time taken to generate the page: 0.23096 seconds