(connormcdonald) I had an interesting AskTom question recently where the poster was using SQL Loader to load in tables, but wanted to be able to analyze the resultant log file after execution.
Tag: Oracle
Script: Inactive Parallel QC Holding Parallel Processes
(Zohar Elkayam) Working on a data warehouse system can be quite challenging, as I mentioned in the post from yesterday. One of the things we need to take care of is the amount of parallel processes that are in used at all times.
12cR1 RAC Posts — 8e : Redo Shipping and Apply (RAC to nonRAC)
(Hemant K Chitale) Continuing the series of posts on the RAC/ASM to SingleInstance/FileSystem DataGuard configuration …
Oracle Data Miner 4.2 New Features
(Brendan Tierney) Oracle Data Miner 4.2 (part of SQL Developer 4.2) got released as an Early Adopter versions (EA) a few weeks ago.
Creating a RAC 12.1 Data Guard Physical Standby environment (3)
(Martin Bach) In the previous two parts of this series you read about my lab environment and the preparations on the network side as well as the database. In this part I’ll cover the database duplication. Again, this won’t be a short post …
Setting A Logon Security Message In Oracle
(David Fitzjarrell) Security is the watchword for almost all businesses today, especially for computer systems and databases. For legal reasons, any ‘snooping’ the administrators may do on the users logged into such systems needs to be disclosed in a security banner.
Oracle Triggers – The Complete Guide
(Ben Brumm) Oracle triggers are a handy but often misused function of the Oracle database. Learn all about them in this article.
Temporal validity and open/closed intervals
(Kim Berg Hansen) A short while ago I created a SQL quiz for Oracle Dev Gym (PL/SQL Challenge) demonstrating the use of temporal validity and VERSIONS PERIOD FOR syntax to create a “change report” for changes in item prices.
12cR1 RAC Posts — 8d : Registering the two databases in DataGuard Broker
(Hemant K Chitale) Continuing my series on setting up a non-RAC, FileSystem Standby for a RAC, ASM Database….
Script: Finding Session With Downgraded Parallel Execution
(Zohar Elkayam) I was working with the data warehouse team at a customer site and at some point we realized that some parallel executions are not getting enough resources (downgraded).
