Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

What sort of profile would you recommend for an Oracle user that is manifested through a RESTful API; particularly where there will be a lot of asynchronous requests? So we're talking about a potentially large number of simultaneous connections, with a requirement for low latency, but returning relatively short snippets of data.

share|improve this question
    
Not sure what you mean here. Can you expand? Oracle tuning isn't done per-user. – Phil Dec 4 '12 at 6:37
    
@Phil Good point -- I'm not an expert and that escaped me! I guess, in that case, latency is a function of the schema. (This isn't something I have control over, as it's third party.) However, I was just wondering if there were any tweaks that could be done to a user profile that are conducive to, particularly, a lot of concurrent connections, such that other users aren't overly affected? – Xophmeister Dec 4 '12 at 9:54

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.