OraFAQ Forum: Server Administration » Range Partition --- Question regarding locking

Home » RDBMS Server » Server Administration » Range Partition --- Question regarding locking

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

Range Partition --- Question regarding locking [message #171489]

Wed, 10 May 2006 04:09

rkulasek
Messages: 15
Registered: April 2006

Junior Member

Hi

I am using range partition for a table. I will be submitting a scheduled job which will add partition at end of each month.
During this split partition, can I allow other processes to continue querying this table?
Or should I lock this table till my new partition is created?
Is there a provision to lock individual partition?

Basically I would like to ensure that no deadlock happens when my job is running and creating partition.

Thanks mch
Raja

Report message to a moderator

Re: Range Partition --- Question regarding locking [message #171641 is a reply to message #171489]

Wed, 10 May 2006 16:01

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

How many paritions are you trying to create ? If it is like 1, 2, ...6 etc., i dont think you need to worry at all ..also since you said the other session is only going to read the data there should not be any problem .unless that queries has "For Update" clauses in those .

-Sai Jeeigunta

Report message to a moderator

Re: Range Partition --- Question regarding locking [message #171668 is a reply to message #171489]

Wed, 10 May 2006 23:39

rkulasek
Messages: 15
Registered: April 2006

Junior Member

Thanks for the reply Sai.

I will have "n" partitions - one partition for each month.
When I create a new partition at the end of month, I want to ensure no deadlock happens.
In addition to queries, I will have inserts and updates also happening in parallel.
I expect this "create partition" to finish quickly. However, during this period, should I lock my partition ? I assume I can do something like ----> select * from mytable partition(mypartition) for update
Is this correct?

Thanks much
Raja

Report message to a moderator

Previous Topic:	Change to UTF8 character set
Next Topic:	V$ tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:28:51 CDT 2024