Hello David, I have tested your suggestions this weekend on the production server and the problem was indeed a matter of concurrent use of temptables. Thank ...
Willem.Leenen@...
Feb 2, 2009 9:20 am
3572
Have you tried moving the temp tables to a tablespace with a larger blocksize? Is so, how much difference did it make? regards _________________________ David...
No, I don't want to turn to oracle solutions yet for a problem I consider to be rooted from application design - or a scheduling matter. I'm first looking for...
Willem.Leenen@...
Feb 2, 2009 9:46 am
3574
I find that, besides, PS_COMB_EXP_TAO4 the PS_JRNL_IUW2_TAO4 / PS_JRNL_IUW2_TAO5 tables are very busy. Have you been able to implement DROPping the indexes on...
Hmm. My understanding that these bugs were fixed in 10.2 I'd even gone to Patch#6844739 which is a consolidated fix for a number of Bugs (see Note#6844739.8...
I understand that you are talking about a bugfix for an indexspace leakage, but how does it relate to the concurrency problem David and I described? BTW We're...
Willem.Leenen@...
Feb 2, 2009 10:06 am
3577
Hi, I am unable to migrate an HTML objects to another database using the following navigation from application designer: TOOLS > COPY PROJECT > TO DATABASE...
No, indexspace leakage is in my other message. Here I am talking of TRUNCATE performance bugs. In 9.2, you certainly should use a seperate block size for your...
Serialisation of Truncates is a consequence of using the RO enqueue to protect local write wait. It is the way Oracle works. It has nothing to do with any...
David, I have heard about RO enqueue to be connected to Oracle bugs. For example, the bug Hemant talks about is about the corruption of the bitmap segment for...
Willem.Leenen@...
Feb 3, 2009 3:46 pm
3581
It doesn't become a separate wait event until 10g, but you can see the RO enqueue as the lock mode in v$lock or dba_locks; If you can set event 10704 to trace...
First of all: Thank you David for the excellent paper concerning this matter. Very interesting and helpful. There is little to add to what has already been...
What do the various App Server components do when the database is unavailable for long periods? There doesn't seem to be anything comparable to Process...
They will try to connect for about 1/2 hour - after that, you need to drop the app server and bring it back up to connect. I don't know if that is a...
As far as I can tell, if the application server is inactive, that is to say that no service requests are made then it does nothing. It won't notice that the...
Hi, On some development environments I am doing cold backups during the night with cron jobs without stopping App Servers and Process Schedulers. I never had...
Peoplesoft page hanging after submitting the user credentials. This started happening after server crash and recovery. We are having app/db/web/prcs on single...
Hello *, I noticed of a particular SQL that the TAO table in it did not have it's statistics updated, causing severe performance degradation. How can I get a...
Willem.Leenen@...
Feb 5, 2009 11:43 am
3590
Whatever stats you collect on these tables, they will be wrong at run time because the tables will contain different data! Some application engine programs...
Yes, I do not want to collect statistics myself on these tables, but I am looking for a way to create a list of AE programs that do not use the %UpdateStats...
Willem.Leenen@...
Feb 5, 2009 12:54 pm
3592
SAMSRV and QCKSRV processes: My understanding is that the above two processes are only used by 3- tier clients. 3-tier is accessing application without the web...
What about your developers; do they use Application Designer using the web? Do you migrate code between environments using the web? What about any monitoring...
You can only migrate AD projects between environments in two-tier mode. 2009/2/5 the dragon <ceprn@...> ... -- regards _________________________ David...
oops, you're correct. I blame early morning non-caffienated drinks. peace, clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary, your...
PeopleSoft Conference 2009 presented by UKOUG & GPUG 19th - 20th May, Hotel Sofitel London Heathrow Deadlines are tight - submit your abstracts now at...
I tried turning off QCKSRV, but it broke some nVision reports that were being run 3-tier, so I leave one QCKSRV process running. In the scheme of things, it...
When you reconfigure the domain without PSQCKSRV the services are moved to PSAPPSRV. Removing PSSAMSRV will definitely break nVision in 3-tier. Exactly which...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
