• April 19, 2006 19 Apr'06

    RMAN-10038 error

    My RMAN connection fails intermittently with error RMAN-10038. The command I used is "rman target sys/xxxx@production catalog rman/xxxx@rman."  Continue Reading

  • April 19, 2006 19 Apr'06

    Database crashing after upgrade

    On Sunday I did an upgrade from Oracle7 to Oracle9. Monday the database switches one log at 12:18 and one checkpoint happens at 14:21. Tuesday the database switches one log at 8:51 and one checkpoint at 10:55. At 15:22 the database crashes. The ...  Continue Reading

  • April 19, 2006 19 Apr'06

    Are offline backups a waste of time?

    We combine offline/online backups in our Oracle9i backup/recovery solutions. Many of my colleagues feel offlines are a waste of time. I disagree. I do feel our offline intervals can be relaxed. The research I have done up to this point really does ...  Continue Reading

  • April 19, 2006 19 Apr'06

    Importing 8i dump to 9i

    How can I import an Oracle8i database dump to Oracle9i?  Continue Reading

  • April 19, 2006 19 Apr'06

    Questions about DBA career

    I am trying to get an Oracle DBA certification and I need your help. How would I be marketable with DBA cerification? How would I obtain the necessary skill set? What is the entry-level wage? What is the long-term outlook for this position? What is ...  Continue Reading

  • April 18, 2006 18 Apr'06

    Temp space usage increases when query includes view

    I run a query which joins four to five tables (it includes views). When the query is run without a particular view the query runs fine, but when we include that view the temp space usage by the query increases rapidly.  Continue Reading

  • April 18, 2006 18 Apr'06

    Execution time increases with packaged code

    I've created a package that moves data from one schema to another. Within the stored procs are insert statments that move the data. If I copy the data to the target schema and then run the insert statements, they execute much faster than moving the ...  Continue Reading

  • April 18, 2006 18 Apr'06

    What session is consuming the tablespace?

    My users are filling up the UNDO tablespace and TEMP tablespace whenever they run a process which takes up to approximately six hours. This process spans several sessions (from WebLogic Server), uses a lot of global temp tables, types, etc., from ...  Continue Reading

  • April 18, 2006 18 Apr'06

    Package slow after upgrade

    Our database was recently upgraded from Oracle 8.0.6 to, just before I started to work here. They have a package with a maximum of 32 input report parameters that was working very well under the 8.0.6 version and that is now extremely slow,...  Continue Reading

  • April 13, 2006 13 Apr'06

    Deleting Parent and Child rows

    I have two tables (Parent and Child) containing millions of records. I want to delete some rows (106 rows) from both tables. Which is the best approach to do this? I have dropped a foreign key constraint before deleting rows from Parent. But when...  Continue Reading