Please use the below query for a period. SELECT to_char(rollup_timestamp,’DD-MON-YY HH24′) “Date”, average “CPU Usage %” FROM sysman.MGMT\$METRIC_HOURLY WHERE target_name like ‘%servername%’ AND metric_name = ‘Load’ AND metric_column =…
Read MorePlease create the below and disable or drop the trigger once completed. create or replace trigger set_trace after logon on database begin if user not in (‘SYS’,’SYSTEM’,’SYSMAN’,’OLAPSYS’) then execute…
Read MorePlease use the below. CREATE TABLE DBA.STATS$TOTALUSERS ( MEASURED_DATE DATE, TOTAL_USERS NUMBER, ACTIVE_USERS NUMBER ) TABLESPACE USERS PCTUSED 0 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K…
Read MorePlease use the below query. set line size 750 pages 9999 col box for a30 col username for a30 col spid for a30 col program for a30 col os_user for…
Read MorePlease use below query. col sql_text for a60 wrap set verify off set pagesize 999 set lines 155 col username format a13 col prog format a22 col sid format…
Read MorePlease follow the below steps col COMP_ID for a15 col COMP_NAME for a45 col STATUS for a20 set lines 100 pages 100 select COMP_ID,COMP_NAME,STATUS from dba_registry; COMP_ID COMP_NAME STATUS —————…
Read MoreSteps to Resize the Online Redo Logfiles >sqlplus /nolog SQL> connect / as sysdba SQL> select name,open_mode from v$database; NAME OPEN_MODE ——— ——————– PROD READ WRITE Please check the below…
Read MorePlease use the below script. #!/bin/ksh file1=$1 file2=$2 for parameter in `cat $file1 | grep = | awk ‘{print $1}’ | grep -v ‘#’` do value1=`grep ^$parameter $file1 |…
Read MorePlease use the below query. SELECT DISTINCT(TRUNC(last_refresh)) FROM dba_snapshot_refresh_times; select owner, mview_name, last_refresh_type, last_refresh_date from dba_mviews;
Read MorePlease use the below query. SELECT name FROM sys.user$ WHERE ext_username IS NOT NULL AND password = ‘GLOBAL’;
Read More