| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re:RE: Re[2]: People Soft dba info
Joan,
You are so right, especially if the database is all they will allow you input into. Getting the tail to wag the dog is a very hard task. One must remember that when it comes to performance 80% is in the application & 20% in the database.
Dick Goulet
____________________Reply Separator____________________ Author: "Joan Hsieh" <Joan.Hsieh_at_mirror-image.com> Date: 2/1/2001 9:11 AM
I agree. peoplesoft class is not related to oracle at all. But it helps when it comes the problem. Especially the configure class really help when you use 3 tier connection. For performance issue, that's all oracle part to play. dba still can change a lot of peoplesoft stuff (index and view definition) and it can make big difference. Well, I am out of that business right now. Maybe someday I will back to peoplesoft or oracle application. Right now, I am focus on database level tuning. It's not that easy to become a hero that I can tell.
Joan
-----Original Message-----
Beckstrom
Sent: Thursday, February 01, 2001 10:56 AM
To: Multiple recipients of list ORACLE-L
I have been supporting Peoplesoft for 5 years now. Like Dick says, it is NOT written for Oracle and does not use constraints, packages, etc.
It has its own data dictionary which it uses when altering tables. I wrote SQL to repopulate the Peoplesoft dictionary with sizing from the catalog.
Never had any classes just picked it up. When needed some help, asked our developers who went to the classes.
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
(216) 781-4204
>>> <dgoulet_at_vicr.com> 2/1/01 10:32:17 AM >>>
Mike,
Does PeopleSoft have database training, Yes. Will it help you with
Oracle,
NO WAY IN HELL!. PeopleSoft uses Sql*Server in their development &
training.
They also don't do anything outside of the PeopleTools suite. Therefore,
for
database sizing, performance tuning, backup & recovery, etc... Your on your
own. To PeopleSoft a "database" is equal to a schema, although they don't
really like, but do accept, having more than one schema inside one database
instance. I do recommend the following PeopleSoft classes though,
PeopleTools I
& II (this is the basic stuff), Configuration & Administration
(configuration
pertains to the Application server from BEA & the process scheduler),
Upgrade &
Data Management workshop (really gets into the upgrade process which is very
involved). If possible you should also take a PeopleCode class.
Dick Goulet
____________________Reply Separator____________________ Author: "Mike Lanteigne" <mikel_at_shec.com> Date: 2/1/2001 6:48 AM
Hi Joan,
I'm starting a job soon supporting a database holding PeopleSoft data, so I was looking for a heads up on what I should expect. 'PeopleSoft Training' -- See, I didn't know they had specific PeopleSoft database training, so that's good to know.
I'll look at the places you suggested, Thanks
Mike
> Mike,
>
> I do have a lot information. I've been working for peoplesoft/oracle dba
for
> 2 years and got all the peoplesoft training. What kind of information you
> want? If you just want basic information. IOUG has a peoplesoft sig group,
> they have a lot of papers for all HR and FR. Peoplesoft customer
connection
> has tons of info for a oracle dba too.
>
> Joan
>
> -----Original Message-----
> Lanteigne
> Sent: Wednesday, January 31, 2001 12:21 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hello all,
>
> I was wondering if anyone has info or leads in the particulars of managing
> an Oracle database supporting PeopleSoft. Oracle version 7.3.
>
> Thanks
>
> Mike
>
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mike Lanteigne
> INET: mikel_at_shec.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joan Hsieh
> INET: Joan.Hsieh_at_mirror-image.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Lanteigne INET: mikel_at_shec.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: dgoulet_at_vicr.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: Joan.Hsieh_at_mirror-image.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: dgoulet_at_vicr.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Feb 01 2001 - 12:09:53 CST
 |
 |