Sitemap

Amicuk Programming Answers

Increase the SGA Memory

-0001-11-30   Views:0

Advertisement

Hi, Iam using oracle 9i OS Solaris version 9.2.0.6 I am new to Oracle Database and i learn DBA any help me. My Database Ram Size is 16 Gb Now the SGA Size is below Total System Global Area 3747585360 bytes Fixed Size 736592 bytes Variable Size 159383

Hi,
Iam using oracle 9i OS Solaris version 9.2.0.6
I am new to Oracle Database and i learn DBA any help me.
My Database Ram Size is 16 Gb
Now the SGA Size is below
Total System Global Area 3747585360 bytes
Fixed Size 736592 bytes
Variable Size 1593835520 bytes
Database Buffers 2147483648 bytes
Redo Buffers 5529600 bytes
Now i want to increase the SGA size to 5 Gb
How to increase the SGA Size and give the examples SGA Based parameters also i want to increase so Kindly Help.
Regards,
Suresh Kumar

The replay answer
Advertisement
Hi.It is correct that you must look into the documentation as the first-point-of-resource.It will be more quicker than to wait for the reply here.Not to say that don't post your question but do a search, get some thing in your hand,read it and when you dont understand it than post the question here.It will be more better approach of learning.
For your question , in 9i you can't increase the total memory for your SGA on the fly as like you can (to some extent).If you want to increase the total memory allocated to your SGA than you need to change the parameters which constitute the total memory for the SGA in 9i.REad here.
http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/create.htm#998095
SGA_MAX_SIZE parameter controls the total memory allocated to your SGA in 9i.You need to change its value in the parameter file/spfile and bounce your db to reflect teh changes.
Aman....

Go to See the other 6 answers

Increase the SGA Memory

Category:DefaultRelease time:-0001-11-30Views:130

Hi, Iam using oracle 9i OS Solaris version 9.2.0.6 I am new to Oracle Database and i learn DBA any help me. My Database Ram Size is 16 Gb Now the SGA Size is below Total System Global Area 3747585360 bytes Fixed Size 736592 bytes Variable Size 159383[More]

Error when i increase the SGA to more that 1GB

Category:DefaultRelease time:-0001-11-30Views:130

I have a server with 8 GB of memory running server 2003. i have 2 instances on the server, everytime i try to increase the SGA for any instance to more than 1GB the instances doesn't restart. the error message is 'Memory realm already exists' among o[More]

Free SGA Memory Available is  0 ?

Category:DefaultRelease time:-0001-11-30Views:130

Hi, We need to increased SGA_TARGET size but in sgainfor showing Free SGA Memory Available is  0 how can we increased SGA_TAGGET? SQL> select * from v$sgainfo; NAME BYTES RES Fixed SGA Size 2059216 No Redo Buffers 14712832 No Buffer Cache Size 192937[More]

After upgrading to Lion, the Finder will increase the virtual memory while using external HD

Category:DefaultRelease time:2015-10-11Views:130

after upgrading to Lion, the Finder will increase the "virtual memory size" while using external HD. I check it using Activity Monitor and found that "Finder" wll increase the "Virtual Memory Size" and "Private Memory Si[More]

The amount of free SGA memory available in the database

Category:DefaultRelease time:2015-10-11Views:130

Hi, How can we calculate the amount of free SGA memory available from the instance if the database is not set for Memory management.If the sga_max_size is set for a particular value and the db_cache_size and the shared_pool and all other components a[More]

How to Increase the SGA Size.

Category:DefaultRelease time:2015-10-11Views:130

Hi Guru's I want to Know How to Increase the SGA Size in Database 8.1.7.4.1 My Ram Size is 6 GB When I query the Below Script select name, value from v$parameter where name in ('shared_pool_size', 'java_pool_size', 'streams_pool_size', 'log_buffer',[More]

Any way to increase RemoteFX Video Memory?

Category:DefaultRelease time:-0001-11-30Views:130

