Yesterday i got wait event when executed simple select from table.
This select was like:
SELECT emp_number from employer where subs_id = 111
I got one row, select is very fast.
In our Core Bank System we have package with function which returns such information. I tested this select on test DB, and nothing wrong. But when I executed such select and package on Production DB, DB Admin saw that 88 sessions waits when
my session release the resource. But what can happen, it was simple select?
I used PL/SQL developer to get information from table:
1) SELECT emp_number from employer where subs_id = 111
2) Package with this function
Another users used Oracle Forms screen to execute package.
So question, How simple select statement could stop all DB?
|1||Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi|
|2||PL/SQL Release 10.2.0.5.0 - Production|
|3||CORE 10.2.0.5.0 Production|
|4||TNS for 64-bit Windows: Version 10.2.0.5.0 - Production|
|5||NLSRTL Version 10.2.0.5.0 - Production|
Oracle Forms information
Forms [32 Bit] Version 126.96.36.199.0 (Production)
Oracle Toolkit Version 188.8.131.52.31 (Production)
PL/SQL Version 184.108.40.206.1 (Production)
Oracle Procedure Builder V220.127.116.11.0 Build #1337 - Production
PL/SQL Editor (c) WinMain Software (www.winmain.com), v1.0 (Production)
Oracle Query Builder 18.104.22.168.0 - Production
Oracle Virtual Graphics System Version 22.214.171.124.0 (Production)
Oracle Tools GUI Utilities Version 126.96.36.199.10 (Production)
Oracle Multimedia Version 188.8.131.52.9 (Production)
Oracle Tools Integration Version 184.108.40.206.0 (Production)
Oracle Tools Common Area Version 220.127.116.11.0
Oracle CORE 18.104.22.168.0 Production