psftdba : PeopleSoft DBA Forum

Info

Settings

Group Information

Members: 1239
Category: PeopleSoft
Founded: Nov 3, 2002
Language: English

Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...

Want your group to be featured on the Yahoo! Groups website? Add a group photo to Flickr.

Groups Outage July 13, 14 and 15th -- click for more details

Home

Activity within 7 days:

2 New Messages

Description

This forum is for PeopleSoft DBAs, Administrators and other interested technicians to discuss ideas, ask questions, and share information.

Membership of this group is open. You will need to create a yahoo account in order to sign up for membership of the group. Alternatively, if you don't want to join yahoo write to info@go-faster.co.uk and ask for an invitation.

Only members can post to this group. Posts from new members are moderated. Any materials of interest to PeopleSoft infrastructure technicians is valid. The group is for the benefit of the users, and we want to keep it that way. Advertising, job postings, spam and other inappropriate messages cannot be posted, and will be filtered by moderators. Authors of job adverts and other offending posts will be summarily banned from the group.

Please also remember that the forum is not a replacement for PeopleSoft Customer Connection.

Readers of PeopleSoft for the Oracle DBA are also encouraged to use this forum to raises issues and ask questions.

You can send messages to this group at psftdba@yahoogroups.com
----------------------------------------
David Kurtz, Go-Faster Consultancy
Graham Bowden, Springboard Solutions
Bob Ellis, PSE Data Security Gmbh

Most Recent Messages

(View All)
(Group by Topic)

Advanced

Start Topic

Re: Digest Number 1233 Hi SP, Thank you for the hints. I am surprised to hear that the optimizer_dynamic_sampling should be set to zero for the PPLsoft database. I am on Oracle 9, Posted - Thu Jul 9, 2009 10:10 am	Willem.Leenen@... Send Email
Re: Digest Number 1233 There is a red paper on PeopleSoft site which talks "PeopleSoft Enterprise Performance on Oracle 10g Database" please read it .... BTW per this paper Posted - Wed Jul 8, 2009 6:53 pm	SP sripingali Offline Send Email
Re: DBMS_STATS and Oracle 10g Willem, I was not trying to contradict your statement. As you clarified, exceptions needs to be handled in both cases. The choice to analyze full or at a Posted - Tue Jul 7, 2009 3:33 pm	shajivps Offline Send Email
Re: DBMS_STATS and Oracle 10g Shaji, I don't see any difference in our opinions. If your posting was meant to counter mine, then one of us wasn't clear. The only exception is in the last Posted - Tue Jul 7, 2009 3:06 pm	Willem.Leenen@... Send Email
Re: DBMS_STATS and Oracle 10g I think you can usually take default sample size by using DBMS_STATS.AUTO_SAMPLE_SIZE. There might be a few tables where you need to collect statistics at a Posted - Tue Jul 7, 2009 3:05 pm	David Kurtz davidkurtz Offline Send Email
Add psftdba to your personalized My Yahoo! page What's This?

Message History

	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2009	45	73	83	73	22	13	9
2008	53	33	24	41	28	51	46	55	23	41	60	26
2007	29	28	85	37	61	76	66	74	73	72	78	37
2006	114	85	86	37	96	91	98	61	48	33	87	27
2005	21	49	66	56	53	79	43	50	73	62	38	73
2004	60	12	32	6	17	61	34	20	60	14	24	33
2003	24	47	27	41	19	24	30	27	45	62	24	29
2002											17	13

Group Email Addresses

Related Link:	http://www.go-faster.co.uk
Post message:	psftdba@yahoogroups.com
Subscribe:	psftdba-subscribe@yahoogroups.com
Unsubscribe:	psftdba-unsubscribe@yahoogroups.com
List owner:	psftdba-owner@yahoogroups.com

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