Rules of thumb when creating Profiles?

I am not a DBA, so any feedback from anyone who has experience in this subject matter would be greatly appreciated.  

I need to create a profile for users who will only be querying two tables. This query will only consist of an inner join, summation calculation, and a group by clause. At the most there will only be about 25,000 records returned from this query. I need to know what settings should I put for the items in the profile I plan to create based on this single query.

I plan to only allow 1 session for this user account and an idle time of 30. I need to know what settings should I put for the other items in the profile based on the information on paragraph two on this post. I plan to reuse this profile for only users who will be running this query.

I know I need to add the Resource_Limit parameter in my init*.ora file

Thanks,

Jay Received on Tue Mar 25 2003 - 18:59:57 CST