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...)
I mentioned this class earlier in a blog post but I wanted to remind people who read this blog that the class is starting again on Wednesday. Here is the URL for the class: link
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
||Monday Oct 26
||Tuesday Oct 27
||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
||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 188.8.131.52 databases in test and production environments. The one thing that has been consistent is the issue I keep seeing (more...)
The article/blog is published on my company website… Improve Performance using Oracle Smart Flash Cache
August 23, 2015 (Back to the Previous Article in this Series) I started using Linux in 1999, specifically Red Hat Linux 6.0, and I recall upgrading to Red Hat Linux 6.1 after downloading the files over a 56k modem – the good old days. I was a little more wise when I upgraded to another […]
This post is for some of you who are planning to upgrade to 12c.I worked on upgrading single instance database from 184.108.40.206.13 to 220.127.116.11.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.
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - (more...)
I wrote a few months ago about having a play with Windows 10 (here).
I’m visiting family today, catching up on all the Windows desktop (and mobile phone) support that I missed while I was away.
I purposely postponed the Windows 10 update on the desktops before I went away, but now I’m back I did the first of them.
The update itself was fine, but it did take a long time. Nothing (more...)
For those of you lucky enough to live on the western half of Australia, I’ll be presenting at a couple of events in both Perth and Adelaide in the coming weeks. On Wednesday, 9th September 2015, I’ll be presenting on Oracle Database 12c New Features For DBAs (and Developers) at a “Let’s Talk Oracle” event […]
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. Even if a DML on that table is not going affect any rows, you still wont be able to issue it. For example,
SQL> delete from T where 1=0;
delete from T where 1=0
ERROR at line 1:
ORA-04098: trigger 'TRG' (more...)
Today’s Messed-Up App of the Day is the “Crux CCH-01W rear-view camera for select 2007-up Jeep Wrangler models.”
A rear-view camera is an especially good idea in the Jeep Wrangler, because it is very difficult to see behind the vehicle. The rear seat headrests, the wiper motor housing, the spare tire, and the center brake light all conspire to obstruct much of what little view the window had given you to begin with.
The Increasing Complexity of the IT Tech Stack Will Drive the Need for Robotic Automation
I’ve been involved in database technologies for 20 years now. During that time, I have read numerous prognostications from various industry pundits proclaiming that the next release of so-and-so database would be so simple to administer that the product would no longer require DBAs for support. Replace “database” with any technology, and you’ll find that the same industry mantra occurs.