Home » RDBMS Server » Performance Tuning » row_locking
row_locking [message #271361] Mon, 01 October 2007 07:49 Go to next message
enkhbold
Messages: 36
Registered: July 2005
Location: Mongolia
Member


Is ROW_LOCKING available in Oracle 10g?
Re: row_locking [message #271362 is a reply to message #271361] Mon, 01 October 2007 07:50 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Yes, row locking is the default behaviour in all Oracle database versions. Why do you ask?
Re: row_locking [message #271369 is a reply to message #271362] Mon, 01 October 2007 08:04 Go to previous messageGo to next message
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.
Re: row_locking [message #271372 is a reply to message #271369] Mon, 01 October 2007 08:07 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
You need to unlock the locked accounts:

select username, account_status from dba_users;


alter user ... account unlock;
Re: row_locking [message #271374 is a reply to message #271372] Mon, 01 October 2007 08:12 Go to previous messageGo to next message
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"
Re: row_locking [message #271377 is a reply to message #271374] Mon, 01 October 2007 08:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: row_locking [message #271381 is a reply to message #271377] Mon, 01 October 2007 08:36 Go to previous messageGo to next message
Frank Naude
Messages: 4502
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.
Re: row_locking [message #271394 is a reply to message #271381] Mon, 01 October 2007 09:08 Go to previous messageGo to next message
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?
Re: row_locking [message #271398 is a reply to message #271394] Mon, 01 October 2007 09:44 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Obsolete means that it's not being used anymore.

Also see http://www.orafaq.com/parms/parm1759.htm
Re: row_locking [message #271399 is a reply to message #271398] Mon, 01 October 2007 09:46 Go to previous message
Frank Naude
Messages: 4502
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.
Previous Topic: How to Best Performance Param of Oracle in Windows
Next Topic: Explain Plan
Goto Forum:
  


Current Time: Sun Dec 04 08:51:46 CST 2016

Total time taken to generate the page: 0.09905 seconds