• March 30, 2006 30 Mar'06

    Blue Shield cleans up HR with Oracle-PeopleSoft HCM

    Blue Shield of California deployed Oracle's PeopleSoft Enterprise Human Capital Management 8.9 to automate transactions, centralize IT and modernize its HR department.  Continue Reading

  • March 29, 2006 29 Mar'06

    Best approach for resizing SGA

    What is the best approach for resizing the SGA? I have a Solaris Server with 8 gigs of RAM with three databases on the server. Is there a formula for how to configure the SGA?  Continue Reading

  • March 28, 2006 28 Mar'06

    Defining object classes in C++

    Can I define object classes and tables from the object classes for use with OCCI in C++, which contain character strings, binary integers and binary floating point numbers, and which will be initialized and saved from the C++ program, but can also ...  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

    Improving performance of inserts

    First we read records from three different tables and insert into a temp table. From the temp table I fetch the records one by one, do some calculations and insert into another table if the record is new. If it already exists then I update the ...  Continue Reading

  • March 27, 2006 27 Mar'06

    Slow for loop cursor

    I have three tables, A, B and C. Table A has 450,000 records, and B has 80,000. I have created a for loop cursor on table A and check B in that loop. If a record is found in B then I want it to be inserted in table C. But I waited eight hours for ...  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

    SQL for joining two tables

    What is the SQL statement that can be used to join two tables?  Continue Reading

  • March 24, 2006 24 Mar'06

    Exporting 9i users/tables using 10g's exp utility

    Is there any way of exporting Oracle9i database users/tables using Oracle 10g's exp utility?  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

    ORA-00904 with database link

    I've created a database link between a 9i and 8i database. It works but the same SQL in a PL/SQL block fails with "ORA-00904 : COL4 : identificateur non valide."  Continue Reading

  • March 23, 2006 23 Mar'06

    Database starts and mounts but doesn't open

    I had to do an install in order to work on my Oracle application. I basically had created a database OCTRN a month back. I also have a repository of the database but not sure why. When I tried to automatically start , mount and open the database, I...  Continue Reading

  • March 23, 2006 23 Mar'06

    Determining a query's response time

    How do we determine a query's performance (response time)? Can you please tell me the steps?  Continue Reading