| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
