Re: V$SGA_TARGET_ADVICE in Oracle RDBMS 10.2

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Tue, 16 Aug 2005 04:11:03 GMT
Message-Id: <pan.2005.08.16.04.11.02.824841@sbcglobal.net>

On Mon, 15 Aug 2005 06:45:40 +0000, Jonathan Lewis wrote:

>
> Look in v$fixed_view_definition for the
> SQL that defines gv$sga_target_advice.
> As a short term measure on a test db,
> you can always create your own gv$
> and v$ views to overwrite the proper
> ones.

Jonathan, the problem was in my experimenting with the database software. I have a small PC with only 512MB of RAM and I wanted to trim the database as much as possible. I excluded OLAP, Oracle*Text and data mining. The problem was that I was linking the database using ins_rdbms.mk directly. Somewhere in the process something was broken. When I re-installed the database software the way it is described in the installation guide everything worked. Bummer. Now, I'll have to buy 256MB more RAM.

-- 
http://www.mgogala.com

Received on Mon Aug 15 2005 - 23:11:03 CDT