Fairly direct question here, is there a way to manually increase the video memory allocated to a VM? We are running some applications that require more than the 320mb it seems to be allocating, is there a registry key or some way for us to control th[More]

My ipad shows capacity 13.6GB, available 0 bytes. Can I clear some items from the memory to increase the avaavailable memory?

Category:DefaultRelease time:-0001-11-30Views:130

my ipad shows capacity 13.6 GB, available 0 bytes. Can I clear some items from the memory to increase the available memory? Getting message "storage almost full"One usually large user of storage space is photos and videos. You could import them[More]

Increase the SGA size!

Category:DefaultRelease time:-0001-11-30Views:130

Hi, We are using EBS 12.0.6 and DB 10.2.0.3. Currentlly My SGA is 2 GB and we have 8 GB of RAM, and Swap area is 10 GB. Please recommemded us to SGA size and related DOC ID. thx.Hi again; In addition to my previous post also check Oracle Database 10g[More]

Increase the SGA and PGA size

Category:DefaultRelease time:-0001-11-30Views:130

Hello Guru, How do i check what is my SGA and PGA..I am using TOAD.. I need to increase the SGA and PGA size...Please help.. I have a table having 200 million records, all indexes are there for the column..But it hang on in the debugging mode and als[More]

Tuning Oracle Database - SGA Memory

Category:DefaultRelease time:-0001-11-30Views:130

Good morning Gurus,   I have this environment in my company:   SAP ECC 6   Oracle 10g   Aix 6.1 Our hardware resources:   Memory: 16GB Ram   Processor: 4 x 3.2Ghz   IBM Blade JS12   Recently, we migrated SAP 4.6C (Solaris) to SAP ECC (Aix). In this n[More]

Hot
Hi, I have a problem when consolidating parameters of the same structure type. I want to consolidate parameters between two Web Service CO. The output parameter of the first has the same type as the input parameter of the second. They are structures [More]
We're having a strange problem with our wifi.  We have a home hub 5 and various devices connect to it.  We've had various connectivity issues with the home hub connecting to the internet, but we've learned to live with that. However, we also have ano [More]
Good morning I phone family my name is William Nazario. Today I got very interested on a I phone 6.My biggest problem is that I don't have any phone service with any phone carrier. How should I go about getting the phone with a two year plan and with [More]
Hi, My Apple ID was recently compromised and the criminal used www.icloudilocation.com to rob my ID and password. Beware!How did you come across this? Did you receive an email that you thought was from Apple? If so, forward that email (if you still h [More]
Firefox does not start by clicking on the icon in RHEL 5 on thin clients, also the internet proxy server usename is not accepted for java applets on webpages. However while using Firefox on the servers directly everthing works fine. This issue occurs [More]
Dear all, We are sending BP from CRM to SAP R/3 system along with Sales area data,some of the BP got failed while sending into R/3.After analysis in SAP R/3 Customer master assigned into specefic sales areas. Can we do the same in SAP CRM,like BP can [More]
Hello, I'm using a WAP321 in my network, this have 2 SSIDs. The WAP321 is attached for switch Cisco WS-C3750X-24P-S with configuration port below. First SSID is Corp in corporate network, vlan 11, network 172.30.11.x/24 working normally no have probl [More]
hi, I have a Tuxedoserver that is also a Corba client. At start up an object is created in a remote domain, and ideally this object will be used throughout the lifetime of my server. So far so good. However, when something breaks (connection disapppe [More]
Out of the blue, the Firefox on my MacBook won't load any pages, it keeps saying "server not found". I'm on my pc right now so I know my wireless router is working. How do I get my Mac back on track?Go to User Name>Library>Preferences. Sea [More]
IPhone linked with old owner's account. Don't have access to old owner. Please help.If you are trying to activate an iPad or iPhone and it is asking for a previous owners Apple ID and password, you have encountered the Activation Lock. This is a secu [More]