I've a mobile application that uses Oracle Lite 10g ( 10.2.0.2) as mobile server and Oracle Database Server 10g release 1 (10.1.0.2) as the repository database. Both of these components are installed on servers with Microsoft Windows 2000 Advanced Server.

My question is related with the repository database:

We use Automatic Shared Memory Management and have a SGA target = to the SGA Max Size = 1336Mb. ASMM always gave a bigger slice of memory to the Buffer Cache (about 70%), but in the last 2 weeks I noticed that the value of the Shared Pool started to increase and now it's bigger than Buffer Cache (a slice of 49,7%).

Here's my current situation:

Shared Pool 664 Mb

Buffer Cache 648 Mb

Large Pool 8 Mb

Java Pool 8 Mb

Other 8 Mb

I have some knowledge of Oracle Database Server Architecture, but I'm being able to interpret this behavior or why this is happening. Can anyone give me some help or some ideas ?

It's also important to say that we have been experiencing some performance problems in the last two weeks. We are also having a bigger volume of data.

Thanks for all your attention.

Best Regards,

Ricardo Santos