Tag: Database & Technology

Original Broadcast: Thursday, April 2, 2015 High performance databases built on Oracle Database 12c require advanced storage systems designed with database workloads in mind. Learn how Oracle ZFS Storage Appliance advanced in-memory architecture combined with unique co-engineered integration delivers superior performance, efficiency, and streamlined management, reducing database and storage footprint, complexity, risk, and total cost of…

Original Broadcast: Thursday, April 2, 2015 High performance databases built on Oracle Database 12c require advanced storage systems designed with database workloads in mind. Learn how Oracle ZFS Storage Appliance advanced in-memory architecture combined with unique co-engineered integration delivers superior performance, efficiency, and streamlined management, reducing database and storage footprint, complexity, risk, and total cost of…

This session discusses how to get the most of your RAC environment now, including ongoing best practices delivered via Automatic Healthchecks as well as the latest in tools that Oracle Support recommends for monitoring, diagnosing and preventing problems in your environment.   The session will go into Oracle's OraChk utility, with input on the team that…

This session discusses how to get the most of your RAC environment now, including ongoing best practices delivered via Automatic Healthchecks as well as the latest in tools that Oracle Support recommends for monitoring, diagnosing and preventing problems in your environment.   The session will go into Oracle's OraChk utility, with input on the team that…

This session discusses how to get the most of your RAC environment now, including ongoing best practices delivered via Automatic Healthchecks as well as the latest in tools that Oracle Support recommends for monitoring, diagnosing and preventing problems in your environment.   The session will go into Oracle's OraChk utility, with input on the team that…

This session discusses how to get the most of your RAC environment now, including ongoing best practices delivered via Automatic Healthchecks as well as the latest in tools that Oracle Support recommends for monitoring, diagnosing and preventing problems in your environment.   The session will go into Oracle's OraChk utility, with input on the team that…

A SQL statement that calls a PL/SQL function is slower than one that defines the same result by using only SQL expressions. The culprit is the SQL to PL/SQL round-trip. Its cost can be reduced by marking the function deterministic, by invoking it in a scalar subquery, by using the PL/SQL function result cache, or…

A SQL statement that calls a PL/SQL function is slower than one that defines the same result by using only SQL expressions. The culprit is the SQL to PL/SQL round-trip. Its cost can be reduced by marking the function deterministic, by invoking it in a scalar subquery, by using the PL/SQL function result cache, or…

A SQL statement that calls a PL/SQL function is slower than one that defines the same result by using only SQL expressions. The culprit is the SQL to PL/SQL round-trip. Its cost can be reduced by marking the function deterministic, by invoking it in a scalar subquery, by using the PL/SQL function result cache, or…

By addressing the database performance issues that are commonly caused by poorly performing storage, flash storage is poised to rapidly replace traditional hard drives in the enterprise data center for applications such as Oracle databases. In this webinar, we use examples to demonstrate how radically the database performance can be improved when using a Kaminario…