Home » RDBMS Server » Server Administration » Memory Allocation.
Memory Allocation. [message #212745] Mon, 08 January 2007 02:33 Go to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Hi,
Could you please let me know how to seggregate sizes of different components of memory structure like how much redo log buffer cache...
also when i run
sql>show sga
Total System Global Area 550767224 bytes
Fixed Size 731768 bytes
Variable Size 385875968 bytes
Database Buffers 163840000 bytes
Redo Buffers 319488 bytes

is the o/p could you please brief each one of these?

Thanks,
Shahnaz
Re: Memory Allocation. [message #212746 is a reply to message #212745] Mon, 08 January 2007 02:36 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi
Go through below link
http://www.adp-gmbh.ch/ora/concepts/sga.html


regards
Taj
Re: Memory Allocation. [message #212766 is a reply to message #212746] Mon, 08 January 2007 04:13 Go to previous message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Thanks Taj for your link, i am not clear with my first point i.e. how to allocate sizes?
Previous Topic: manually creating oracle9i database
Next Topic: ORA-01652
Goto Forum:
  


Current Time: Thu Dec 08 23:54:37 CST 2016

Total time taken to generate the page: 0.11078 seconds