I went to the UK OUG Conference for the first time around 12 years ago, in 2003 if I remember correctly. I enjoyed all the presentations but the two which stuck in my mind were by Jonathan Lewis and Connor McDonald.
This year I will be chairing 8 sessions there, which means I will be introducing the speaker and making sure nothing goes wrong.
Two of these sessions are on 6th December 2015, which is (more...)
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 was asked to run some SQL today and it generated an ORA-01440. I did not remember having seen this error before so I decided to check it out in an Oracle 11.2 database. First I created a table and added a row of data to it:
SQL> create table tab1(col1 number)
SQL> insert into tab1 values(1)
1 row created.
I tried to run a utlrp in an Oracle 184.108.40.206.0 database and saw the errors below:
ORA-12801: error signaled in parallel query server P035
ORA-00018: maximum number of sessions exceeded
ORA-06512: at "SYS.UTL_RECOMP", line 629
ORA-06512: at line 4
I checked the number of sessions in v$session but there were not very many:
SQL> select count(*) from v$session;
I exported 3 large tables from an Oracle 220.127.116.11.0 database then tried to import them into an Oracle 18.104.22.168.0 database but the impdp failed as follows:
PQECOG3 /database/DB_exports/andrew > impdp / parfile=params
Import: Release 22.214.171.124.0 - 64bit Production on Wednesday, 22 July, 2015 11:37:44
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition (more...)