Philip, This no longer applies...after version 7, if i recall correctly. Still, a la Jonathan Lewis et al. a bit of testing wouldn't hurt but the FROM...
844
psftdba@yahoogroups.com
Feb 10, 2005 8:41 am
Reminder from the Calendar of psftdba http://groups.yahoo.com/group/psftdba/cal OakTable Seminar: AskTom Live with Tom Kyte! Thursday February 10, 2005 9:00 am...
OK guys, Since version 7 Oracle RDBMS's can be run in two modes: (init.ora setting) OPTIMIZER=RULE or COST (or CHOOSE for both) in RULE based; tuning is...
846
Goulet, Dick
dgoulet@...
Feb 11, 2005 10:14 pm
Shaun, Minor correction, if your running PeopleTools 8+ they recommend CBO, but if your running anything earlier they recommend rbo, irrespective of the...
It is worth pointing out that the Rule Based Optimiser is deprecated in Oracle 9i and although still present in Oracle 10g (which BTW is not yet certified by...
It is true that if you use RAID 5 you will need fewer disk devices to produce a filesystem of the same size that RAID 10. However, the problem with RAID 5 is...
Thank you very much, David. I highly appreciate your emails. :) - John ... === message truncated === __________________________________ Do you Yahoo!? Read...
With FSCM 8 SP2 ,PS Tools 8.x ,Oracle 8i ,we use OPTIMIZER_MODE=FIRST_ROWS for the all OLTP sessions and OPTIMIZER_MODE=ALL_ROWS + hints on some setps inside...
I need to create individual user names for several developers so that backend changes can be audited by individuals instead of using the SYSADM id. I want to...
We are in the process of doing test runs to upgrade our Finance from 7.5 (7.62 tools) to 8.8 (8.44.10 tools). The 8.8 databases seem very slow at times. I am...
I have done just that, except instead of using synonyms I create a logon trigger for each developer id which does an alter session set current_schema=sysadm. ...
854
Goulet, Dick
dgoulet@...
Feb 16, 2005 4:24 am
You can create the synonyms as public without a security problem. It all depends on who has select priviledges on those tables. ... From: joness59...
Hi, I have heard that creating synonyms can cause a peformance degradation in certain versions of Oracle. Not sure if that still applies, but it may be worth...
I like the idea of this trigger. Do you mind sharing your code for creating the trigger. Thanks, - Ricky ... logon ... and I ... that ... have to ... create ...
Hi. Does anyone have a suggestion to get by PER099 AppEngine process quickly? This process is taking too long (29 hours so far) and I need to find a way to...
I tried the following and it doesn't seem to work: I have a role called PSADMIN which has been granted 'grant any role' priv. I have schema owner SYSADM which...
At 04:14 PM 16/02/2005, you wrote: Couldn't be simpler: create or replace trigger logon_trg after logon on schema begin execute immediate 'alter session set...
All I am an oracle dba, recently assigned to a peoplesoft migration. I got a backup file and i am to make this application up and running on a test box in a...
Hi Paul, What version of peopletools do you use ? You have not only to set up the webserver but the application server as well (Tuxedo). Regards, Laurent ... ...
Thank you for your help here are the information we run 8.0 HRMS Engine w/8.1.4 PeopleTools. Oracle version 8.1.6 the directories created are app/Weblinst ...
Thanks for replying here is more info the following directories were created app/Weblinst app/aux109 app/psoft app/psreports app/sqr614 app/sqrinst app/tuxedo ...
Hi, Getting a lot of warnings in my event viewer. Forced shutdown of client; user name 'PS'; client name 'JavaClient' and many other user names. This is on...
Hi Jim, Don't worry about that, these messages are quite normal. Since application server's timeout runs, client session expires by "forced shutdown". Laurent ...
867
Ruth Bittinger
ruth.bittinger@...
Feb 22, 2005 5:05 am
Hi, I've created a trigger on psprcsrqst in an HR8 database (running on Oracle 8.1.7.4) using the script on p. 270 of David Kurtz' book PeopleSoft for the...
There is probably an error being raised in the trigger. However, the exception prevents the trigger from causing the update to fail, otherwise it could in...
869
Ruth Bittinger
ruth.bittinger@...
Feb 22, 2005 4:22 pm
Sorry, I should have included this in the first post: create or replace trigger sysadm.set_trace_psppyrun before update of runstatus on sysadm.psprcsrqst for...
This is Related to Sendmail Question. If i have 12 email id (xxxx@...) in the &mail_to list and use sendmail(...),it sends good, but 12 email id will show ...
Thank you very much! The trigger was raising an error, and it was "ORA-01031: insufficient privileges". The comment in the header of the create trigger...
For everybody's information. I have been communicating with Ruth directly and it turned out to be that the alter session privilege needed to be granted to...
