Re: fixed size

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 23 Jan 2001 20:07:51 -0000
Message-ID: <980281178.24097.1.nnrp-01.9e984b29@news.demon.co.uk>

If you want to see what is 'in' the fixed size,

select * from x$ksmfsv;

This shows identifies a number of fixed values, vectors and pointers used by Oracle to locate all the rest of the information in the SGA (I believe). Different platforms use different sized objects to hold (e.g.) long pointers, which is why the size of the fixed area is platform dependent.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



oracle wrote in message <94kk1q$a1r$1_at_nnrp1.deja.com>...


>Oracle 8.1.6 running on SUN Solaris (2.7)(Ultra BOX).  Anyways how does

>it matter of version and platform???  I'm curious to know.  Thanks for

>your help.

>

>

>

>In article <3A6DA5F3.BCF909E6_at_edcmail.cr.usgs.gov>,

>  Brian Peasland <peasland_at_edcmail.cr.usgs.gov> wrote:

>> > >    And on what parameters is it based on.

>>

>> IIRC, the fixed size of the SGA is version (and platform?) dependent.

>>

>> HTH,

>> Brian

>>

>> --

>> ========================================

>> Brian Peasland

>> Raytheons Systems at

>>   USGS EROS Data Center

>> These opinions are my own and do not

>> necessarily reflect the opinions of my

>> company!

>> ========================================

>>

>

>

>Sent via Deja.com

>http://www.deja.com/

Received on Tue Jan 23 2001 - 14:07:51 CST