First, write a small export script to save off the report node information and anything else you want to save. Have a par file that lists those tables - this...
834
John Hayes
ikingus
Feb 8, 2005 4:58 pm
Thank you very much for your information, Laurent. I'm starting to read the documents. I have another question. What is peoplesoft's recommendation for RAID?...
835
David Kurtz
davidkurtz
Feb 8, 2005 5:04 pm
see www.baarf.com - behind the hilarity there is a very serious point being made read James Morle's seminal Sane San paper. Put the database on raid 1+0 (a...
836
John Hayes
ikingus
Feb 8, 2005 9:46 pm
Thank you very much, David. If I make the database on RAID 5 (save space), would this be adequate enough? ... __________________________________ Do you...
837
ikingus
Feb 8, 2005 9:46 pm
Thank you very much, David. If I make the database on RAID 5 (save space), would this be adequate enough? ... point being ... might be ... for...
838
James Blanding
stoneandkobi
Feb 8, 2005 9:47 pm
SSH will happily handle remote command execution and will eliminate the inherent security risks of rsh. --James...
839
psftdba@yahoogroups.com
Feb 9, 2005 8:41 am
Reminder from the Calendar of psftdba http://groups.yahoo.com/group/psftdba/cal OakTable Seminar: AskTom Live with Tom Kyte! Wednesday February 9, 2005 9:00 am...
840
Phillip Eaton
pjeaton
Feb 9, 2005 3:07 pm
Hello All, I am of the understanding that on Oracle 8.1.7 the order that the tables are listed in the FROM clause of a query will affect it's performance. 2...
841
Phillip Eaton
pjeaton
Feb 9, 2005 3:07 pm
Actually, having thought about it, would I be right in saying that the query will run fastest in the following scenario: Say you had a simple select query that...
842
Ross Mohan
rmohanx@...
Feb 9, 2005 4:58 pm
Definitely on right track BUT you need to have good stats for the CBO to make the right choices. Small tables, you should dbms_stats.gather_table_stats at...
843
Ross Mohan
rmohanx@...
Feb 9, 2005 4:59 pm
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...
845
Shaun
shaun3823
Feb 11, 2005 4:38 pm
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...
847
David Kurtz
davidkurtz
Feb 11, 2005 10:38 pm
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...
848
David Kurtz
davidkurtz
Feb 11, 2005 10:50 pm
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...
849
John Hayes
ikingus
Feb 12, 2005 10:13 pm
Thank you very much, David. I highly appreciate your emails. :) - John ... === message truncated === __________________________________ Do you Yahoo!? Read...
850
laurent Delisle
laurentdelisle
Feb 14, 2005 2:43 pm
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...
851
joness59
Feb 15, 2005 3:09 am
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...
852
rogbak_er
Feb 16, 2005 1:27 am
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...
853
Wolfgang Breitling
wolfgang_bre...
Feb 16, 2005 1:27 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...
855
Bharat Sharma, PSFT
sharmacentral
Feb 16, 2005 1:32 pm
If the current session is altered.. who will get audited - the developers ID or SYSADM? Bharat Sharma. IJIT Inc. ... From: Wolfgang Breitling...
856
R P
pjksel
Feb 16, 2005 5:10 pm
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...
857
ricky_parham@...
wreekie
Feb 16, 2005 10:53 pm
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 ...
858
ikingus
Feb 16, 2005 10:53 pm
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...
859
joness59
Feb 16, 2005 10:53 pm
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...
860
Wolfgang Breitling
wolfgang_bre...
Feb 17, 2005 3:40 am
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...
861
Paul Reji
prphilip
Feb 18, 2005 1:19 am
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...
862
Laurent LCU. CORNILLEAU
manaiti2000
Feb 18, 2005 1:00 pm
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 ... ...
