OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » CONCURRENCY

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

CONCURRENCY [message #156333]

Tue, 24 January 2006 14:10

nitin_228
Messages: 29
Registered: May 2005
Location: RICHMOND, VA

Junior Member

I have a table(statement) which is doing heavy select on other tables.

In another transaction i have to change the grants on all those tables which are being selected in first transaction above.

I want to know that by running my second transaction would my first transaction fail and if it would then why?

Report message to a moderator

Re: CONCURRENCY [message #156543 is a reply to message #156333]

Wed, 25 January 2006 11:49

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

If the grants were required to do the select in the first place then the select would fail if the grants had not been issued. But generally speaking, you can run many statements and activities concurrently in oracle without problems.

Report message to a moderator

Re: CONCURRENCY [message #156550 is a reply to message #156333]

Wed, 25 January 2006 13:00

nitin_228
Messages: 29
Registered: May 2005
Location: RICHMOND, VA

Junior Member

Thanks that is what i thought and that is how it
worked fine when i did it.

Report message to a moderator

Previous Topic:	default temporary table space
Next Topic:	TABLESPACE MANAGEMENT

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 15:51:32 CST 2025