Sitemap

Amicuk Programming Answers

A lot of blocking locks on NRIV daily

2015-10-11   Views:10

Advertisement

Hi experts,   Our system has a lot of blocking locks on NRIV. I use DMV to check and find many processes update RF_BELEG frequently. I find note 840901 can solve using parallel buffering, but our FI users do not agree sale document number without con

Hi experts,
  Our system has a lot of blocking locks on NRIV. I use DMV to check and find many processes update RF_BELEG frequently. I find note 840901 can solve using parallel buffering, but our FI users do not agree sale document number without continuous chronological ascending order. Any solution from SAP or SQL server? Could SQL server parallel update NRIV table?

The replay answer
Advertisement
hi dennis,
this issue would be complicated since if you're not allowing your Apps server buffering NRIV than your SAP performance will decrease. this is because every transaction which require number need to be generated first every time your user save data to your SAP system.
This buffering technique is used to handle  this issue so if your Apps server do not need to ask new number every time your user save their transaction data.
i have same issue when our external (public) auditor ask me than i ask for SAP support and then they explain about this. when i explain this issue to my external auditor, they understand this issue and they said no problem as long as  this issue could be accepted.
ardhian
http://sapbasis.wordpress.com
http://ardhian.kioslinux.com

Go to See the other 4 answers

A lot of blocking locks on NRIV daily

Category:DefaultRelease time:2015-10-11Views:130

Hi experts,   Our system has a lot of blocking locks on NRIV. I use DMV to check and find many processes update RF_BELEG frequently. I find note 840901 can solve using parallel buffering, but our FI users do not agree sale document number without con[More]

SQL Timeouts and Blocking Locks

Category:DefaultRelease time:2015-10-11Views:130

SQL Timeouts and Blocking Locks Just wanted to check in and see if anyone here has feedback on application settings, ColdFusion settings, JBOSS settings or other settings that could help to limit or remove SQL Timeouts and blocking locks on SID's. We[More]

Monitoring blocking Locks

Category:DefaultRelease time:2015-10-11Views:130

Hi This question relates to monitoring blocking locks on a 9.2.0.5 2 node RAC Origionally I have been monitoring bocking locks with every 5 mins using the following query: "select * from dba_blockers" I have recently implemented monitoring via g[More]

Monitoring Blocking locks (dba_blockers vs v$lock)

Category:DefaultRelease time:2015-10-11Views:130

Hi This question relates to monitoring blocking locks on a 9.2.0.5 database Origionally I have been monitoring bocking locks with every 5 mins using the following query: "select * from dba_blockers" I have recently implemented monitoring via gri[More]

Using OleDbDataAdapter Update with InsertCommands and getting blocking locks on Oracle table

Category:DefaultRelease time:2015-10-11Views:130

The following code snippet shows the use of OleDbDataAdapter with InsertCommands.  This code is producing many inserts on the Oracle table and is now suffering from contention... all on the same table.  How does the OleDbDataAdapter produce inserts f[More]

Blocking Locks - What Was Likely Going On?

Category:DefaultRelease time:2015-10-11Views:130

I had a blocking lock yesterday that showed up in OEM under Cluster Database --> Cluster Database Locks. The blocking lock was a row exclusive (RX) table lock that was blocking 175 other sessions that were listed under the blocking lock as having req[More]

Blocking locks encountered while splitting partitions in 11g

Category:DefaultRelease time:2015-10-11Views:130

Background: I've taken over administration of a database that has several date-range partitioned tables that, suffering from a lack of proper administration, have not had their MAXVALUE partition split into the requisite monthly partitions, in almost[More]

Blocking locks by user report hangs

Category:DefaultRelease time:2015-10-11Views:130

Please, "Blocking locks by user" report under "Database Administration Section" of "Data Dictionary Reports" is hanging every time we try to run it against any database. Please, confirm this issue in Oracle Sql Developer 4.0[More]

Blocking Locks

Category:DefaultRelease time:2015-10-11Views:130

Oracle 9.2.0.8 Our database is used as backend for IIS Servers. Several times per week we experience Blocking locks situation when we could have around 300 – 400 session waiting. Most time when somebody fire up some Update or Delete process. Every ti[More]

Blocking Locks monitoring in 12c cloud control

Category:DefaultRelease time:2015-10-11Views:130

Ours is a 11.2 4 node RAC environment, and to check for blocking locks i run a sql script. I want to monitor the blocking locks in the system and if there are any locks for more than say 10 minutes then send out a mail to a group to look into it. We[More]

How to find out the reason for blocking locks?

Category:DefaultRelease time:2015-10-11Views:130

PB Application try to create data in ASE 12.5. With this operation, there are sql, sp, trigger involved. Most of the it is okay. With lock of sleeping or sync sleeping lock. User wait for a short time to get the result. but some time, there are block[More]

Hot
Morning all, I am having an issue with users logging out of Terminal Servers, and their profile directories won't empty/delete/cleanup because of residual FLASH data. I have multiple issues, but both amount to the "can't delete, too long" messag [More]
Totally new to PC here. Been a Macuser all my computer life, but needed a second computer for work. Not thrilled, but there it is. So, I'm wondering if the isight camera is PC compatible, and if so, how and what drivers do I install? Or do I just go [More]
Hi Friends,                         In my FM, i want to pass field symbol back to my main program for further use. How can i achieve the same.                         In my source code section of FM, FIELD-SYMBOLS: <t_dyntable> TYPE STANDARD TABLE, [More]
Hi, we have just upgraded our ERP system from R/3 4.6C to ECC 6.0, new WE62 for IDOC documentation is in html mode only. Is it possibile to use old-style WE62 in tree-view mode ? Regards. Ganimede Dignan.Hello Ganimede The package SED (IDoc Interface [More]
So, i am working on my school's website in my Web Development Course, and everything seems to be going fine. I have enctountered a problem, i have a divider holding a table that is our navigation bar, and below it the content of the site. When it is [More]
I have a report that grabs over 10,000 rows (it's an inventory). When I run it from sql plus, it is pretty fast. When I run it from a standard report, again it's pretty fast. However, my interactive report takes about 2 min to load. I did a p_trace a [More]
Since updating to Yosemite I have not been able to resolve the problem of buddy icons in Mac messages being greyed out, as if my buddies had no profile pictures.  When I delete a conversation and re-add the buddy, his/her profile pic reapperas. Howev [More]
Hi I am very new to apple / iMac / logic. Managed to get it installed etc but it crashes every time I press help from the top menu. Does anyone have this problem?Hi Ken.P, I eventually sorted out the problem, however only by doing a complete fresh in [More]
I'm working with the Desktop Integration Suite version 10gR3 and the Oracle content server 10.350, but I have not been able to show the window with required fields "Metadata", when the user drop a new file in folder of the windows explore. Which [More]
Hi, I sucessfully downloaded ps cs6 trial version to my external hard drive but now can't find how to start program? There are plenty of folders and subfolders...listed under photoshop CS6 folder but I can't seem to find the .exe file to start up? Ha [More]