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
I guess that kinda sums it up. Mail, when you click on it in the dock, bounces once, then just sits there staring at me, and fails to open. I've run a Disk repair thing just in case it was accessibility, but that hasn't helped. I looked at it in Term [More]
Hi every one. I set up a database and plant a backup strategy with RMAN that is: - Backup incremental level 0 on every Sunday - Backup incremental level 1 on other days. My database is Oracle Enterprise 11gR2 - Linux amd64 The backup task scheduled w [More]
Hi, i had created one report and i want to sechedule it in background based on the condition that if a check box is checked it will run in background otherwise in foreground.Hi Raymond, you was quicker Didn't know this solution yet. Great. (Hint, you [More]
Hi, When i am  trying to change Unit of issue in Qualitymanagement view of  a material using MM02 transaction, we  got error message - "The unit of issue cannot be changed because the material is used in a BOM-------Mesage no. M3214" Can anyone [More]
Hi All, I have just installed oracle 10.2.0.2. Now I am installing Solution Manager 4.0. (OS is windows 2003) I have reached the stage where it tries to 'start the ABAP instance'. The issues is that the dispatcher stops and the sapinst throws error. [More]
I have a table which will stored various kinds of documents (e.g. PDF, MS word, MS Excel etc...) into blob column. How can I read them from the database through web and display them into the correct software? i.e. when the file is PDF, it can be open [More]
Hi All, My clients wants to send all the vendor rating by mails instead of sending it thorugh post or couriers. Please let me know how to activate this. Can we need to use any abaper for this. Regards, Nagaraj SHi Manish, How can we do this , can you [More]
Hi all, I would like to link my srw2048 in the my celler to the linksys 8port switch i have in the living room so my son can have lan parties. how would i configure this and will i need to make a crossover cable? Thanks in advance for any adviceI don [More]
Does anyone know if the MAX interface is written in LabVIEW or not? Cheers JG  Certified LabVIEW Architect * LabVIEW ChampionAs far as I know, MAX itself is written in C, but some of it (probably some of the dialogs it uses) is written in LabVIEW 7.1 [More]
Hi Gurus, We are installing PI 7.0 on Solaris / Oracle platform. We have one Physical Server Having multiple logical instance ( no physical partition, just logical partitions ) . SCS is installed successfully, without any issue. On that same physical [More]