Hi,
I am getting little confussion how the memory is
allocated for
top-level heaps and subheaps in shared
pool.
How can we know what are all the top-level heaps
and subheaps and their hierarchy.
Is it possible to get it from any X$
tables.
Freeable chunks can be flushed out?If yes ,then
Sultan Syed
[mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 8:49
AMTo: Multiple recipients of list ORACLE-LSubject: Top
level heaps/subheaps
Hi,
I am getting little confussion how the memory is
allocated for
top-level heaps and subheaps in shared
pool.
How can we k
-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Bobak, MarkSent: Tuesday, January 06, 2004 8:10
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
Top level heaps/subheaps
To
quote Steve's book, aka "The Bible":
freeabl:
Freeable chunks conta
2004 9:44
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
Top level heaps/subheaps
However, give serious thought to reading Jonathon Lewis' book Practical
Oracle 8i prior to the Adams book unless you understand virtually everything
in Jonathon's book. Steve's book is excellent but
Well, a heap is just a bunch of memory (allocated
incontiguous extents) and you can practically allocate any size of chunk
of memory from it (with some restrictions). A regular heap has freelist and LRU
list mechanismsfor managing space init as well as memory
allocation/releasing routines
-LSubject:
Re: (long) Top level heaps/subheaps
Well, a heap is just a bunch of memory (allocated
incontiguous extents) and you can practically allocate any size of chunk
of memory from it (with some restrictions). A regular heap has freelist and LRU
list mechanismsfor managing space init as well
[EMAIL PROTECTED] writes
I won't argue that, Allan. The guy writes two sentences, and it
takes a week for the full implications of what he said to sink in.
Jonathan's book is excellent as well. They are both at the top of
my reference list, as well as my recommended list.
* to satisfy curiosity
* to have a better understanding of how Oracle works
Most DBA's probably don't need to know this stuff. Most
performance problems will not likely require you to know
any of this.
If you spend a lot of time solving other people's 'unsolvable'
Oracle performance problems,
The name is Breitling. Wolfgang Breitling. Not to be confused with Bond. James Bond.
On 2004.01.06 12:34, Jared Still wrote:
* to satisfy curiosity
* to have a better understanding of how Oracle works
Most DBA's probably don't need to know this stuff. Most
performance problems will not
As well as Arthur's books and Douglas's books. Some of the Robert's, too. Personally,
I'd recommend Stranger In The Strange Land.
On 2004.01.06 12:04, Pete Finnigan wrote:
[EMAIL PROTECTED] writes
I won't argue that, Allan. The guy writes two sentences, and it
takes a week for the
You missed out Terry:
quote
Oh, it's largely intuitive, Archchancellor. Obviously you
have to spend a lot of time learning it first, though.
end quote
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
Welcome back. I was wondering where you've been the last couple of weeks.
At 11:19 AM 1/6/2004, you wrote:
As well as Arthur's books and Douglas's books. Some of the Robert's, too.
Personally,
I'd recommend Stranger In The Strange Land.
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex
Yeah I know, did it again.
On Tue, 2004-01-06 at 10:19, Mladen Gogala wrote:
The name is Breitling. Wolfgang Breitling. Not to be confused with Bond. James Bond.
On 2004.01.06 12:34, Jared Still wrote:
* to satisfy curiosity
* to have a better understanding of how Oracle works
Most
To: Multiple recipients of list ORACLE-L
Subject: Re: Top level heaps/subheaps
You missed out Terry:
quote
Oh, it's largely intuitive, Archchancellor. Obviously you
have to spend a lot of time learning it first, though.
end quote
Regards
Jonathan Lewis
http
Since we're both going to be in Dallas in March I'll have to have you write
my name 1000 times ;-)
At 01:04 PM 1/6/2004, you wrote:
Yeah I know, did it again.
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please see the official
Piece of cake using vi, perl, or even pl/sql.
vi: 1000iWolfgangENTERESC
perl: print qq{Wolfgang\n} x 1000;
pl/sql: typically more verbose, left as an exercise for the reader.
Oh, you didn't mean paper did you? Not sure I still
know how to do that.
;)
Jared
On Tue, 2004-01-06 at 12:19,
16 matches
Mail list logo