It’s no secret that proper usage of Global Temporary Tables (GTT’s) can result in tremendous performance improvement and dramatic resource usage reduction. This is because data for a GTT are stored in temporary segments and redo logs are not generated. Undo creation is minimized as well. Generally GTT’s are good for applications where there are…

It’s no secret that proper usage of Global Temporary Tables (GTT’s) can result in tremendous performance improvement and dramatic resource usage reduction. This is because data for a GTT are stored in temporary segments and redo logs are not generated. Undo creation is minimized as well. Generally GTT’s are good for applications where there are…

It’s no secret that proper usage of Global Temporary Tables (GTT’s) can result in tremendous performance improvement and dramatic resource usage reduction. This is because data for a GTT are stored in temporary segments and redo logs are not generated. Undo creation is minimized as well. Generally GTT’s are good for applications where there are…

This presentation will look at which new features should be investigated for use. Most of the features that will be covered will be related to the DBA, but there will also be a few outside that realm that focus on the developer. There will be simple examples (such as a quick example using pluggable databases)…

This presentation will look at which new features should be investigated for use. Most of the features that will be covered will be related to the DBA, but there will also be a few outside that realm that focus on the developer. There will be simple examples (such as a quick example using pluggable databases)…

When used locally on a database server, OS Authentication can be a secure and useful connection method. When that feature is extended to remote systems on a network, risks are introduced that are greater than intended. Additionally, this feature is deprecated as of Oracle 11g. This session will review the risks associated with Remote OS…

Oracle Materialized Views have been around through many versions of Oracle as a way to improve query performance or simply to offload data to a separate database for reporting purposes. If you have never implemented an Oracle Materialized View, find them somewhat of a mystery, or just want to build on your basic knowledge of…

Oracle Materialized Views have been around through many versions of Oracle as a way to improve query performance or simply to offload data to a separate database for reporting purposes. If you have never implemented an Oracle Materialized View, find them somewhat of a mystery, or just want to build on your basic knowledge of…

Oracle Materialized Views have been around through many versions of Oracle as a way to improve query performance or simply to offload data to a separate database for reporting purposes. If you have never implemented an Oracle Materialized View, find them somewhat of a mystery, or just want to build on your basic knowledge of…

Oracle Materialized Views have been around through many versions of Oracle as a way to improve query performance or simply to offload data to a separate database for reporting purposes. If you have never implemented an Oracle Materialized View, find them somewhat of a mystery, or just want to build on your basic knowledge of…