Re: Oracle license requirements for unused options
From: De DBA <dedba_at_tpg.com.au>
Date: Wed, 26 Oct 2011 13:22:45 +1000
Message-ID: <4EA77D05.8000209_at_tpg.com.au>
That is a bit of an eye-opener... I ran this statement on my play database (11.2.0.1) where I am quite sure that I never used the tuning pack, but it shows that it was last used only a few days back... Turns out this is because of the Automatic SQL Tuning Advisor, which as far as I can ascertain is enabled by default? I surely never ran DBMS_AUTO_TASK_ADMIN.ENABLE(..)... Yet another point to remember to disable when creating a new database... :(
Date: Wed, 26 Oct 2011 13:22:45 +1000
Message-ID: <4EA77D05.8000209_at_tpg.com.au>
That is a bit of an eye-opener... I ran this statement on my play database (11.2.0.1) where I am quite sure that I never used the tuning pack, but it shows that it was last used only a few days back... Turns out this is because of the Automatic SQL Tuning Advisor, which as far as I can ascertain is enabled by default? I surely never ran DBMS_AUTO_TASK_ADMIN.ENABLE(..)... Yet another point to remember to disable when creating a new database... :(
Makes one wonder what more extra licensable features are enabled by default...
Cheers,
Tony
On 26/10/11 03:00, Joel.Patterson_at_crowley.com wrote:
> Hey everyone, check it out. It is possible. I know you've been trying and trying :) Works on 10g too.
>
>
> A mere 150 lines give or take don't cha know.
>
> You betha, yah.
>
> Note: 1317265.1 hit link at bottom.
>
>
> SET LINESIZE 180;
>
<snip - overquoted>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 25 2011 - 22:22:45 CDT