Hi all,
If I use the Oracle 10g feature "Automatic Shared Memory Management" I
need to buy the Diagnostics Pack license?

Just to test, I used the ASMM in a test environment (enabling and
disabling ASMM) and I could not find any row in the
dba_feature_usage_statistics showing that I used this feature. There is
no "SGA/Memory Advisor" row in this view! In fact, there is a "Dynamic
SGA" row in this view, but this feature was used 1 month ago, the
LAST_USAGE_DATE column is not the current date... (My database version
is Oracle 10.1.0.2.0)

Does it mean I can use the ASMM feature even without having the
Diagnostics Pack license?

Many thanks in advance for the help!
Ana

Ana Ribeiro wrote:
> Hi all,
> If I use the Oracle 10g feature "Automatic Shared Memory Management" I
> need to buy the Diagnostics Pack license?
>
> Just to test, I used the ASMM in a test environment (enabling and
> disabling ASMM) and I could not find any row in the
> dba_feature_usage_statistics showing that I used this feature. There is
> no "SGA/Memory Advisor" row in this view! In fact, there is a "Dynamic
> SGA" row in this view, but this feature was used 1 month ago, the
> LAST_USAGE_DATE column is not the current date... (My database version
> is Oracle 10.1.0.2.0)
>
> Does it mean I can use the ASMM feature even without having the
> Diagnostics Pack license?
>
> Many thanks in advance for the help!
> Ana

It sounds like it but as you are finding out, oracle has kind of messed
things up in this area with 10g OEM and licensing of the packs.
There's a whole set of other related issues if you have purchased
standard edition instead of enterprise.

Filing a service request with oracle is one way of getting a correct (
perhaps ) answer to your question.

Talking to your oracle sales rep is also another recommended option.

Ana Ribeiro wrote:
> Hi all,
> If I use the Oracle 10g feature "Automatic Shared Memory Management" I
> need to buy the Diagnostics Pack license?
>
> Just to test, I used the ASMM in a test environment (enabling and
> disabling ASMM) and I could not find any row in the
> dba_feature_usage_statistics showing that I used this feature. There is
> no "SGA/Memory Advisor" row in this view! In fact, there is a "Dynamic
> SGA" row in this view, but this feature was used 1 month ago, the
> LAST_USAGE_DATE column is not the current date... (My database version
> is Oracle 10.1.0.2.0)
>
> Does it mean I can use the ASMM feature even without having the
> Diagnostics Pack license?
>
> Many thanks in advance for the help!
> Ana

What features do you consider to be "Automatic Shared Memory
Management?" Are you actually referring to an EM screen rather than
the feature?

The Oracle rdbms feature related to automatically managing the Shared
Pool where it re-assigns memory to the buffer cache, shared pool,
etc... are not related to the AWR feature and were included with the db
starting with version 9

-- Mark D Powell --

Please check the following article:

http://www.oracleadvice.com/10g/10g_...aredmemory.htm

"... Automatic Shared Memory Management
This is an important enhancement of Oracle10g and expands on the
ability to dynamically resize SGA components. By allowing Oracle to
automatically adjust how much shared memory is allocated to each SGA
structure, you can make optimal use of buffer cache memory and at the
same time decrease the likelihood of shared pool related ORA-04031
errors.
...."

This is an Oracle 10g feature, any ideas if I need the Diagnostics
Package license?
Thanks!
Ana

Mark D Powell wrote:

> Ana Ribeiro wrote:
> > Hi all,
> > If I use the Oracle 10g feature "Automatic Shared Memory Management" I
> > need to buy the Diagnostics Pack license?
> >
> > Just to test, I used the ASMM in a test environment (enabling and
> > disabling ASMM) and I could not find any row in the
> > dba_feature_usage_statistics showing that I used this feature. There is
> > no "SGA/Memory Advisor" row in this view! In fact, there is a "Dynamic
> > SGA" row in this view, but this feature was used 1 month ago, the
> > LAST_USAGE_DATE column is not the current date... (My database version
> > is Oracle 10.1.0.2.0)
> >
> > Does it mean I can use the ASMM feature even without having the
> > Diagnostics Pack license?
> >
> > Many thanks in advance for the help!
> > Ana
>
> What features do you consider to be "Automatic Shared Memory
> Management?" Are you actually referring to an EM screen rather than
> the feature?
>
> The Oracle rdbms feature related to automatically managing the Shared
> Pool where it re-assigns memory to the buffer cache, shared pool,
> etc... are not related to the AWR feature and were included with the db
> starting with version 9
>
> -- Mark D Powell --

