Home » RDBMS Server » Enterprise Manager » Creating profiles
Creating profiles [message #68305] Tue, 25 March 2003 18:22
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
Previous Topic: ORA-28009 when using Performance page on OEM web site
Next Topic: urgent creating db on solaris out of memory 0
Goto Forum:
  


Current Time: Sat May 21 13:10:55 CDT 2022