In previous post I gave the details of how you can use Regression in Oracle Data Miner to predict/forecast the lean of the tower in future years. This was based on building a regression model in ODM using the known lean/tilt of the tower for a range of years. In this post I will show you how you can do the same tasks using the Oracle Data Miner functions in SQL and PL/SQL. Step 1 – Create the table and data The easiest way to do this is to make a copy of the PISA table we created in the previous blog post.
As part of a recent project to remove a vulnerability in relation to CVE-2012-1675 it became apparent that there are certain misconceptions around dynamic and static listener registration which are hard to get rid of. The below is applicable for single instance Oracle only!
Now let’s start with a quiz: what does the following output imply:
Back-story: A developer came to me and wanted explanation for a weird behavior in MySQL. They inserted a record (to InnoDB table), committed, and after receiving a message (on another application) tried to read that inserted record immediately, but the newly inserted record was not found. Problem only happened in production, but not always (quite frequently).
Recently I encountered this error while doing a GoldenGate replication from an Oracle 11g R2 source database to an Oracle 10g R2 target database.
ERROR OGG-01389 File header failed to parse tokens. File /u01/app/goldengate/dirdat/gv000000, last offset 915, data: 0x
Reading the GoldenGate documentation I came across this section which read:
One of the first tasks most Database Administrators (DBA) focus on when looking at implementing a Disaster Recovery (DR) solution, is getting a physical standby database implemented. With products such as Dbvisit Standby this can be done quickly and the DBA will be able to have a standby database ready within a short period of [...]
Recently i had faced “ORA-06553: PLS-306:” error while taking an export using expdp for table using “query” parameter. $ expdp directory=TEST_DPUMP_DIR dumpfile=test_url.dmp logfile=test_url.log tables=anand.test_delete_objects query=\"WHERE processed_flag = 'Y'\" Export: Release 220.127.116.11.0 - Production on Tue May 29 00:24:25 2012 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
“Sometimes you want to go Where everybody knows your name And they’re always glad you came. You wanna be where you can see Our troubles are all the same; You wanna be where everybody knows Your name.” —Theme song from the “Cheers” TV series (YouTube link) Name the winners shown in this picture from the 2008 NoCOUG [...]