Post-upgrade problem on oracle win2003 32 bit

[Former Member]

Dear expert

we meet an unexpected situation Win2003r 32-bit , oracle 10.2.0.5

after the upgrade in the level SAP (SP upgrade)

the synptom is end user have get the connection because in DB ,

it can't accept more connection due to the memory limit.

We've already low the sga/pga and tried "3G/PAE" to break the 32 bit system's memory limit.

But all didn't take affect on th performance.

Do you have an idea about ?

Limit the oracle user profile(set the connction/idle time limits)?

Use the shared server?

Thank you very much!

Kate

[former_member188883 · Accepted solution]

Hi Kate,

Could you share the number of processes and sessions defined in initSID.ora file.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Kori，

I've currently no access to logon to it.

But one thing is for sure, the logon end user is a hard fixed demand.

I want someone like you who can provide me some direction to analyse and resolve the problem.

Thank you!

Kate JI

[former_member206552 · Accepted solution]

hi kate,

logon to SAP and go to

DB02

     -> Preformance Overview

          -> Additional Functions

               -> Database Parameters

look for processes and session

these are the values deepak is looking for, these values determin the amount of connection to the databse.

best regards

marius

[former_member188883 · Accepted solution]

Hi Kate,

Please find some suggestions for Oracle database running on 32-bit Windows environment.

1) Set registry parameter ORA_LPENABLE to 1

2) Free System Page Table Entries (PTE’s) – Memory Counter Should never fall below 7500 or so

    • /USERVA=2560 switch in boot.ini will help prevent this

3) Activate AWE on windows

•       Use AWE with Oracle by adding initialization  parameter
•      USE_INDIRECT_DATA_BUFFERS
•      Use DB_BLOCK_BUFFERS instead of DB_CACHE_SIZE
•      With AWE, database buffer cache can be increased up to roughly 12 GB
•      Default value for AWE_WINDOW_MEMORY is 1 GB

For more detailed explanation refer link http://www.oracle.com/technetwork/database/performance/windows-perf-best-practices-133724.pdf

Section : 32 bit Memory Best Practices

Hope this helps.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hello Kori!

Morning!

Thank you very much.

I will check your infomation right now.

I think that gonna be very userful:)

Have a nice day!

Kate