which menu/command to set shared_pool_size

[manthana_c]

Dear Guru:

I am installing SAP ECC 6.0 on step 17 of 26 which is "IMPORT ABAP"

some error log eg. SAPAPPL_3.log and many log file has something like

"cannot allocated xxx bytes for shared memory (shared pool....)

so I have check in this forum to increase shared_pool but I not know how to do.

currenty I finished ORacle ISQL install but I not know the user to go to ISQLPlus.

is this the right way or other things to set for shard memory.

Pls advise.

thx in advance.

[former_member188883 · Accepted solution]

Hi,

Please share your server configuration like CPU cores , RAM .

Additionally how many parallel jobs have you configured for this installation.

Regards,

Deepak Kori

[manthana_c · Accepted solution]

Dear Deepak and Stefan:

I am installing SAP ECC 6.0 sr1 on Virtual Box.

OS = wins2003

base memory = 1376 mb

virtual memory = 2076 mb

oracle 10g with patch

that's all i know for now.

about BR tools is this in Oracle or some where?

Pls help again.

Edited by: Manthana99 on Nov 15, 2011 1:15 PM

Edited by: Manthana99 on Nov 15, 2011 1:16 PM

[Former Member · Accepted solution]

> 
> about BR tools is this in Oracle or some where?

Yes, Oracle. When you use 'oracle' with 'SAP', then SAP provides the tool BR*Tools to maintain Oracle.

In case of windows, you should be able to execute it via sidadm user on command prompt. BR*tools exe exists in kernel exe folder, so that path should already be set.

Please read the documentation further.

Thanks

[Former Member · Accepted solution]

> I am installing SAP ECC  6.0 sr1 on Virtual Box.
> OS = wins2003
> base memory = 1376 mb
> virtual memory = 2076 mb

This memory is really low, use at least 4 GB , even it is for testing, if the box is 64 bit.

And virtual memory should be 2 to 4 times the RAM.

Thanks

[manthana_c · Accepted solution]

Dear Guru:

I have found BRtools.exe already.

but anybody now short command show/change this parameter.

thx in advance

[Former Member · Accepted solution]

Hi,

Find the commnad, below;

To change the value

brspace -u / -f dbparam -a change -p <parameter_name> -v <value> -s spfile

Best regards,

Orkun Gedik

[former_member204746 · Accepted solution]

Hi,

try this:

login into Windows server as user "sidadm"

open a command prompt

use these commands:

sqlplus / as sysdba

alter system set shared_pool_size=400M scope=both;

exit

then, try again.

[Former Member · Accepted solution]

Dear All,

I am requested to increase the shared_pool_size parameter in Oracle for my SAP BW system which is running on AIX. Current value for shared_pool_size is 1GB and I am planning to increase it to 2GB.

The reason I plan to increase the mentioned paramenter is because when BW Consultant do data loading they are encountering problems and further checking from Basis end have made us to find this error:- ORA-04031: unable to allocate xxxx bytes of shared memory.

This problem is happening in my BW Production environemnt but I am planning to implement this changes in my BW Development to start off with.My current settings of the BW Development server configuration like CPU cores , RAM are as below:-

topas nmon

Memory_____________________________________________________________________

Physical PageSpace | pages/sec In Out | FileSystemCache │

│% Used 99.6% 7.0% | to Paging Space 0.0 0.0 | (numperm) 3.2% │

│% Free 0.4% 93.0% | to File System 0.0 0.0 | Process 77.9% │

│MB Used 24479.1MB 1441.6MB | Page Scans 0.0 | System 18.5% │

│MB Free 96.9MB 19038.4MB | Page Cycles 0.0 | Free 0.4% │

│Total(MB) 24576.0MB 20480.0MB | Page Steals 0.0 | -

---

│

│ | Page Faults 1165.3 | Total 100.0% │

│----

---

| numclient 3.2% │

│Min/Maxperm 714MB( 3%) 21405MB( 87%) <--% of RAM | maxclient 87.1% │

│Min/Maxfree 960 1088 Total Virtual 44.0GB | User 78.1% │

│Min/Maxpgahead 2 8 Accessed Virtual 24.1GB 54.8% | Pinned 18.8%

With the above server configuration, could I go ahead and increase the shared_pool_size parameter from 1GB to 2GB. Looking forward to your kind advise.

