• March 28, 2006 28 Mar'06

    Intermittent dblink error for insert

    An intermittent Oracle dblink error for an insert is occuring early in the week. After it generates an error, it starts working again on its own after the error occurs. I don't know if this is affecting the dblinks, but a cold Oracle backup occurs ...  Continue Reading

  • March 28, 2006 28 Mar'06

    Cause of ORA-01830 error

    I have two users who are getting the error "ORA-01830: date format picture ends before converting entire input string." Looking at the output from the precompiler, the code looks correct. My only assumption is that the strings comprising the date ...  Continue Reading

  • March 27, 2006 27 Mar'06

    Slow "create table" statement

    I have two servers; one is Oracle on Unix, the other is Oracle on Windows. I tried this SQL command: "create table xx as select * from table1@server2." This statement is very slow (43 seconds), but the query is very fast (0 to 1 ...  Continue Reading

  • March 27, 2006 27 Mar'06

    Database fully utilized with hang

    Our database is Oracle running on Linux AS 3.0. Our database is around 110GB and has 16GB RAM. Even though we have set the parameters in SGA_MAX_SIZE to 12G, shared pool size as 2G, db_cache as 4G and pga_aggregate as 800m (changed to ...  Continue Reading

  • March 24, 2006 24 Mar'06

    What happens when we fire a DML statement?

    I want to know when we fire a particular DML (delete) statement, what are the different activities that happen inside Oracle? For instance from user session to server session, then role of dbbuffer, redo buffer, and so on through redo log files and ...  Continue Reading

  • March 23, 2006 23 Mar'06

    When did Oracle begin implicitly closing cursors?

    In your response regarding cursor memory leaks, you said: "It used to be that if you did not close a cursor, that memory stayed allocated and unusable to anything else. This is no longer the case with Oracle." Do you know with what version Oracle ...  Continue Reading

  • March 23, 2006 23 Mar'06

    EXP-00056 and ORA-03113 errors

    Using exp80 for Oracle8 release on WinNT, Full=Y. This command did not cause any problem until a few days ago, when I encountered problems whereby not all tables were exported. I got these errors: "EXP-00056: ORACLE error 3113 encountered"...  Continue Reading