Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bcbcheng

    Error LNK2005 & LNK2001

    I am writing a C++ program, and the program will call some C library ( haval.h, haval.c ). However, it prompt the following error while i try to compile the program. Would anyone kindly give me a hand ? nafxcwd.lib(afxmem.obj) : error LNK2005: "void * __cdecl operator new(unsigned...
  2. bcbcheng

    ORA-00604 error occurred at recursive SQL level 1

    My company is writing some java program , and use JDBC to execute SQL statment. However, somtimes the java program will throw an exception with this message : "ORA-00604: error occurred at recursive SQL level 1. Can anyone tell me what is recursive SQL ?
  3. bcbcheng

    SQL Optimization : Rule Based Vs Choose Based

    Yes, of course I have analyze table. I use the following commands for each table :<br><br>ANALYZE TABLE [Table Name ] COMPUTE STATISTICS FOR TABLE ;<br>ANALYZE TABLE [Table Name ] COMPUTE STATISTICS FOR ALL INDEXES ;<br>ANALYZE TABLE [Table Name ] COMPUTE STATISTICS FOR ALL COLUMNS...
  4. bcbcheng

    SQL Optimization : Rule Based Vs Choose Based

    When u try to optimize a SQL statement, which one u will choose ? <br>In my case, my SQL statement always join with 4 - 7 tables ( UNION appears 3 times for each SQL statement ). When I choose Choose-based, the showplan show that some tables use index scan, and 1 or 2 tables use full table scan...
  5. bcbcheng

    Archive Problem

    I am new to Oracle, and have very limited concept on it.<br>I have created 2 Rollback Segnment for my Oracle DB, and each of the segment is associated with individual tablespace.<br>After that, I observed that these tablespace grows and increase in size every day. <br><br>My questions is :<br>1...
  6. bcbcheng

    Archive Problem

    When I did some bulk insert SQL statement, sometimes later the Oracle server is hang, and the following message appear on the console:<br><br>Warning - The following error occured during ORACLE redo log archival :<br>Oracle Instance hhcl - Can not allocate log, archival required.<br>Press to...
  7. bcbcheng

    Performance Issue on small table

    Thanks a lot
  8. bcbcheng

    Performance Issue on small table

    I am new to Oracle, and have no knowledge on it. <br>I have a small system, in which only 2 tables get over<br>10000 records. However, when I writing SQL to retrieve <br>data ( join from 4 or 5 table ). It takes around 15 <br>minutes to retrieve the date ( around 4000 records will <br>be...

Part and Inventory Search

Back
Top