DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=pxBTBs1vArjbCjamK7NegZuwYWFm/MG/8OikSI0dNBsVTFntnBeAtDnguBLI8VwcJ8o1rOY2zY8Cho0HWzcl+BKxMFhMTAeECe9p9wXcfFgrroz8Y9YW2m6+a5UuI52nwYAH8PSfc2KOgYSut16Bu2vWr182qOAH/hhvKvJLR8w=
Message-ID: <2ead3a60805220941i5880177i354afc2f33c4a375@mail.gmail.com>
Date: Thu, 22 May 2008 09:41:13 -0700
From: "John Kanagaraj" <john.kanagaraj@gmail.com>
To: "Ram Raman" <veeeraman@gmail.com>
Subject: Re: grant select command so slow
Cc: joan.hsieh@tufts.edu, oracle_l <ORACLE-L@freelists.org>
In-Reply-To: <effc058d0805191041l6c7362a6w17738d09a278527f@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Disposition: inline
References: <482B33F9.7040006@tufts.edu>
	 <2ead3a60805151239u709dce53i37e048afeb688192@mail.gmail.com>
	 <effc058d0805191041l6c7362a6w17738d09a278527f@mail.gmail.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: john.kanagaraj@gmail.com

> If that was the case, how did the grant run very fast the first time,
> according to the OP.

Not sure if that question was addressed to me, but here's a stab at
the answer (Disclaimer: I am a member of the BAAG party, so guessing
violates my agreement 8-)

The OP wasn't clear *when* the grants were first run. Was this when
the number of tables/views were less? What was the other load at that
time? Tracing the event and providing some stats would give us the
right clues. Otherwise we are just guessing here.

In general, the principles that I explained above applies: The
execution of thousands of GRANT statements translates to thousands of
hard parses and every SQL statement will get a different hash value,
chopping up your shared pool into fine bits.

-- 
John Kanagaraj <><
DB Soft Inc
http://www.linkedin.com/in/johnkanagaraj
http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!)
** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **
--
http://www.freelists.org/webpage/oracle-l