GeekArticles
FAQ
Oracle FAQvery large SGA
Author: asktom.oracle.com |
Published: 11th Mar 2008 |
Visited: 63 times |
Add CommentFiled in: Oracle FAQHi Tom,
Could you please give us some examples when do you think a very large SGA (I mean 5, 10, 20 Gb) is a good thing and when it is a bad thing ?
Thanks.
Read Article Sponsored Links
Related Articles
• Large JVM Memory and Garbage Collection
Although physical RAM is inexpensive, allocating large of amounts of memory to a JVM instance is not generally a good idea, says Azul CTO Gil Tene in this interview with Artima. Tene shows how recent research in garbage collection and JVM implementation helps overcome the memory barrier, resultin ...
• How to query a large table with cpu throttling My requirements:
1. I have a large table, in the range of 1 billion records.
2. But the machine is a relatively slow one. Therefore I would not
like to clog the machine when querying this large table.
My question:
A. Supposed I ...
• Strategy of backup large database (e.g. 2T) What is the best strategy of backup large database, say 2 T. Currently, we have a database size of 1T, and it grows fast and steady. We are using rman to do level 0 backup every Sat morning which takes about 11 - 12 hours and level 1 backup every we ...
• How to split a large (Loaded) Datafile into small ones Hi Tom,
Happy New Year.
I have tablespace SAY XYZ_FAT_TABLESPACE which has only one Datafile and it has now grown to 20GB.
I want to split this Loaded Datafile into 4 so that each is 5GB and can then indepandantly expand.
How to ...
• Efficiently Uploading Large Files via Streaming The process of uploading a file to a web server generally requires that the incoming file be stored in memory until the upload is complete. This works fine for relatively small files, but uploading larger files can cause errors and performance problems. The streaming solution presented in this art ...
• Toolbar's in IDE become large in Height and need resetting QC#: 49530 Version: 11.0 Status: Awaiting Requested Information Resolution: Need more information/demo/steps Description: Toolbars are much larger than normal in height. I usually right click and do a customize, select the toolbars and reset to adjust ...
• loading large fields Hello Tom,
I'm supposed to load some files that we receive from a third party db. Some fields might be wider than 4000 bytes. This means that we will have to use clobs, correct? How would you go about loading this data in the database? Can you gi ...