Hi I hope you not configuer properly the cobol path. So pls check the path, and give the (%PS_HOME%\CBLBIN/BASE). ________________________________ From: Khayal...
After taking a look at the privileges granted to SYSADM via the delivered PSADMIN role, I'm wondering if anyone has trimmed any of the seemingly unnecessary...
By coincidence, I was having exactly this discussion on a customer site earlier today. I've just read Tanel's blog entry - Ouch! You can trim the PSADMIN role...
We are (still) on ORA 9.2.0.8 with default setting for CURSOR_SHARING. Heard some good thing about with setting of SIMILAR in Oracle 10g.   Any success...
James, All dba's and security admins will question the need for the privileges given to SYSADM via the PSADMIN role. We had 2 ways to approach it. First one...
I have experimented with CURSOR_SHARING, and I would not recommend setting this parameter instance-wide to non-default values. It is not always beneficial....
Hi all, I'm working as a PeopleSoft administrator on a PeopleSoft Financials environment and also as DBA on the underlying Oracle database(10G). We created...
SP, We were using CURSOR_SHARING=EXACT in our old enviroment (9.2.0.3 db with psoft 8.42) and we are using the same setting in our new environment (10.2.0.3...
Olivier, So far I havent seen anyone reporting any efficiency in oracle storing files within the database. My experience of dealing with oracle storing data...
I am trying to see client status i.e Number of clients connected to peolesoft session though "psadmin" ps_home/appserv/psadmin I am receiving below error after...
Psadmin is just a wrapper for tmadmin, the Tuxedo command line utility. By default tmadmin takes out an exclusive lock on the bulletin board. If you try to...
Hi David, Thanks for response. My OS is AIX. Can you please let me know how to check for multiple copies of tmadmin process. will restarting applciation server...
The process you are looking for is called tmadmin. So just use the 'ps' command to see what is running. Something like this (and I haven't tested it) will...
Yep . I did search for tmadmin processes but could not find one. I reconfigured the domain ,now I am able to see the client status. Is there any way to get...
That sounds like the domain getting locked up. It is likely that a simple recycle of the domain would also have done the job. Using TMADMIN is good for a...
There was a discussion a while back about querying the web server programmatically for the information displayed in application monitoring section of the...
Hi, We are experiencing high memory and swap utilization on our middle tiers. When I searched for top 20 processes consuming high Swap from OS level all...
What platform are you running on? The memory numbers reported by 'ps' don't really provide a good picture of the real memory usage of a process. This is...
I know. Its linux platform and as the feature of this platform it does not release the memory rather REUSE the same. the below output has been on the...
If you are paging memory to disk then you need to reduce memory consumption. PSAPPSRV is the main application server process. How many are you running? How...
Is there any way to (easily) disable the ability for end users to create recurrances when executing a run control? Hopefully using security rather than having...
Thanks a lot David for your reply. The recycle count in set to its default value (5000) for all psappsrv.cfg file of all four domains (PABCDV11, PABCDV12,...
I am going to assume that all these processes are PSAPPSRVs. It would be helpful to see a snapshot from top. I will aslo assume the database is somewhere else...
All these processes are connected to Database and are in INACTIVE state (found while checking from the DB side) I am recommending to reduce PSAPPSRVs also the...
The PIA has an inactivity timeout. The default is 20 minutes, and you should resist the temptation to increase it. User sessions consume memory within the...
1. Correct 2. Correct, because MIN=MAX If MIN < MAX then spawning would be enabled. For now, I would suggest not introducing spawning, then you can measure...
Hi  we have a weblogic 9.2 cluster configuration where in there are 9 PIA's and a Reverse proxy server all on the same physical server (For some reason...
Hello *, I was wondering if I could control the PPLsoft performance by partitioning of the PS_LEDGER and / or PS_JRNL_LN tables. I have done the obvious other...
Willem.Leenen@...
Jan 26, 2009 11:04 am
3554
Yes, partitioning PS_LEDGER is very effective for nVision reporting of GL. I usually range partition this table on a combination of FISCAL_YEAR and ...
Thank you, David, for your elaborate and helpful answer, Regards, Willem ... ATTENTION: The information in this electronic mail message is private and ...
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.
