Well, that was a nice start to the day! Someone came up to me just before Wolfgang Breitling’s presentation to point out that something from my presentation had helped him fix a problem at work last night. It was the OEM Raw Data drill-down that shows you the underlying ASH data for sessions, including backgrounds. [...]
Have you ever had the experience that Oracle Warehouse Builder (OWB) Client becoming extremely slow after you create a bulk of objects or import a huge project into the repository? If the answer happens to be yes, maybe next time you can try one of the tools OWB Design Client comes with, Optimize Repository. [...]
Now that Oracle Database 11g Release 2 is out, more and more folks are considering upgrading to 11g. However, if you are currently on Oracle 9i then you will have to tackle both the upgrade to a new release and the migration from the Rule-Based Optimizer (RBO) to the Cost-based Optimizer (CBO). The RBO was [...]
Have you ever had the experience that Oracle Warehouse Builder (OWB) Client becoming extremely slow after you create a bulk of objects or import a huge project into the repository? If the answer happens to be yes, maybe next time you can try one of the tools OWB Design Client comes with, Optimize Repository. [...]
Access operating system command output from SQL or PL/SQL – Ask Tom Suppose I want to get some information from the output from an operating system command, and use that information in a SQL statement. Is there a way to do that totally within SQL? Controlling DBA activities – Ask Tom Most DBA's should not [...]
Introducing Nitin Ramesh In this article, I would like to introduce Nitin Ramesh, an associate consultant with Oracle GSD India, Bangalore. This is the first time that I am having another Oracle Employee and co-worker publish articles on this blog, and I am excited. We solve many problems every for our ~35 customers on a [...]
Post Upgrade Performance Pangs.. After a 10g upgrade of production 11.5.9 Oracle Application instances, one of our clients was seeing some performance problems relating to pricing, particularly with a custom concurrent program called XXONT_PROGRESS_NOTIFIED. This triggered the onsite Senior DBA, Brian Fane , into action. While watching the current executing sqls of this job, this [...]
Another good day although it didn’t go quite as I planned it, but that’s part of the fun of a good conference. Should I mention at this point that I have a cold? I certainly noticed it this morning I got moving eventually and my first session was "The Life of a Query" with Jonah [...]
Mark and Venkat have already been blogging about OWB 11g Release 2, but that was not the only new release to slip past Oracle’s doors in recent days; 11g Release 2 of the database is also out. I have long loved analytic functions in Oracle – they can give a simple way to avoid sub-queries [...]
Hi Tom, I have done the following <code>create table sql_statement(sqlid integer, sqlstmt clob, isselect varchar2(1)) begin insert into sql_statement(sqlid, sqlstmt, isselect) values(1, ‘insert into dept(deptno, dname) values(:1,:2)’, ‘N’)… Link to the original site