Ana Ribeiro wrote:
> Please check the following article:
>
> http://www.oracleadvice.com/10g/10g_...aredmemory.htm
>
> "... Automatic Shared Memory Management
> This is an important enhancement of Oracle10g and expands on the
> ability to dynamically resize SGA components. By allowing Oracle to
> automatically adjust how much shared memory is allocated to each SGA
> structure, you can make optimal use of buffer cache memory and at the
> same time decrease the likelihood of shared pool related ORA-04031
> errors.
> ..."
>
> This is an Oracle 10g feature, any ideas if I need the Diagnostics
> Package license?
> Thanks!
> Ana

Please do not top post. Scroll to the bottom to reply.

The answer to your question, quite frankly, is that members of this
group, end-users, may have opinions about licensing but even when we
are right it is meaningless as we have no idea what license agreement
your management has signed. You need to take this question directly
to your rep at Oracle.

<THE_QUESTION>
I am always amazed by people that ask license questions here: Not
every organization has the same license. And the opinion of other
users is totally irrelevant. We could render an opinion that is
correct today but be completely wrong tomorrow.

Risking one's employment and employer by asking us these questions
makes absolutely no sense. So why does this keep coming up?
</THE_QUESTION>
--
Puget Sound Oracle Users Group

On Fri, 29 Sep 2006 09:26:14 -0700, DA Morgan <damorgan@psoug.org>
wrote:

>I am always amazed by people that ask license questions here: Not
>every organization has the same license. And the opinion of other
>users is totally irrelevant. We could render an opinion that is
>correct today but be completely wrong tomorrow.

I think you are right. But on the other hand the licensing structure
of Oracle as outlined on the Oraclestore, as far as I can understand
it, not being a native English speaker, is *EXTREEMLY DIFFICULT* to
understand.
What's more : if you talk to two *different reps*, you will likely get
2 *different answers*.

And how do you license Management Packs if you need them for your
customers? Do you need to pay for every individual CPU?
The current answer of Oracle to this question is : YES.
Did you ever try to find out what is in the default Grid Control
without Management Packs (and how usuable it is, without Management
Packs). You almost can't !
Oracle is asking (on their store) €23500 per cpu for a single
management pack, so it is a pretty relevant question.


Also if you run a default install of Enterprise Edition, you may run
into Oracle lawyers, because, although you don't even use it, you
*installed* it. One of our customers was considered not 'compliant' by
Oracle and they were threatened with a lawsuit, they are now
considering changing to a different database because Oracle is too
expensive.

--
Sybrand Bakker, Senior Oracle DBA

Sybrand Bakker wrote:
> On Fri, 29 Sep 2006 09:26:14 -0700, DA Morgan <damorgan@psoug.org>
> wrote:
>
> >I am always amazed by people that ask license questions here: Not
> >every organization has the same license. And the opinion of other
> >users is totally irrelevant. We could render an opinion that is
> >correct today but be completely wrong tomorrow.
>
> I think you are right. But on the other hand the licensing structure
> of Oracle as outlined on the Oraclestore, as far as I can understand
> it, not being a native English speaker, is *EXTREEMLY DIFFICULT* to
> understand.
> What's more : if you talk to two *different reps*, you will likely get
> 2 *different answers*.
>
> And how do you license Management Packs if you need them for your
> customers? Do you need to pay for every individual CPU?
> The current answer of Oracle to this question is : YES.
> Did you ever try to find out what is in the default Grid Control
> without Management Packs (and how usuable it is, without Management
> Packs). You almost can't !
> Oracle is asking (on their store) €23500 per cpu for a single
> management pack, so it is a pretty relevant question.
>
>
> Also if you run a default install of Enterprise Edition, you may run
> into Oracle lawyers, because, although you don't even use it, you
> *installed* it. One of our customers was considered not 'compliant' by
> Oracle and they were threatened with a lawsuit, they are now
> considering changing to a different database because Oracle is too
> expensive.
>

