Home » RDBMS Server » Server Administration » database profiles
database profiles [message #224424] Wed, 14 March 2007 04:12 Go to next message
Messages: 68
Registered: July 2005
Location: Braynston

Hi All.

I have observed that in oracle 8i there is "PASSWORD" and "DEFAULT" profiles when selecting from dba_profiles but when selecting from 9i and 10g there is only "DEFAULT".

Is "PASSWORD"(or could it have been created before my joining the company) and "DEFAULT" default profiles on oracle8i and from 9i "DEFAULT" is only the default profile?

Is there any performance issues that can be expirienced from changing any resouce limits,like changing CPU_PER_SESSION value

Thank You
Re: database profiles [message #224576 is a reply to message #224424] Wed, 14 March 2007 12:50 Go to previous message
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
Performance increases on 10g are common.
They have a new way of defining how much memory is used (sga_target and sga_max) that I do not think is on 9i. Use those two parameters instead of db_blocks.

The sql plan generated by the optimizer is better. Also, you can save a plan for use anytime the database sees that same query.
I left a lot out. See 10g documentation for details about new/changed/no longer supported parameters.
Previous Topic: problem with remote administration,help
Next Topic: Autoextend Yes/No
Goto Forum:

Current Time: Wed Oct 26 10:25:37 CDT 2016

Total time taken to generate the page: 0.08677 seconds