I created the following UNIX shell script called loop1.ksh:
Oracle 11.1 > cat loop1.ksh
sqlplus / as sysdba << eof
grant create session to andrew
identified by reid1
echo "User created"
./loop2.ksh > loop2.log1 &
./loop2.ksh > loop2.log2 &
./loop2.ksh > loop2.log3 &
./loop2.ksh > loop2.log4 &
./loop2.ksh > loop2.log5 &
This post is based on a problem I was asked to look at recently.
A colleague was using PL/SQL Developer to compare two tables in an Oracle 11 database. He was matching the rows on a key column then checking the corresponding values from a different column and reporting them if they did not match. His query returned almost 2000 rows but they appeared to have equal, not different values. Five people looked at (more...)
I noticed this in an Oracle 220.127.116.11.0 database. DBMS_STATS failed with an ORA-00600 and the first argument was . On investigation, it seemed to have something to do with the fact that the table had a function based index:
SQL> SELECT COUNT(*) FROM DBA_INDEXES