| |
 |
|
DBA_PROFILES view tips
Oracle Tips by Burleson Consulting |
DBA_PROFILES
<< Return to the index
Oracle 11g makes the following comments about the DBA_PROFILES table: "Display all profiles and their limits"
Related notes on DBA_PROFILES:
Column description of the DBA_PROFILES view:PROFILEDescription of DBA_PROFILES.PROFILE: "Profile name" RESOURCE_NAMEDescription of DBA_PROFILES.RESOURCE_NAME: "Resource name" RESOURCE_TYPENo comments exist for the RESOURCE_TYPE column of the DBA_PROFILES table. LIMITDescription of DBA_PROFILES.LIMIT: "Limit placed on this resource for this profile"
DBA_PROFILES View SourceOracle 11g's data dictionary defines the DBA_PROFILES view using the following source query:
select
n.name, m.name,
decode(u.type#, 0, 'KERNEL', 1, 'PASSWORD', 'INVALID'),
decode(u.limit#,
0, 'DEFAULT',
2147483647, decode(u.resource#,
4, decode(u.type#,
1, 'NULL', 'UNLIMITED'),
'UNLIMITED'),
decode(u.resource#,
4, decode(u.type#, 1, o.name, u.limit#),
decode(u.type#,
0, u.limit#,
decode(u.resource#,
1, trunc(u.limit#/86400, 4),
2, trunc(u.limit#/86400, 4),
5, trunc(u.limit#/86400, 4),
6, trunc(u.limit#/86400, 4),
u.limit#))))
from sys.profile$ u, sys.profname$ n, sys.resource_map m, sys.obj$ o
where u.resource# = m.resource#
and u.type#=m.type#
and o.obj# (+) = u.limit#
and n.profile# = u.profile#
 |
If you like Oracle tuning, see the book "Oracle
Tuning: The Definitive Reference", with 950 pages of tuning tips and
scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts. |
 |
 |
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
