| database profiles [message #224424] |
Wed, 14 March 2007 04:12  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
