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
I just spent two hours with Kid 1's iPad. I organized all the 100 apps into various different "folders", organizing educational games from non educational, separating out my apps (when i can get my hand on the iPad!) from his, (he's 4) and putti [More]
I've been having regular problems with my early 2008 iMac (2.4 GHz Intel, 250 GB SATA HD) freezing up, accompanied of course by the spinning rainbow "wheel of death".  The problem is particularly pervasive when I wake the computer from several h [More]
After the the upgrade for Itunes and the OS5 upgrade for my iphone, itunes no longer syncs my phone. Help?Make sure that the password for the MobileMe account is still entered in on iCal. Look in iCal under preferences, accounts, account informationR [More]
I recently tried to download an app on my iPhone 4S.  There was an error with my phone mid-download.  After a restart, the app is nowhere to be found on my phone, but I cannot re-download the app, as the app store thinks it is already on my phone.  W [More]
i run my MBP in lid closed mode all of the time, as i have a Cinema Display hooked up. i'm not too worried about the MBP overheating, but i was wondering about the display getting extra hot from the MBP when it's closed. i do have a radtech microfibr [More]
Hi all.... Pls understand my requirement and post ur replies...i dont need the basic LSMW learning steps for MM,Vendor etc.,like that... My problem is...im want to upload my material master datas by steps like 1st i want to uplaod the basic views 1&2 [More]
Just getting started in the world of cocoa, objective-c, etc. and have basically started by building a very basic app and slowly adding things to that app (however arbitrary and seemingly useless) to teach myself new things. I initially started with [More]
hi: it seems the rmi object can only be registed in a startup class, is there any way to do this in an nostartup class? Thanks for any clue. Reno hu TCSIYes. It is possible to export an RMI object from a servlet's init() method. You will have to spec [More]
I made a post about LG Ally having this issue a few days ago and I've done heavy research on this issue since then and found that pretty much all 2.1 devices have this issue. Yes google is aware of it and I've seen topics where verizon and htc said t [More]
Hi, i´ve installed a middle tier instance of AS 10g , and i want to register it into a oid instance, but when i try to do this trough EM it fails and show the following information in the logs, could anobody help us, I'm sure that the oid is up and r [More]