Thank you.

John.

[stefan_koehler · Accepted solution]

Hey John,

your current BW development server has not enough free memory to increase the shared pool size by 1 GB.

If you will increase your shared pool by 1 GB - your system will start paging.

Free Memory: 96.9MB
Numperm: 3.2% = round about 783 MB file system cache
Sum: 880 MB

Regards

Stefan

[Former Member · Accepted solution]

Hi Stefan & All

Thank you for your prompt reply, I appreciate it very much.

For my BW Development Server, I will forgo making changes to shared_pool_size parameter as per your advise.

Also I overlooked to mention earlied that I did a SAPPFPAR check on this BW Development Server and as per SAPPFPAR recommendations, I would need to change the below said parameters accordingly.

ipc/shm_psize_10 from 162000000 to 440000000

ipc/shm_psize_40 from 112000000 to 228000000

Do you think I would encounter any issues by changing the above mentioned parameters with the Current Memory availability in my BW Development Server ?

Apart from the above activity, I would also need to make some parameter changes in my BW Quality Server and BW Production Server. The memory configurations are as below for my servers:-

BW Quality Server:-

Memory ──────────────────────────────────────────────────────────────────────│

│ Physical PageSpace | pages/sec In Out | FileSystemCache│

│% Used 98.5% 22.4% | to Paging Space 0.0 0.0 | (numperm) 4.2%│

│% Free 1.5% 77.6% | to File System 0.0 1.5 | Process 71.3%│

│MB Used 14125.0MB 7331.2MB | Page Scans 0.0 | System 23.0%│

│MB Free 211.0MB 25436.8MB | Page Cycles 0.0 | Free 1.5%│

│Total(MB) 14336.0MB 32768.0MB | Page Steals 0.0 | -

---

│

│ | Page Faults 98.5 | Total 100.0%│

│----

---

| numclient 4.2%│

│Min/Maxperm 414MB( 3%) 12427MB( 87%) <--% of RAM | maxclient 86.7%│

│Min/Maxfree 960 1088 Total Virtual 46.0GB | User 72.2%│

│Min/Maxpgahead 2 8 Accessed Virtual 19.3GB 42.0%| Pinned 24.3%│

│──────────────────────────────────────────────────────────────────────────────

Can I make changes to the below Parameters in my BW Quality Server with the above memory configurations ?

a) shared_pool_size parameter from 1GB to 2GB - Yes / No and Why

BW Production Server:-

──────────────────────────────────────────────────────────────────────│

│ Physical PageSpace | pages/sec In Out | FileSystemCache│

│% Used 93.5% 0.3% | to Paging Space 0.0 0.0 | (numperm) 19.5%│

│% Free 6.5% 99.7% | to File System 0.0 2.5 | Process 53.9%│

│MB Used 22988.2MB 93.6MB | Page Scans 0.0 | System 20.1%│

│MB Free 1587.8MB 32674.4MB | Page Cycles 0.0 | Free 6.5%│

│Total(MB) 24576.0MB 32768.0MB | Page Steals 0.0 | -

---

│

│ | Page Faults 241.0 | Total 100.0%│

│----

---

| numclient 19.5%│

│Min/Maxperm 713MB( 3%) 21405MB( 87%) <--% of RAM | maxclient 87.1%│

│Min/Maxfree 960 1088 Total Virtual 56.0GB | User 70.4%│

│Min/Maxpgahead 2 8 Accessed Virtual 17.7GB 31.7%| Pinned 19.9%│

│──────────────────────────────────────────────────────────────────────────────│

Can I make changes to the below Paramaters in my BW Production Server with the above memory configurations ?

a) shared_pool_size parameter from 1GB to 2GB - Yes / No and Why

b) ipc/shm_psize_10 from 154000000 to 412000000

ipc/shm_psize_40 from 112000000 to 158000000

Looking forward to your kind reply on this.

Regards,

John

[stefan_koehler]

Hey,

if you really don't know anything about oracle or how to set an init parameter.

Please use the BR*Tools for changing database parameters.

-> http://help.sap.com/saphelp_nw70ehp1/helpdata/en/f1/0d01b42a4aa84fbe2be415d23bf023/content.htm

Regards

Stefan