OraFAQ Forum: Performance Tuning » how to specify priority of active sql sessions running in the database

Home » RDBMS Server » Performance Tuning » how to specify priority of active sql sessions running in the database (Oracle database 10 g,Windows 2000 professional)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to specify priority of active sql sessions running in the database [message #295526]

Tue, 22 January 2008 09:52

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.

Report message to a moderator