| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Shared Memory Problem
<FONT face=Arial color=#0000ff
size=2>Another thing to consider is if you are using Multi-threaded Servers for
your connections. If you are and have not set a Large Pool size,
then memory is consumed in the Shared Pool for a subset of the session
memory.
<FONT face=Arial color=#0000ff
size=2>
If you
are using MTS with Siebel, have you encountered any annoyances/problems/gotcha's
that you'd like to share?
<FONT face=Arial color=#0000ff
size=2>
<FONT face=Arial color=#0000ff
size=2>Thanks
Tony
Aponte
<FONT face="Times New Roman"
size=2>-----Original Message-----From: Behar, Rivaldi
[mailto:Rivaldi.Behar_at_ilonafinancial.com]Sent: Friday, May 11, 2001
6:29 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: Shared Memory Problem
Try to flush shared pool.
Rivaldi
-----Original Message----- From:
Upanesh Patel [<A
href="mailto:upanesh_oracle_at_yahoo.com">mailto:upanesh_oracle_at_yahoo.com]
Sent: Friday, May 11, 2001 4:06 PM <FONT
size=2>To: Multiple recipients of list ORACLE-L <FONT
size=2>Subject: Shared Memory Problem
Hello,
We're Running Oracle 8.1.6.2 on Sun 420R with solaris
7. We have a front-end Siebel 2000 Sales Package.
We have about 50 concurrent users and a lot of
Siebel Workflow Process (which basically just route
the work from one user to the next... so lot of sql it
send to the server...) and have an SGA of about 120M
of which 60M is shared_Pool_size...
Problem: ORA-04031: unable to
allocate 4096 bytes of shared memory ("shared
pool","unknown object","PL/SQL MPCODE","BAMIMA: Bam
Buffer")
It looks like Siebel is using bind variables, so that
should not be a problem. Also, this erros occurs
after the database has been up for about 5 days.
Is there a bug or anything with Oracle 8.1.6.2?
TIA,
Upanesh
 |
 |