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 am trying to write a method that returns a string. But i keep on getting an error which says that return statement can only be present in functions. Now I tried all possible ways but i was not able to create a function. Could anyone please help [More]
Typically I import photos from my camera into events, and then I take the best photos from the event and put them into an album named after that "event" To do this quickly, I usually want to see the photo full screen (I just double click on a ph [More]
I have finally got around to trying the video in feature on my GeForce 4 4200ti vtd 8x.  I have the latest nvidia wdm capture drivers installed properly, but every time I try to use winproducer to capture a composite video signal from my vcr I am giv [More]
Hi Have had a HP4599 for a couple of years now and has always worked fine ... ish! Got a new work laptop so needed to set it up to work with my HP, yet when went through the HP setup (downloaded the latest software as working with  Windows 7) printer [More]
Since my wife started using her new iPhone to read our emails, I can't get any new emails on my iPad. Message says the email server is not responding. Any ideas how we view our email account on both iPad and iPhone?It sounds like a firewall or securi [More]
i have problem in my computer ,cause this get very slow after open 2 or 3 worksHi RashisR, Welcome to the HP Forums! I would like to take a moment and thank you for using the forum, it is a great place to find answers. For you to have the best experi [More]
I have a site that I developed previous and moving to CS 4.  I set up the testing server and it appears to work when ever I create a new file.  It does not work when I change a file.  It does not copy the new file over the old. Mac OSX 10.6 running a [More]
What is wrong with my iphone, it keeps dropping all my emails after I go in it. Once I get out of the email when I go back all emails are gone. HELPIf AT&T is the email account provider for this account, more than likely the account is a POP account [More]
I uninstalled Version 13 first, then downloaded the installer for v14. After closing Firefox & clicking on the installer results in this after 66%: I have tried several times but with the same result. How to proceed?That may be true but your site is [More]
I have thousands of songs on my iPod. I want them on my new laptop. I cannot sync them bc the copy of iTunes I downloaded came with a built-in, 100% undesired library. I can't do it by choosing the iPod and selecting "export library." I also can [More]