OraFAQ Forum: Performance Tuning » row

Home » RDBMS Server » Performance Tuning » row_locking

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

row_locking [message #271361]

Mon, 01 October 2007 07:49

enkhbold
Messages: 36
Registered: July 2005
Location: Mongolia

Member

Is ROW_LOCKING available in Oracle 10g?

Report message to a moderator

Re: row_locking [message #271362 is a reply to message #271361]

Mon, 01 October 2007 07:50

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Yes, row locking is the default behaviour in all Oracle database versions. Why do you ask?

Report message to a moderator

Re: row_locking [message #271369 is a reply to message #271362]

Mon, 01 October 2007 08:04

enkhbold
Messages: 36
Registered: July 2005
Location: Mongolia

Member

We are using Oracle 10g with RAC.
When we enquiry certain record by several users, gives an error "account is locked".
So, then i am looking ROW_LOCKING parameter into Oracle parameter. But nothing is appearing.

Report message to a moderator

Re: row_locking [message #271372 is a reply to message #271369]

Mon, 01 October 2007 08:07

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

You need to unlock the locked accounts:

select username, account_status from dba_users;

alter user ... account unlock;

Report message to a moderator

Re: row_locking [message #271374 is a reply to message #271372]

Mon, 01 October 2007 08:12

enkhbold
Messages: 36
Registered: July 2005
Location: Mongolia

Member

I am sorry, i have explained not in detail.

"account is locked" means "record is locked"

Report message to a moderator

Re: row_locking [message #271377 is a reply to message #271374]

Mon, 01 October 2007 08:17

Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

What do you mean "row/account is locked"?
How do you see that?

Regards
Michel

Report message to a moderator

Re: row_locking [message #271381 is a reply to message #271377]

Mon, 01 October 2007 08:36

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Yes, please provide more info. Oracle error messages, version numbers, why you are trying to do, any error in the alert.log file, etc.

Report message to a moderator

Re: row_locking [message #271394 is a reply to message #271381]

Mon, 01 October 2007 09:08

enkhbold
Messages: 36
Registered: July 2005
Location: Mongolia

Member

i am working on Oracle10g with cluster and data guard.

i have run next script.
select * from v$obsolete_parameter where name ='row_locking'

Result is:-
Name Isspecified
row_locking FALSE

is it Row_locking=INTENT?

Report message to a moderator

Re: row_locking [message #271398 is a reply to message #271394]

Mon, 01 October 2007 09:44

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Obsolete means that it's not being used anymore.

Also see http://www.orafaq.com/parms/parm1759.htm

Report message to a moderator

Re: row_locking [message #271399 is a reply to message #271398]

Mon, 01 October 2007 09:46

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

In Oracle 9i and below:

ROW_LOCKING =

INTENT - In addition to row locks, restricted table-level locks are acquired during UPDATE operations.

ALWAYS and DEFAULT - Row locks are acquired. Table locks are not acquired.

Report message to a moderator

Previous Topic:	How to Best Performance Param of Oracle in Windows
Next Topic:	Explain Plan

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 25 20:41:04 CDT 2024