最近,客户说他们Oracle EBS数据库增长的特别快,需要查看一下是哪些用户启用了日志收集没有关掉。通过System Administrator>Profile>System(配置文件)不能一次查询所有与调试相关的配置,所以比较麻烦。因此,从后台一次查询所有与日志收集相关的数据,如下:
WITH LevelType AS
(SELECT 10001 Level_Id ,'地点' Level_Name FROM Dual UNION
SELECT 10002 Level_Id ,'应用产品' Level_Name FROM Dual UNION
SELECT 10003 Level_Id ,'责任' Level_Name FROM Dual UNION
SELECT 10004 Level_Id ,'用户' Level_Name FROM Dual UNION
SELECT 10005 Level_Id ,'服务器' Level_Name FROM Dual UNION
SELECT 10006 Level_Id ,'组织' Level_Name FROM Dual)
SELECT Op.Profile_Option_Id
,Tl.Profile_Option_Name
,Tl.User_Profile_Option_Name
,LevelType.Level_Id
,LevelType.Level_Name
,Va.Level_Value
,CASE
WHEN Va.Level_Id = 10001 THEN
'地点'
WHEN Va.Level_Id = 10002 THEN
(SELECT Fav.Application_Name
FROM F