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…

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…

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…

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…

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…

There's been a lot of talk about the benefits of the new Multi-tenant functionality in Oracle 12c.  It all sounds great but where do you start if you understand the high-level concepts but haven't seen the actual pieces & commands?  What really are Container & Pluggable databases?  What components are shared between the two?  How…

There's been a lot of talk about the benefits of the new Multi-tenant functionality in Oracle 12c.  It all sounds great but where do you start if you understand the high-level concepts but haven't seen the actual pieces & commands?  What really are Container & Pluggable databases?  What components are shared between the two?  How…