Home » RDBMS Server » Performance Tuning » how to specify priority of active sql sessions running in the database (Oracle database 10 g,Windows 2000 professional)
how to specify priority of active sql sessions running in the database [message #295526] Tue, 22 January 2008 09:52 Go to next message
psaraj12
Messages: 1
Registered: August 2007
Junior Member
hai everyone,
i need a command or a query to specify what session should be running in the database and the priority of the session.let me explain with an example.

I have a session 1 in which Query A which is
"select * from customer_data"
is running which is running using 60% of the database.
I have another session 2 in which Query B which is
"update vendor_data set vendor_id='SD1234' where product='ICE' but which is running at low priority at the database.

Now what i want is session 2 to be put on high priority in the database so that it runs and get processed before session 1 so that i can be sure that Query B runs before Query A in the database.

Thanks everyone in advance.
Re: how to specify priority of active sql sessions running in the database [message #295531 is a reply to message #295526] Tue, 22 January 2008 10:15 Go to previous message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no priority in Oracle.

Regards
Michel
Previous Topic: Performance issue
Next Topic: Sparodic database slowness
Goto Forum:
  


Current Time: Tue Dec 06 04:39:04 CST 2016

Total time taken to generate the page: 0.12789 seconds