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

Report message to a moderator

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

Report message to a moderator

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?

Report message to a moderator

Previous Topic: manually creating oracle9i database
Next Topic: ORA-01652
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 04:43:02 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.