Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Rules of thumb when creating Profiles?
Hi HJR,
O/S = UNIX
RDBMS = ORACLE 7.3.2
Not too sure how to tackle this problem given the facts that you've
provided from your experience using Profiles. Since, I'm on 7.3.2, it
looks like i'm screwed.
Thanks,
Jay
jlee00_99_at_yahoo.com (Jay) wrote in message news:<3ea71bf0.0303251659.397df304_at_posting.google.com>...
> 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 Wed Mar 26 2003 - 08:38:18 CST