0
votes
3answers
84 views

Oracle monitor tool [closed]

Our Oracle server continues with out of memory problem, and we don't have an Oracle DBA in our team. Is there any Oracle monitor tool or ways to find the reason? We have a lot of stored procedure ...
0
votes
1answer
25 views

What is a construct in Oracle?

I'm currently studying Oracle Architecture and Database Memory Structures. I'm a newbie in the subject and I just read that a "Shared Pool" is "a data structure that caches various constructs that can ...
1
vote
1answer
419 views

Oracle Automatic Memory Management - SGA_MAX_SIZE

When using Automatic Memory Management, what value should SGA_MAX_SIZE be? Should it be 0? These are my current settings, and I'm unsure whether to leave SGA_MAX_SIZE or set it to 0. ...
2
votes
1answer
3k views

Cannot set MEMORY_TARGET for Oracle 11.2

I'm trying to configure an Oracle installation on a developer machine (Windows 7 Professional 64bit). The machine has 16GB of RAM and I'd like to configure MEMORY_MAX_TARGET to 8g but have ...
0
votes
0answers
152 views

After RAM upgrade on 32-bit Oracle server, ORA-04031: unable to allocate x bytes of shared memory

We are in the process of upgrading our Oracle database server at work, from SUSE Linux Enterprise Server 10.4 / Oracle 10g / 4GB RAM (Intel 32-bit) to Scientific Linux 6.4 / Oracle 12c / 8GB RAM ...
0
votes
1answer
825 views

Target database memory exceed available shared memory

I am trying to install Oracle 12c on a RHEL 6.4 system with 64GB of memory. When I try to enable automatic memory to 48GB, I get the error: What do I need to change to allow Oracle to use more than ...
0
votes
2answers
2k views

ORA-04031: unable to allocate 4708660 bytes of shared memory

I am running Oracle 11g R1 on my local development machine. I have been trying to run an anonymous block to test the FORALL statement in Oracle to insert 25,000 records. I get the following error: ...
4
votes
3answers
3k views

Unable to start Oracle (11g1) due to bad memory configuration (ORA-00837)

I decided to reduce the memory allocation of a local developer instance, and was told that the following command did the job; alter system set memory_max_target = 512M scope = spfile; Which I guess ...
5
votes
2answers
1k views

ORA-04031: unable to allocate bytes of shared memory (“”,“”,“”,“”)

I am receiving this error in a development database. It happens on some specific queries (simple inserts and deletes via .NET application). The database is used by one user, and error happens ...
2
votes
3answers
330 views

RAM Impact on Oracle database operations

We are seeing drastic change in the amount of time taken for db operations depending on ram size. The same content when inserted into a db running on a 4gb ram machine takes about 600% more than into ...
1
vote
1answer
72 views

RAM Impact on database operations [duplicate]

Possible Duplicate: RAM Impact on Oracle database operations We are seeing drastic change in the amount of time taken for db operations depending on ram size. The same content when ...