Apologies if this has been asked before, but is there a method of diconnecting idle connections to an OE database? We are trying to maximise the available licenses under our concurrent user allowance and all attempts to fix the humans (i.e. get them to log off the sytem at end of shift) have...
This seems to have been resolved in our test environment by upgrading from SP05 to SP07. PSC also did some testing on their side between the Service Packs and found a direct correlation between checkpoint duration and the size of -B/-B2. They have put it down to poor memory management on...
R&D 2 5
♀07/19/13 Activity: BI Log
13:16:48 07/18/13 22:40 to 07/19/13 13:13 (14 hrs 34 min)
Total Per Min Per Sec Per Tx
Total BI writes 3466430 3968 66.13 0.45...
R&D 3 1, is Latch timeouts good or bad?
♀07/19/13 Activity: Performance Indicators
13:13:53 07/18/13 22:40 to 07/19/13 13:13 (14 hrs 34 min)
Total Per Min Per Sec Per Tx
Commits 7704011...
Hi Tom
BI is on physical RAID 1+0 disk, fast array with 16 spindles. Nothing else on array other than .r code i.e. no other database technologies or services.
Would prefer to avoid regression testing for an SP upgrade (see my earlier posting), but if SP06 or 07 is the answer then I will...
Thanks Rob. Where in promon can I monitor LRU latch contention?
The mother of all change control processes is keeping us on SP05. I had to work extremely hard to push through an upgrade from 9.1D last March to 10.2B05. I would rather explore all options with SP05 before starting the...
The checkpoint duration is exactly the same with a small cluster size as I tried this last week which means UI performance is even worse as the pauses are more frequent. I raised the same issue with PSC and they suggested turning off the Alternate Buffer Pool altogether by setting -B2 to zero...
5. Activity
6. Shared Resources
7. Database Status
8. Shut Down Database
R&D. Advanced options
T. 2PC Transactions Control
L. Resolve 2PC Limbo Transactions
C. 2PC Coordinator Information
J. Resolve JTA Transactions
M. Modify Defaults
Q...
A BIW and AIW are running.
BI Clustersize is 262128kb, block size is 4kb.
The disk hosting the BI is < 10% active during the checkpoint.
Only thing that seems odd is that 'Writes by BIW' rarely gets over 50%.
R&D -> 3 -> 4 below
15:36:42
Ckpt ------...
Is there a way to reduce the checkpoint duration? There is plenty of advice on checkpoint frequency and I have followed that intently to get our checkpints to no more that every 5 minutes with 0 buffers flushed at peak load during the day, but as the footprint of the database increases so it...
There is probably a really simple answer to this, but it eludes me. I want to script the restore of a backup into a pre-existing database. Doing this manually is straight forward as I just type Y when prompted to overwrite the existing database, but I cannot get it scripted as the prompt gets...
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.