parameters at session level

From: prasad maganti <prasadm_g_at_yahoo.com>
Date: Sat, 21 Jul 2001 08:18:22 -0700
Message-ID: <F001.00350B7B.20010721082049@fatcity.com>

hi dba's

can anybody clarify me the flwng:

at database level the parameter optimizer_mode=choose. and i connected to scott and i set the optimizer_goal= rule.

when i see from scott using
sql>show parameters optimizer
the value is shown as RULE

where as from connect internal
SVRMGR>SHOW PARAMETERS OPTIMIZER
showing CHOOSE.

But in the case of SQL_TRACE the system is showing the only value that is set at database level.

even if i set sql_trace=false in scott user and i issued
>show parameters sql_trace

it is showing only TRUE that is set at database level.

why oracle behaves different ways for different parameters.

prasad.

---

Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: prasad maganti
  INET: prasadm_g_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Sat Jul 21 2001 - 10:18:22 CDT