Home » RDBMS Server » Performance Tuning » Error 942 happened during loading of queue
Error 942 happened during loading of queue [message #65911] Sat, 29 January 2005 06:33 Go to next message
Vivek Vijai
Messages: 67
Registered: April 2004
Hi, i was getting the error
"kwqiclode: Error 942 happened during loading of queue"

in the Alert log very frequently(almost very minute).

I checked the trace file it showed

"Error 942 in Queue Table QS.QS_ORDERS_PR_MQTAB"

I checked the table that was used by a view QS.AQ$QS_ORDERS_PR_MQTAB
and the view was refrerring another table QS.AQ$_QS_ORDERS_PR_MQTAB_S which doesnt exists
in the database so i created the table(copied structure from another instance)
and recompiled the view now i am not getting this error.

Can anyone tell me whats the meaning of the above error and whats the purpose
of above view and for what the user QS is used.
Is it related to Locking on tables as initially there was too much locking
showed in OEM but now it has reduced.

Please let me know its very urgent for me

Thanks in advance

Re: Error 942 happened during loading of queue [message #65913 is a reply to message #65911] Mon, 31 January 2005 06:15 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I beleive, you are talking about the QS* schemas , that are installed along with seed database ( or database with all default options). If so, it just an sample schema, built and supplied by oracle for educational/demonstration purposes purposes.
You can remove them, if you dont need them. I beleive

$ORACLE_HOME/demo/schema/shipping/qs_drop.sql will gracely remove all the queing related schemas.
Previous Topic: Hidden Parameters .
Next Topic: Buffer Cache and Shared Pool
Goto Forum:

Current Time: Sat Mar 02 16:08:22 CST 2024