> Why the spin value matters for the results when the main bottleneck is the buffer waits?
A possible explanation is based on the fact that the small number of the processes gives the best results in ATM tests. When the processes are spinning, they are not doing anything useful including the...
> What was the bottleneck for 150 sessions? Of course, the naps and waits. But I would like to know the name of the concrete resource.
Status: Blocked Clients answers:
69.3% (104 of 150 in the average per snapshots) clients were blocked;
94.7% waits were in the area 15: "History1...
Gus' presentation:
ATM transaction duration
slow 82 ms (-spin 5,000)
fast 31 ms (-spin 50,000)
My formula to estimate the durations of the short transactions:
Average transaction duration = Average number of the simultaneous transactions / Commits per Sec
Our results:
150 sessions...
Dear Santa(s),
I have been rather bad this year. So YouTube had recommended me to watch Gus Bjorklund presentation - "Time And How To Get Rid Of it -- Revisited".
The presentation raised some questions in my poor head but I can't find the answers on my own. For Christmas, can I get the answers...
> It's possible to revert V12 db to the version 11.7 but it's unsupported and rather risky.
The difference between the V11 and V12 db structures is the metaschema and the version in the db extent blocks. If there are no application data in Schema Area and if you can postpone for a while the...
> I presume that OE 11 would not accept and process AI files from OE 12. Is that correct?
Invalid after image version number found in ai file header. Please verify your Progress version, OS version, or AI block size are correct. (752)
Plus you can apply AI files only to a database restored...
> a user deleted a record from a small reference table and I need to know who did it.
The table and its indexes are resided in the public areas, aren't them?
How many blocks are used by the bpaytrancode table?
How many blocks are used by the indexes of bpaytrancode table?
If the numbers are...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.