Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Avg function in awm

M.FazlollahiDec 16 2019 — edited Jan 2 2020

hello

I'm using database 12.2.0.2 and the latest release of awm.

I've wanted to make a cube with 2 dimension with avg summarize.

but when I maintain the mentioned cube avg change to sum!!!

What's happened?

Comments

Dude!
Your link does not work, perhaps I need to create an account?

Are you referring to the same information available at http://www.oracle.com/us/technologies/027617.pdf

It shows different prices though, but might answer some of your questions. Some of the prices are based on system with 2 CPU's or unlimited CPU's. The document is from Sept 2010, pretty recent.
1 person found this helpful
EdStevens
waldorfm wrote:
Your link does not work, perhaps I need to create an account?

Are you referring to the same information available at http://www.oracle.com/us/technologies/027617.pdf

It shows different prices though, but might answer some of your questions. Some of the prices are based on system with 2 CPU's or unlimited CPU's. The document is from Sept 2010, pretty recent.
Interesting. That doc doesn't distinguish between "Basic Limited" vs. "Basic" and "Primier Limited" vs. "Premier".

The link I gave was simply the result of going to www.oracle.com, selecting "Linux" under the "server and storage systems" column, then clicking the "Buy and Save" button. Scroll down and you'll see 5 levels of Linux support, with links to details on each.
2919781
...and that document could be improved by making the service level descriptions extend each other, to fully emphasize the differences:

Today:

Oracle Linux Network Support:Access to software and updates through the Unbreakable Linux Network.
Oracle Linux Basic Support: Network access plus 24x7 support with global coverage and complete Linux server lifecycle management.
Oracle Linux Premier Support: Network access, 24x7 support with global coverage, complete Linux server lifecycle management, plus
back port of fixes to earlier releases as well as Oracle Lifetime Support.

Instead:

Oracle Linux Network Support: Access to software and updates through the Unbreakable Linux Network.
Oracle Linux Basic Support: Network Support plus 24x7 support with global coverage and complete Linux server lifecycle management.
Oracle Linux Premier Support: Basic Support plus back port of fixes to earlier releases as well as Oracle Lifetime Support.

Yeah, I know. Saturday evening and all, get a life. But hey, she's in the shower, and I'm ready to go!
Sergio-Oracle
Answer
In the store, when you drill down to Oracle Linux Basic Limited Support, you'll see:
Pricing metric is per system. The system can have a maximum of two physical processors (sockets), unlimited number of cores and/or virtual guests.
Whereas Oracle Linux Basic says in the overview:
Pricing metric is per system. The system can have unlimited number of physical processors (sockets), unlimited number of cores and/or virtual guests.
Sergio
Marked as Answer by EdStevens · Sep 27 2020
EdStevens
Sergio wrote:
In the store, when you drill down to Oracle Linux Basic Limited Support, you'll see:
Pricing metric is per system. The system can have a maximum of two physical processors (sockets), unlimited number of cores and/or virtual guests.
Whereas Oracle Linux Basic says in the overview:
Pricing metric is per system. The system can have unlimited number of physical processors (sockets), unlimited number of cores and/or virtual guests.
Sergio
Ah .. I see!

Thanks.
Dude!
I found another link:

http://www.oracle.com/us/corporate/pricing/els-pricelist-070592.pdf

Oracle Linux Premier Limited and Oracle Linux Basic Limited support services are available only for systems with no more than 2 physical CPUs per system. Where computers are clustered, each system within the cluster must have no more than 2 physical CPUs.

Oracle Linux Premier, Oracle Linux Basic and Oracle Linux Network support services are available for systems with any number of physical CPUs per system.

Oracle Linux Network Support - Access to software and updates through the Unbreakable Linux Network. This is the cheapest, with currently $119, and I guess that's all that is required to have access to ULN and all Oracle kernel patches. That's only $10/month.

To compare the price with Red Hat: https://www.redhat.com/apps/store/server/
1 - 6

Post Details

Added on Dec 16 2019
#data-warehousing, #olap
4 comments
375 views