Home » RDBMS Server » Server Administration » database profiles
database profiles [message #224424] Wed, 14 March 2007 04:12 Go to next message
sellafrica
Messages: 68
Registered: July 2005
Location: Braynston
Member
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
nmacdannald
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: Sat Dec 14 01:58:47 CST 2024