Follow Oracledbwr's news and updates in a matter of seconds! We will deliver any update via email, phone or you can read them from here on the site on your own news page.
You can even combine different feeds with the feed for Oracledbwr.
Subscribing and unsubscribing is fast, easy and risk free.
The whole service is free of cost.
Oracledbwr: Oracledbwr
Is this your feed? Claim it!
Query to check history of SQL from AWR
set lines 255
col execs for 999,999,999
col avg_etime for 999,999.999
col avg_lio for 999,999,999.9
col begin_interval_time for a30
col node for 99999
break on plan_hash_value on startup_time skip 1
select ss.snap_id, ss.instance_number node, begin_i...
Find Tablespace Growth History In Oracle
Find Tablespace Growth History In Oracle
set serverout on
set verify off
set lines 300
set pages 3000
DECLARE
v_ts_id number;
v_ts_name varchar2(200) := UPPER(‘&Tablespace_Name’);
v_ts_block_size number;
v_begin_snap_id numbe...
Oracle jobs to start and stop
Running a Job Manually
If you want to run a job immediately, call the dbms_scheduler.run_job procedure.
begin
dbms_scheduler.run_job (job_name => ‘oracledbwr’);
end;
/
This causes the named job to be run immediately.
Stopping Ru...
Find oracle shared pool is usage
select
sum(a.bytes)/(1024*1024) shared_pool_used,
max(b.value)/(1024*1024) shared_pool_size,
(max(b.value)/(1024*1024))-(sum(a.bytes)/(1024*1024)) shared_pool_avail,
(sum(a.bytes)/max(b.value))*100 shared_pool_pct
from v$sgastat a, v$parameter b
where a.name in (
‘...
Gather and schedule Oracle table statistics via the operating system crontab
#!/bin/bash
export ORACLE_SID=oracledbwr
export ORACLE_BASE=/oracle
export ORACLE_HOME=/oracle/product/19c/db_1
PATH=$ORACLE_HOME/bin:$PATH
export PATH
sqlplus -s / as sysdba <<EOF
set echo on
set headi...