Many organizations do not have or allocate money for auditing. Yes, there are many third party products designed to help businesses manage auditing of database systems like Oracle Audit Vault, however there are simple and effective ways a database support team may effectively demonstrate and implement controls to satisfy questions surrounding Confidentiality, Integrity and Access…

Resource Manager has changed a lot in Oracle Database 12c, especially if Oracle Multitenant is used. It can manage the available resources between the consumer groups in a single PDB as well as among all the PDBs. DBAs who are planning the upgrades or consolidations to Oracle Database 12c need to understand how the new…

Before 12c, application developers were required to deal explicitly with outages of the underlying software, hardware, and underlying communication layers. FAN delivers exception notifications to applications fast. However, neither FAN nor Oracle technology before 12c report the outcome of the last operation to the application in case of outages, nor do they provide support to…

Oracle Database 12c introduced an exciting new feature called Flex Automatic Storage Management (Flex ASM) that can dramatically enhance key areas in clustering and manageability. These enhancements benefit customers managing dynamic and flexible environments, often associated with cloud computing, as well as Oracle’s engineered systems. This session presents an overview of Flex ASM and related…

A little used feature of Oracle Databases is the ability to create a virtual database using application contexts. This feature not only allows creation of a virtual database, limiting the rows of data visible to various user classes, but can also be used to manipulate the values of data columns in an efficient manner. This…

When I wrote Optimizing OraclePerformance with Jeff Holt back in 2003, my goal was to define areliable, teachable method for fixing software performance problems. After a few months of contentment after finishing the project, I began to notice a trend in how people were responding to it. Many of the questions coming in had started to…

While High Availability is critical to our jobs, the cost of licensing may be prohibitive.  Alternative methods for standby databases, real time logical database propagation, and real time replication to diverse platforms without sticker shock will be presented.  These are compatible with Standard Edition of Oracle, Standard One, or even Oracle XE – greatly reducing…

Flash disk and/or SSD technology options have been creeping into Oracle database deployments more and more. Oracle ACE Bert Scalzo will present the many and significantly different alternatives for utilizing flash disk and/or SSD in Oracle deployments. Moreover Oracle 11g and 12c features supporting or best utilizing such flash will be reviewed. Knowing what's out…

There's been a lot of buzz about Oracle 12c's new IN MEMORY COLUMN STORE. Oracle ACE Bert Scalzo will share experience and conclusions from benchmarking this new feature against more traditional SGA memory allocations and 11g Database Smart Flash Cache. The findings, scripts and conclusions from this exercise will be shared. Benchmarking Oracle 12c IN MEMORY COLUMN STORE Benchmarking…

Oracle Advanced Analytics Option extends the Oracle Database to a powerful and scalable “big data” predictive analytics platform. Oracle Advanced Analytics provides 15 high performance scalable SQL data mining functions that help companies deliver fast predictions and insights that can keep pace with their growing big data environment. By moving data mining algorithms to run…