Skip to content

EvDBT

Evergreen Database Technologies, Inc.

Menu
  • About
  • Articles
  • Books
  • DBAKevlar
  • Papers/Presentations
  • Scripts
  • Videos

Tag: oracle

Azure host-caching with Oracle database workloads on Azure VMs

1 Comment
| azure, Oracle

There are almost 2,000 Azure customers running Oracle database workloads on Azure VMs, and that number is growing rapidly all the time.  Running Oracle on Azure is not the first idea to occur to many people, but it should be, as there are several types of VMs appropriate for Oracle workloads within Azure, as well […]

Read More »

Oracle dNFS on NFS v4.1

No Comments
| Uncategorized

If you search the Oracle Support website or the internet for information on Oracle’s direct NFS (dNFS), you’ll find a decent amount of useful information, including coded examples. However, if you look a little more closely, all of those examples show NFS v3.0 in use, and do not show examples using higher versions of NFS. […]

Read More »

Presentation “Real-Time SQL Tuning” at Hotsos Sym2014 and UTOUG TD2014

This presentation was delivered at the Hotsos Symposium 2014 and at the Utah Oracle Users Group (UTOUG) Training Days 2014. It describes a PL/SQL package that I put together called “ash_xplan.sql” which can be used to display real-time information about a SQL statement currently executing.  This package combines information from the Active Session History (V$ACTIVE_SESSION_HISTORY) […]

Read More »

ash_xplan_output.txt

Read More »

ash_xplan.sql

Read More »

rman_chk.sh

Read More »

run_awr.sh

Read More »

Presentation “Three Types Of Table Compression”

There are several different types of compression available in the Oracle database for compressing table data, and so the question must arise: which should be used, and when, for which purpose? This presentation will discuss all the different types of table data compression in Oracle database (i.e. basic/advanced de-duplication compression and hybrid-columnar compression), as well […]

Read More »

Paper “Three Types Of Table Compression”

There are several different types of compression available in the Oracle database for compressing table data, and so the question must arise: which should be used, and when, for which purpose? This presentation will discuss all the different types of table data compression in Oracle database (i.e. basic/advanced de-duplication compression and hybrid-columnar compression), as well […]

Read More »

Presentation “RDBMS Forensics – Troubleshooting Using ASH”

Arthur C. Clarke wrote that any sufficiently advanced technology is indistinguishable from magic, and it sometimes makes troubleshooting seem like magic, or perhaps art. But it is neither magic nor art; it is process and this presentation uses a case study, such as resolving the ORA-03136 “connection lost” error, to demonstrate that process and to […]

Read More »

Posts pagination

1 2 … 7 Next

About me

Recent Posts

  • Azure host-caching with Oracle database workloads on Azure VMs July 2, 2021
  • Oracle dNFS on NFS v4.1 June 17, 2021
  • Delphix XPP explained November 14, 2019
  • Oak Table World 2018 October 25, 2018
  • Achieving a balance December 1, 2017
  • Automating Stored Procedures When Refreshing Virtual SQL Server Databases October 31, 2017

Older posts…

Affiliations

EvDBT 2025 . Powered by WordPress