psftdba : Messages : 102-131 of 3932

Messages: Simplify \| Expand (Group by Topic)		Author	Sort by Date

102	Bert, First, I would try and find where the time is going by looking at v$session_event, v$session_wait tables. There are a bunch of good articles on how to...	Henry Poras <hporas@.... hporas	Mar 4, 2003 3:57 pm
103	It's been a while, but I just got around to trying this myself in our PTools 8.41.05 Financials database. I found a document on Customer Connection which...	Henry Poras hporas	Mar 6, 2003 9:09 pm
104	hi, Thanks Henry. I used the third method and it worked but there's a order : 1/ Connect with app Des in 2-tier. 2/ Change Application...	litbighor	Mar 7, 2003 8:55 am
105	Hi Bert, Did you check the file init<SID>.ora ? Is there any differences between the 2 databases ? Check SORT_AREA_SIZE. Regards, Litbighor...	litbighor	Mar 7, 2003 9:04 am
106	Hello, Are there any "best practices" guidelines for database sizing - either promulgated by the PeopleSoft or recommended by 3rd parties? We are running...	i_bokassa	Mar 7, 2003 2:09 pm
107	Dear All, Can someone tell me if it is possible to link a running process found in the process request table to Oracle's v$session table. E.g. if I have an...	mirmar25	Mar 7, 2003 2:40 pm
108	Hi Marc, Select whatever you want from 2 views : select ..... v$process A and v$session B where A.PADDR=B.ADDR; example : select A.SPID,A.USERNAME,A.PROGRAM,...	litbighor	Mar 11, 2003 9:13 am
109	Thank you Litbighor, Having that information is there a way to make a link to the process request table for running processes? Regards, Marc ... From:...	Pijnappels, Marc mirmar25	Mar 11, 2003 10:46 am
110	Link with the table SYSADM.PSPRCSRQST See PSRUNSTATUS (7=>Processing) See PRCSNAME (ex = OMCREDIT ?) ... process request ... table to ... ...	litbighor	Mar 11, 2003 12:38 pm
111	Marc, A couple of months ago we had a situation where some PeopleSoft jobs, primarily we found from PS Query, causing high wait io. I developed the following...	dgoulet@...	Mar 11, 2003 2:38 pm
112	Hi, I would like to upgrade my HRMS database from Oracle 8.06 WE8ISO8859P1 to 8.1.7.2.1 WE8ISO8859P15. Has anyone done it ? Is there any issue with the symbol...	litbighor	Mar 11, 2003 3:41 pm
113	No problem with WE8ISO8859P15 Oracle Charset regarding People TOOLS but its better to move to Oracle 8.1.7.4 (which is the last 8i version and the most free...	laurent Delisle laurentdelisle	Mar 11, 2003 5:09 pm
114	Thanks for the infos. I have to use Oracle 8.1.7.2.1 for some environment reasons. Do users input the Euro symbol in Peoplesoft ? If yes, i think I have to...	litbighor	Mar 12, 2003 12:53 pm
115	Hi Marc, I've read the document of D. Kurtz (great job !!) and I can tell the answer : Create a trigger for SYSADM that will fire for a PRCSNAME like...	litbighor	Mar 14, 2003 10:03 am
116	You can use the trigger if you want to produce a log of serial numbers for each process instance. If you are doing this so that you can work out which trace...	David Kurtz davidkurtz	Mar 17, 2003 3:23 pm
117	Reminder from the Calendar of psftdba http://groups.yahoo.com/group/psftdba/cal UK Oracle User Group - DBMS SIG Thursday April 3, 2003 All Day (This event does...	Yahoo! Reminder reminders@...	Mar 20, 2003 12:01 am
118	I feel like I'm chasing my tail right now. Just trying to find where Peoplesoft gets its configuration information when running Crystal (NVision) reports from...	Henry Poras hporas	Mar 20, 2003 10:24 pm
119	Hi, The configuration is taken from the report Server. On the report Server or Process Scheduler server (on the same box) is where you set the location of the...	Julio C. Alonso jalonsoetc	Mar 21, 2003 7:55 am
120	Hi, I would like to know what is the process to upgrade Tools 8.41 to 8.42 ? I only have 2 databases : SYS and DMO to upgrade ? I think I have to install a new...	litbighor	Mar 24, 2003 1:35 pm
121	Does anyone out there have some instructions on exactly how to configure this? A screen shot from within PIA would be good. Am looking for 8 and 8.4, with a...	shirley.mcgregor@... oradba33	Mar 25, 2003 9:10 am
122	Hi, Yes, you have to install a new file server to install the new version of PT. On Customer Connection you can find a document with intructions to do this...	Julio C. Alonso jalonsoetc	Mar 25, 2003 9:53 am
123	Shirley When you define the Process Scheduler either NT or Unix, you must set the report node definiton. Prior to that, you must define the report node and...	Julio C. Alonso jalonsoetc	Mar 25, 2003 10:06 am
124	After creating an NEW Oracle 817 database and importing the SYSADM schema from an other Oracle 805 database. I would like to have the same passwords (in both...	BL Barske blbarske	Mar 25, 2003 11:43 am
125	Try this against the database you want to use as a source: select 'alter USER ' \|\| username \|\| ' identified by values ''' \|\| password \|\| ''';' from...	wfholmes	Mar 25, 2003 1:18 pm
126	Bert, Login to the original database with a DBA account, like system, and execute the following: spool pwd.sql select 'alter user '\|\|username\|\|' identified by...	Goulet, Dick dgoulet@...	Mar 25, 2003 5:04 pm
127	Thanks, I wasn't aware of the 'identified by values' option I know RTFM :<( Bert Barsk� ... Bert, Login to the original database with a DBA account, like...	BL Barske blbarske	Mar 26, 2003 9:04 am
128	Julio, Thanks for the reply. I have my report repository stuff set up and that is being moved properly. My question dealt more (or at least was meant to deal)...	Henry Poras hporas	Mar 26, 2003 7:16 pm
129	Doh!! Just need to set up different profiles for each PS_HOME in Configuration Manager. I usually catch on, sometimes it just takes awhile. Henry ... was ... ...	Henry Poras hporas	Apr 3, 2003 8:33 pm
130	What's the end of the story, please Bert ? ... reanalyse the tables on our (several) PS databases (HR/FIN/SA). ... 8.05 & FS 7.52 / PT 7.55 / Oracle 8.05) ......	litbighor	Apr 7, 2003 10:57 am
131	Thanks Julio. I understand thet I have to install a new file server. It's not a kind of upgrade but a totally new file server right ? I also have to put the...	litbighor	Apr 7, 2003 11:09 am

Yahoo! Groups Tips

Did you know...

Messages

Yahoo! My Yahoo! Mail
	Sign In New User? Sign Up
		Tech - Groups - Help

Yahoo! Groups Tips

Did you know...

Best of Y! Groups

Messages