Dの小部屋

忘れやすい私のメモ帳

ログスイッチの状況確認

日毎 SQL set pages 1000 with date_history as ( select to_char(first_time,'yyyy/mm/dd') first_date from v$log_history ) select first_date, count(*) cnt from date_history group by first_date order by first_date; 結果 FIRST_DATE CNT ---------…

システム権限の表示(ロールに付加している権限も表示)

SQL文 with roleinfo as ( select connect_by_root grantee as grantee, granted_role from sys.dba_role_privs start with grantee in (select username from dba_users) connect by prior granted_role = grantee ) select distinct grantee, privilege fr…