Sitemap

Amicuk Programming Answers

Amount of transaction

2015-10-11   Views:0

Advertisement

hi how can I know the amount of transaction in one table, or more than one tables.Is it possible to monitor transaction amount? I want to have an idea about which tables in the system applied transaction most !!!You can query global number of transac

hi
how can I know the amount of transaction in one table, or more than one tables.Is it possible to monitor transaction amount?
I want to have an idea about which tables in the system applied transaction most !!!

The replay answer
Advertisement
You can query global number of transactions at session level or instance level using the statistics 4 and 5 in 10g release 2:
select statistic#, name from v$statname where name like 'user%';STATISTIC# NAME
         4 user commits
         5 user rollbacks
         6 user calls
        17 user I/O wait timeHowever, to get details at table level, you could also use LogMiner.

Go to See the other 5 answers

Amount of transaction

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

hi how can I know the amount of transaction in one table, or more than one tables.Is it possible to monitor transaction amount? I want to have an idea about which tables in the system applied transaction most !!!You can query global number of transac[More]

KE5Z - Amounts in transaction currency

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

Hi, I am using 6.0 version. I am trying to view the actual PC line items using KE5Z. But, the field "In transaction currency" is Blank. In PC settings (0KE5) , i have maintained PCtr Local Currency Type as "20" (Controlling area curren[More]

Amount of max possible simultaneous INSERTs depend on what ??

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

Hi all, can somebody comment on following statement , whether its is absolutely true, only a part of the truth or completely wrong : "The maximum possible amount of transactions that are simultaneously performing inserts into an Oracle- table is MAIN[More]

G/L error while posting an amount - TXN: FPE1 - SAP ISU

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

Hello Experts, We are in the process of implementing SAP ISU functionality for a utility client. In order to support their utility process we are configuring their SAP System from scratch. Now after completing basic configuration such as main-sub, AD[More]

Partical amount transfer through ABUMN

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

Hi, By mistake we have created the asset master data with wrong cost center and plant and posted the entry of acquisition in 30.06.2008 for Rs 100000. The opening balance of this asset is on 01.04.2008 is NIL Later on we have discovered the mistake a[More]

Extended Withholding Tax ( Minimum/maximum Base Amount )  - with accumulati

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

We are facing problem in posting of vendor Invoice. Actually we have implemented Minimum base amount ( Rs. 75000/- ) at withholding tax type level and accumulation at per year  in withholding tax type A1 ( for testing purpose ) and assign the same to[More]

Hot
I am using Lightroon 4 on a Macbook pro, OS Lion. I forgot to change the location of all my local wordpress images before importing them to a new folder, and they ended up being moved to my default dated folders i.e. Pictures/2012/2012-01-01. How can [More]
Hi All, I am installing SAP Solution Manager 7.1 SR1 i am facing below issue ,any one please suggest me how to proceed further.I am new to sybase . An error occurred while processing option SAP Solution Manager 7.1 Support Release 1 > SAP Systems > [More]
Grid Infrastructure version : 11.2.0.3 Platform : Oracle Enterprise Linux 5.6 Question1. oracle:dba will be owner of our Grid software (not grid user). What should be permission set for LUNs ( /dev/sda1, ..) before the grid installation ? Question2. [More]
Hi all, I'm attempting to use the SkillBuilders Modal Page 2.0.0 plugin, everything seems to work except the refreshing of the reports. When clicking on the links the modal page opens, I can make changes, and after clicking on "apply changes" th [More]
Hi all, I got a requirement to write code for sending mail in oops. i have written code for .xls which is working fine. But requirement is to send the mail in the format of txt. i just only chnge the .xls to .txt where i can see the output properly i [More]
I've had a tremendous issue with crashes for the last 2 to 3 weeks. I tried'' all of the suggested steps'' with no change. I send the report every single time and no response. Is there anywhere else I can send some of the report id's to and have some [More]
Hi all, I have bought my children iPod Touch devices for Christmas this year and would like to set up accounts and libraries for each of them (3 in total, one for the Mrs!) so I can sync them and put some games and apps on ready for use. Is it possib [More]
I wanna bootcamb windows 8 on a macbook pro 13" retina display mid 2014. is it possible, specially that my drive is 128 GB only? does windows properly working?Hi .. It is, but be aware, Windows 8 requires approximately 16GB's of storage space and you [More]
When I use the drop-down Windows menu, it only shows the name of the window, not the tabs within each window. And I don't an option for "Activity Window" (like on Safari), or anything else that will show me all open tabs. How can I see them, as [More]
How  can use a variable 'W_ROWNUM2' in the folowing code? MOVE '1' TO CNT. LOOP AT L_T_PM2.               CONCATENATE '0' CNT INTO W_ROWNUM2.CONDENSE W_ROWNUM2.                CONCATENATE 'F110V-VARI'W_ROWNUM2'(01)' INTO FLD2.     perform  DYNPRO_FIE [More]