Sunday, February 10, 2019

Exadata Storage Snapshots, Part 2


Licensing
(Part1 is here)

There is no information about Exadata Storage Snapshots in the Exadata Licanse Guide:




The Table 1-11 say you need Advanced Compression Options if you use "Storage Snapshot Optimization". 

But "Storage Snapshot Optimization"is not an "Exadata Storage Snapshot", here is some misunderstanding. Look "Storage Snapshot Optimization" description, it's about backup-restore: 

It is completely different technology!


There is WhitePaper "Storage Efficient Database Copy Options With Exadata" which say about Exadata Storage Snapshot licensing:

" Exadata customers have various methods of creating storage efficient database copies. These capabilities can be divided between: 
»Capabilities that natively exist in Exadata 
»Capabilities that can be used with Exadata but require additional hardware and/or licensing  "




Wishing to obtain additional evidence we downloaded the script options_packs_usage_statistics.sql from note Database Options/Management Packs Usage Reporting for Oracle Databases 11gR2, 12c, 12cR2 and 18c (Doc ID 1317265.1). This note describes how to check the usage of separately licensed Oracle Database Options/Management Packs. You can determine whether an option is currently in use in a database by running options_packs_usage_statistics.sql     
So, we've run options_packs_usage_statistics.sql on the clone database and obtained the result:

 PRODUCT                                       |USAGE        |LAST_SAMPLE_DATE  
----------------------------------------------|-------------|-------------------
Active Data Guard                             |NO_USAGE     |2019.02.02_09.53.14
Active Data Guard or Real Application Clusters|NO_USAGE     |2019.02.02_09.53.14
Advanced Analytics                            |NO_USAGE     |2019.02.02_09.53.14
Advanced Compression                          |NO_USAGE     |2019.02.02_09.53.14
Advanced Security                             |NO_USAGE     |2019.02.02_09.53.14
Database In-Memory                            |NO_USAGE     |2019.02.02_09.53.14
Database Vault                                |NO_USAGE     |2019.02.02_09.53.14
Diagnostics Pack                              |NO_USAGE     |2019.02.02_09.53.14
Label Security                                |NO_USAGE     |2019.02.02_09.53.14
OLAP                                          |NO_USAGE     |2019.02.02_09.53.14
Partitioning                                  |NO_USAGE     |2019.02.02_09.53.14
RAC or RAC One Node                           |NO_USAGE     |2019.02.02_09.53.14
Real Application Clusters                     |CURRENT_USAGE|2019.02.02_09.53.14
Real Application Clusters One Node            |NO_USAGE     |2019.02.02_09.53.14
Real Application Testing                      |NO_USAGE     |2019.02.02_09.53.14
Spatial and Graph                             |NO_USAGE     |2019.02.02_09.53.14
Tuning Pack                                   |NO_USAGE     |2019.02.02_09.53.14
.Database Gateway                             |NO_USAGE     |2019.02.02_09.53.14
.Exadata                                      |CURRENT_USAGE|2019.02.02_09.53.14
.GoldenGate                                   |NO_USAGE     |2019.02.02_09.53.14
.HW                                           |NO_USAGE     |2019.02.02_09.53.14
.Pillar Storage                               |NO_USAGE     |2019.02.02_09.53.14
PRODUCT                                       |FEATURE_BEING_USED                                      |USAGE          
----------------------------------------------|--------------------------------------------------------|----------------
Advanced Compression                          |Advanced Index Compression                              |NO_CURRENT_USAGE
Advanced Compression                          |Backup HIGH Compression                                 |NO_CURRENT_USAGE
Advanced Compression                          |Backup LOW Compression                                  |NO_CURRENT_USAGE
Advanced Compression                          |Backup MEDIUM Compression                               |NO_CURRENT_USAGE
Advanced Compression                          |Backup ZLIB Compression                                 |NO_CURRENT_USAGE
Advanced Compression                          |Data Guard                                              |NO_CURRENT_USAGE
Advanced Compression                          |HeapCompression                                         |NO_CURRENT_USAGE
Advanced Compression                          |Heat Map                                                |NO_CURRENT_USAGE
Advanced Compression                          |Hybrid Columnar Compression Row Level Locking           |NO_CURRENT_USAGE
Advanced Compression                          |Information Lifecycle Management                        |NO_CURRENT_USAGE
Advanced Compression                          |Oracle Advanced Network Compression Service             |NO_CURRENT_USAGE
Advanced Compression                          |Oracle Utility Datapump (Export)                        |NO_CURRENT_USAGE
Advanced Compression                          |Oracle Utility Datapump (Import)                        |NO_CURRENT_USAGE
Advanced Compression                          |SecureFile Compression (user)                           |NO_CURRENT_USAGE
Advanced Compression                          |SecureFile Deduplication (user)                         |NO_CURRENT_USAGE

 
As you see this script doesn't found ACO usage at all!



No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Does DEALLOCATE UNUSED or SHRINK SPACE will free space occupied by LOB segment?

Lets check how it works. My env is DB 19.20@Linux-x64 1) I created the table with 4 LOB columns of 4 different LOB types: BASICFILE BLOB, BA...