I've observed an oddity with Oracle 11g. Maybe if someone's experienced anything similar then they can provide some input -- it's got me stumped!
- PHP Application reads a file and insert rows into a db table with a 'run id' that is the same for all records inserted in the session (approx 2000 records inserted in a loop)
- In the same session (DB connection kept open), the same application selects the rows it just inserted using the same 'run id' column. There is an index for this column
- Only approx half the rows are returned by the select
- If I run the select later, from SQL*Plus (using the same sql statement as the application) all the rows are returned
The DB connection has 'autocommit' switched on. So that fries one of my theories. The only other thing I can think of is that for some reason the index wasn't populated in time - not sure if this holds water though.
Open to any ideas...