There is no disagreement as to whether oracle has really messed up the
licensing options and the consequences of trying to navigate thru "yet
another" GUI for 10g. If you are a standard edition customer it gets
even uglier even if you might want to pay.

Someone named Mark ( dunno last name ) who apparently was an oracle
employee was going to try to get these types of messy implications
straightened out.

What role was that guy in and has he made any progress in this area to
date?

hpuxrac wrote:
> Sybrand Bakker wrote:
>> On Fri, 29 Sep 2006 09:26:14 -0700, DA Morgan <damorgan@psoug.org>
>> wrote:
>>
>>> I am always amazed by people that ask license questions here: Not
>>> every organization has the same license. And the opinion of other
>>> users is totally irrelevant. We could render an opinion that is
>>> correct today but be completely wrong tomorrow.
>> I think you are right. But on the other hand the licensing structure
>> of Oracle as outlined on the Oraclestore, as far as I can understand
>> it, not being a native English speaker, is *EXTREEMLY DIFFICULT* to
>> understand.
>> What's more : if you talk to two *different reps*, you will likely get
>> 2 *different answers*.
>>
>> And how do you license Management Packs if you need them for your
>> customers? Do you need to pay for every individual CPU?
>> The current answer of Oracle to this question is : YES.
>> Did you ever try to find out what is in the default Grid Control
>> without Management Packs (and how usuable it is, without Management
>> Packs). You almost can't !
>> Oracle is asking (on their store) €23500 per cpu for a single
>> management pack, so it is a pretty relevant question.
>>
>>
>> Also if you run a default install of Enterprise Edition, you may run
>> into Oracle lawyers, because, although you don't even use it, you
>> *installed* it. One of our customers was considered not 'compliant' by
>> Oracle and they were threatened with a lawsuit, they are now
>> considering changing to a different database because Oracle is too
>> expensive.
>>
>
> There is no disagreement as to whether oracle has really messed up the
> licensing options and the consequences of trying to navigate thru "yet
> another" GUI for 10g. If you are a standard edition customer it gets
> even uglier even if you might want to pay.
>
> Someone named Mark ( dunno last name ) who apparently was an oracle
> employee was going to try to get these types of messy implications
> straightened out.
>
> What role was that guy in and has he made any progress in this area to
> date?

That Mark guy is Mark Townsend, Oracle's Senior Director of Database
Product Management.

From my experience ... if he said he would work on it ... it is being
worked on.
--
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group

DA Morgan wrote:
> >
> > There is no disagreement as to whether oracle has really messed up the
> > licensing options and the consequences of trying to navigate thru "yet
> > another" GUI for 10g. If you are a standard edition customer it gets
> > even uglier even if you might want to pay.
> >
> > Someone named Mark ( dunno last name ) who apparently was an oracle
> > employee was going to try to get these types of messy implications
> > straightened out.
> >
> > What role was that guy in and has he made any progress in this area to
> > date?
>
> That Mark guy is Mark Townsend, Oracle's Senior Director of Database
> Product Management.
>
> From my experience ... if he said he would work on it ... it is being
> worked on.

Slowly apparently perhaps and with little if any updates being provided.

hpuxrac wrote:

>>> Someone named Mark ( dunno last name ) who apparently was an oracle
>>> employee was going to try to get these types of messy implications
>>> straightened out.
>>>
>>> What role was that guy in and has he made any progress in this area to
>>> date?
>> That Mark guy is Mark Townsend, Oracle's Senior Director of Database
>> Product Management.
>>
>> From my experience ... if he said he would work on it ... it is being
>> worked on.
>
> Slowly apparently perhaps and with little if any updates being provided.

email him and ask if you are that interested.
--
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group