OraFAQ Forum: Server Administration » Rules of thumb when creating Profiles?

Home » RDBMS Server » Server Administration » Rules of thumb when creating Profiles?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Rules of thumb when creating Profiles? [message #56382]

Tue, 25 March 2003 18:09

question911
Messages: 13
Registered: March 2003

Junior Member

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

Report message to a moderator

Previous Topic:	differences between all oracle versions and releases
Next Topic:	what is nmupm.exe in Oracle AS Release 2 BIN folder?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 00:57:44 CDT 2024