(Lucas Jellema) Automated environment provisioning and use of virtualization isolate environments is a topic that has become quite important to me – and to many others. From virtual machine technology, such as VMWare, VirtualBox and Oracle VM, to more recently the use of container technology and esp
Tag: Oracle
Monitoring RMAN Operations
(mdinh) Just a reference to source and my version of the script.
Use an object in a query?
(Michael McLaughlin) Using an Oracle object type’s instance in a query is a powerful capability. Unfortunately, Oracle’s SQL syntax doesn’t make it immediately obvious how to do it. Most get far enough to put it in a runtime view (a subquery in the FROM clause), but then they get errors like this:
First steps with provisioning of Docker containers using Vagrant as provider
(Lucas Jellema) Automated environment provisioning and use of virtualization isolate environments is a topic that has become quite important to me – and to many others. From virtual machine technology, such as VMWare, VirtualBox and Oracle VM, to more recently the use of container technology and esp
Job Frequency with DBMS_SCHEDULER and SQL Developer
(Jeff Smith) I was remarking to someone this morning how easy I thought it was to setup a job, say on the first and third Wednesday of the month. The flexibility of DBMS_SCHEDULER, even without taking into account the power of schedules, is really powerful.
Avoiding public embarrassment with triggers
(connormcdonald) If you create a trigger that does not compile, any part of your application that refers to the table with the invalid trigger is basically dead until that trigger becomes valid.
Memory added based on buffer pool advisory did not give desired result
(Bobby Durrett) Development asked me to look at ways to cut the run time of a series of PeopleSoft payroll batch jobs so I took an AWR report of the entire 4 hour period. Based on the waits, the percentage of the elapsed time spent using I/O and the buffer pool advisory I chose to double the size o
Job Frequency with DBMS_SCHEDULER and SQL Developer
(Jeff Smith) I was remarking to someone this morning how easy I thought it was to setup a job, say on the first and third Wednesday of the month. The flexibility of DBMS_SCHEDULER, even without taking into account the power of schedules, is really powerful.
Avoiding public embarrassment with triggers
(connormcdonald) If you create a trigger that does not compile, any part of your application that refers to the table with the invalid trigger is basically dead until that trigger becomes valid.
Memory added based on buffer pool advisory did not give desired result
(Bobby Durrett) Development asked me to look at ways to cut the run time of a series of PeopleSoft payroll batch jobs so I took an AWR report of the entire 4 hour period. Based on the waits, the percentage of the elapsed time spent using I/O and the buffer pool advisory I chose to double the size o