Batala,

If your system starts using swap area, then the problem is not just due to memory being used as cache, as jtomas suggests. It means that the memory manager can no longer free enough cache pages to make room for application memory pages, and it starts moving other ("cold") application memory pages to swap to make room for new ones.

You will need to monitor memory usage of your applications, and see which process is responsible for exceeding the available memory. It could be the database processes, if they're executing memory intensive requests, or it could be the java processes.

I would suggest you start by monitoring the RSS or RES (resident set size) of processes, which shows the number of physical memory pages in use by that particular process. The database processes will share some (or most) of the pages that are in the SGA (shared memory segment), so you may want to subtract the size of the SGA from the RSS of oracle processes to see roughly how many non-shared pages they have.

The top and ps commands can give you this information. I find it useful to sort the top output by RES, but if your database has a large SGA, you will find mostly oracle processes on top, and the processes with the most private RSS may not be visible if they're not oracle processes.

1  out of 2 found this valuable. Do you find this valuable? Do you?    

Hi
We do not have this type of support, at least not through the UI. You can create a single template with both layouts and wrap conditional formatting around them so one or the other gets shown. I'll write it up on the blog in the next day or so http://blogs.oracle.com/xmlpublisher
Tim

 out of  found this valuable. Do you find this valuable?    

The functionality works if you have Asset tracking turned on (OAT). When you link the eAM asset with the FA Asset, and perform the Org transfer of an Inventory org item it will automatically prompt you with - Do you want to transfer the FA asset?.

Sue

1  out of 1 found this valuable. Do you find this valuable? Do you?    

I am not sure how do you implement 11g RMAN commands if your database version is 10gR2. First you need to install 11g Database. RMAN is a oracle tools that comes with Database like 9i or 10g or 11g. Many RMAN commands are same but you will get some extra features for 11g.

Thanks
Monowar

 out of  found this valuable. Do you find this valuable?    

sqlplus / as sysdba

show parameter <parameter_name>
EX:
sys@oxiprd> show parameter shared

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
max_shared_servers integer 20
shared_memory_address integer 0
shared_pool_reserved_size big integer 10485760
shared_pool_size big integer 117440512
shared_server_sessions integer 0
shared_servers integer 0
You can put full or partial name of the parameter

 out of  found this valuable. Do you find this valuable?    

You *can* build a physical standby database with SE, and this is almost certainly what you want for disaster recovery.

The only catch is that you cannot use DATA GUARD to maintain the physical standby -- it is not available with Standard Edition. Happily, all you really need is a couple shell scripts to transfer archived redo logs, and apply them at the DR site.

The only catch here, is that with this technique, you *will* lose some data when you failover to the DR site, because the standby database can on be as current as the last *archived* redo log. You can probably fix this, though, by using some sort of block-level replication to synchronously maintain the online redologs at the DR site. It will probably be expensive, and has the potential to slow down the primary database -- perhaps significantly -- so do this only if you really need to.

 out of  found this valuable. Do you find this valuable?    

Ask your question at forums.oracle.com, not here.

0  out of 1 found this valuable. Do you find this valuable? Do you?    

Ask your question at forums.oracle.com, not here.

 out of  found this valuable. Do you find this valuable?