All in all Nice read though…Thanks…

Thank you for your comment. I didn’t do the 10046 trace myself, but probably I try to do it soon and post the results here.

It surprised me that there is such a difference between versions. Anyway any comments are welcome.

Regards, Gerwin

If you check the table itself by create test_dual as select * from dual you will see added rows in both versions of Oracle (11GR1 11GR2) but when you do 10046 trace, you will see that steps before dropping table on 11GR2 are different than versions before 11GR2. Looks like Oracle changed the logic.

block_row_dump:
tab 0, row 0, @0×1f9b
tl: 5 fb: –H-FL– lb: 0×1 cc: 1
col 0: [ 1] 58
tab 0, row 1, @0×1f96
tl: 5 fb: –H-FL– lb: 0×2 cc: 1
col 0: [ 1] 41
end_of_block_dump

When checking the values:
select chr(88) from dual; –> X — hex 58 (first row)
select chr(65) from dual; –> A — hex 41 (second row)

I think, it might be very interesting what is in the blocks of the 11GR2 database. I would like to know if the insert is not done or that it does something else.

Regards, Gerwin

I tested on 11gR2 ,,, no error…

11gR1:

SQL> insert into dual values (’A');

1 row created.

SQL> drop table xxx;
drop table xxx
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows

11gR2:

SQL> insert into dual values (’A');

1 row created.

SQL> select * from dual;

D
-
X

SQL> drop table xxx;

Table dropped.

Is there anyway from SQL to monitor the use of Self Service? For example, fnd_login_responsibilities only tracks form responsibility logins in 11.5.10.2.

Thanks again.
Logan 5

What blog virus did you refer to

LOL