Options and Packs in Oracle Database
What are the Options and Packs in Oracle Database?
- Advanced Compression
- Partitions
- OLAP – Online Analytical Processing
- RAC – Real Application Clusters
- Diagnostic Pack
- Tuning Pack
- Spatial
| Note: Except Spatial, we should have addtional License to use other options and packs. |
Link to check the usage:
Advanced Compression:
Oracle Advanced Compression provides database-compression capabilities that improve performance while reducing storage costs. Oracle Advanced Compression reduces an organization’s overall database storage footprint for all types of data—relational (table), unstructured (file), index, Data Guard redo, network, and RMAN backups—and also improves performance for all components of the database infrastructure, including memory and network bandwidth.
Partitions:
Partitioning enables tables and indexes to be subdivided into individual smaller pieces. Each piece of the database object is called a partition. A partition has its own name, and may optionally have its own storage characteristics. From the perspective of a database administrator, a partitioned object has multiple pieces that can be managed either collectively or individually. This gives the administrator considerable flexibility in managing a partitioned object. However, from the perspective of the application, a partitioned table is identical to a non-partitioned table; no modifications are necessary
when accessing a partitioned table using SQL DML commands. Logically, it is still only one table and any application can access this one table as they do for a non-partitioned table.
- Partitioning table based on Month
- Partitioning table based on Quarter
- Yearly partitions in Oracle database
OLAP – Online Analytical Processing:
Oracle OLAP is a world class multidimensional analytic engine embedded in Oracle Database 12c. Oracle OLAP cubes deliver sophisticated calculations using simple SQL queries – producing results with speed of thought response times. This outstanding query performance may be leveraged transparently when deploying OLAP cubes as materialized views – enhancing the performance of summary queries against detail relational tables. Because Oracle OLAP is embedded in Oracle Database 12c, it allows centralized management of data and business rules in a secure, scalable and enterprise-ready platform.
For enable and disable of olap, go through the below link:
RAC – Real Application Clusters:
Oracle Real Application Clusters (RAC) allow customers to run a single Oracle Database across multiple servers in order to maximize availability and enable horizontal scalability, while accessing shared storage. User sessions connecting to Oracle RAC instances can failover and safely replay changes during outages, without any changes to end user applications, hiding the impact of the outages from end users.
- Step by Step procedure for dry-run upgrade on RAC
- GI rolling upgrade from 19.12 to 19.15 on RAC
- Errors while running rootupgrade.sh GI upgrade RAC
Diagnostic Pack:
Oracle Diagnostics Pack, a part of the Oracle Database 11g product set, offers a comprehensive set of automatic performance diagnostics and monitoring functionality built into core database engine and Oracle Enterprise Manager. Whether you are managing one or many databases, Oracle Diagnostics Pack offers a complete, cost effective, and easy to use solution for managing the performance your Oracle Database environment. When used as part of Oracle Enterprise Manager, Oracle Diagnostics Pack additionally provides enterprise-wide performance and availability reporting, a centralized performance repository, and valuable cross-system performance aggregation, significantly simplifying the task of managing large sets of databases.
Tuning Pack:
Oracle Tuning Pack, an add-on pack for management of Oracle Database 11g, offers an extremely cost effective and easy-to-use solution that automates the entire application tuning process. Enhancement of SQL performance is achieved through real-time monitoring and SQL Advisors that are seamlessly integrated with the Enterprise Manager, and together provide a comprehensive solution for automating the complex and time-consuming task of application
tuning.
Saptial:
Oracle’s spatial database is included in Oracle’s converged database, allowing developers and analysts to get started easily with location intelligence analytics and mapping services. It enables Geographic Information System (GIS) professionals to successfully deploy advanced geospatial applications. Organizations can manage different types of geospatial data, perform hundreds of spatial analytic operations, and use interactive map visualization tools with the spatial features in Oracle Autonomous Database and Oracle Database.
See Also: