Interested to Buy Any Domain ? << Click Here >> for more details...
Can some one tell me the ressolution for the error. I was not able to answer this question in wipro interview.
"The transaction exceeded the maximum number of rowhash locks allowed"
- 1 Answers
- 5566 Views
- Wipro, I also Faced
- E-Mail Answers
Answer / dotnetchampion
This error is returned when a transaction has exceeded the number of rowhash locks allowed. The threshold on the number of rowhash locks allowed is defined in DBSControl via the General field ’MaxRowHashBlocksPercent’. This is done so that one transaction does not fill up the lock table with rowhash locks. The number of control blocks/locks that can fit into an AMP lock table is defined by STDMAXLOCKBLOCKS which is currently ~51860.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is the structure of UV table in MLOAD?
Explain how spool space is used.
What is database exceptions in teradata?
What do you mean by tpt in teradata?
Explain teradata vs. Redshift?
How do you verify a complicated sql?
How does hashing happens in teradata?
What is a sparse index?
Increasing no of amps will increase performance. Is this true?
Why does varchar occupy 2 extra bytes?
What do high confidence, low confidence and no confidence mean in explain plan?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
Teradata 
