"Let me try once more," he said in an effort to explain. "In other words--" "You mean you have other words?" cried the bird happily. "Well, by all means, use them. You're certainly not doing very well with the ones you have now." - Norton Juster, The Phantom Tollbooth
A seemingly constant battle in many forums is getting those who post questions to be clear in what they are asking. Some questions are (more...)
I wrote about this feature in Hebrew quite some time ago but in the last week I was asked by couple of my customers about the correct way to move datafiles with minimal downtime so I thought it would be nice to show the Oracle 12c solution before talking about the solution I gave them.
For years, moving datafiles was a pain in the DBA behinds. It required some database action, then some OS actions (more...)
Just a quick post today as I wanted to highlight a video that has been made available by one of my colleagues, Valentin Tabacaru. Valentin is a sales consultant based out of one of our Spanish offices. The
YouTube video shows a SQL Performance Analyzer execution and report generation using real world workload testing between On Premise Oracle 11gR2 Database and Oracle Public Cloud 12c Pluggable Database Service. Both environments are managed using EM12c providing (more...)
Following on from my earlier comments about how a truncate works in Oracle, the second oldest question about truncate (and other DDL) appeared on the OTN database forum – “Why isn’t a commit required for DDL?”
Sometimes the answer to “Why” is simply “that’s just the way it is” – and that’s what it is in this case, I think. There may have been some historic reason why Oracle Corp. implemented DDL the (more...)
As always, installations of Oracle server products on Fedora are not a great idea, as explained here.
I was reading some stuff about the Fedora 23 Alpha and realised Fedora 22 had passed me by. Not sure how I missed that.
Anyway, I did a run through of the usual play stuff.
Just a quick note to say Oracle Midlands Event #11 is nearly here.
Oracle Midlands : Event #11 was first posted on August 25, 2015 at 2:36 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.
The old question about truncate and redo (“does a truncate generate redo or not”) appeared on the OTN database forum over the week-end, and then devolved into “what really happens on a truncate”, and then carried on.
The quick answer to the traditional question is essentially this: the actual truncate activity typically generates very little redo compared to a full delete of all the data because all it does is tidy up (more...)
In the previous post, I mentioned that for a programming environment fetching rows from the database, then the method of
- open a ref cursor
- issue a fetch call
- close the ref cursor
might not be appropriate for those situations where the result set is known be a single row (eg primary key lookup).
A better option might be to call a procedure and get those outputs as parameters.
And I broke a cardinal rule… (more...)
In various programming environments, a common metaphor is to open a cursor on the database (a REF CURSOR in Oracle parlance), return that cursor handle to the calling environment, and then that cursor is used to fetch or “fill” a data object, which may map to a grid on screen, or just to an array in memory.
And that’s totally fine – its an effective means to obtain a result set from the database to (more...)
Back on August 7th, the RMOUG’s Quarterly Education Workshop, I walked everyone through using a Pibrella board to create an art or flyer project that was powered with a python script and a motor.
Today, we’re going to take that same code and reuse it with a simple robotics kit to control power and rotation speeds/time to the Insectoid. This kit, puchased from the Go! store in Flat Irons Crossing mall, was $16 and can (more...)
The class is completely free and taught at a very high level of quality.
It teaches computer science concepts that apply in any programming language but also teaches Python programming.
It is valuable information in the increasingly computer oriented world (more...)
Agenda for Oaktable World 2014, located at Creativity Museum, is
|time||Monday Oct 26||Tuesday Oct 27|
|9||Mark W. Farnham – Minimizing the concurrency footprint of transactions with Logical Units of Work stored in PL/SQL||Kyle Hailey – Virtual Data|
Kerry Osborne – SQL Translation Framework
|Kellyn Pot’Vin-Gorman, AWR Warehouse Trending and Analysis with OBIEE|
|11||Greg Rahn – Taming JSON with SQL: From Raw to Results||
Marco Gralike – Improving XML performance (more...)
SELECT hou.NAME,fpov.profile_option_value org_id,frv.responsibility_name, d.full_name,a.USER_NAME, b.START_DATE,b.end_date
FROM apps.hr_organization_units hou,
apps.fnd_responsibility_vl frv,apps.FND_USER a,apps.FND_USER_RESP_GROUPS_all b,apps. per_all_people_f d,apps.FND_RESPONSIBILITY_TL res
fpov.level_value = frv.responsibility_id and b.responsibility_id = res.responsibility_id
and a.USER_ID=b.USER_ID and b.RESPONSIBILITY_ID=frv.RESPONSIBILITY_ID and a.employee_id=d.person_id
AND fpo.profile_option_id = fpov.profile_option_id
AND fpo.user_profile_option_name = ‘MO: Operating Unit’
AND fpov.profile_option_id (more...)
I’ve been doing some Enterprise Manager installs a bit more lately. At the same time, I’ve been working on Data Integration items such as GoldenGate and ODI. What these products have in common are that they require an Oracle Database for a repository. Needless to say I’ve been installing a lot of 184.108.40.206 databases in test and production environments. The one thing that has been consistent is the issue I keep seeing (more...)
This post is for some of you who are planning to upgrade to 12c.I worked on upgrading single instance database from 220.127.116.11.13 to 18.104.22.168.3, so thought to share my experience.
From 12c catupgrade.sql has been deprecated and Oracle has introduced catctl.pl script for upgrade. With catctl.pl script Oracle tries to perform as much work as possible in parallel, therefore minimizing downtime for upgrade.
Just a reference to source and my version of the script.
This is for restore since there are OUTPUTS.
Script to monitor RMAN Backup and Restore Operations (Doc ID 1487262.1)
$ sqlplus / as sysdba @mon_rman_restore.sql SQL*Plus: Release 10.2.0.4.0 - Production on Sun Aug 23 01:14:31 2015 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - (more...)