Oracle Free Table Space Across Files
define tsname undefine tsname # Put your tablespace name in here define tsname=”%USER%” select df.tablespace_name, fs.GB_FS_BefAuto, df.GB_Tot_Space_BefAuto “Total Space Allocated”, […]
define tsname undefine tsname # Put your tablespace name in here define tsname=”%USER%” select df.tablespace_name, fs.GB_FS_BefAuto, df.GB_Tot_Space_BefAuto “Total Space Allocated”, […]
alter session set nls_date_format=’dd-mon-yy hh24:mi’; SELECT A.*, Round(A.Count#*B.AVG#/1024/1024) HOURLY_Avg_Mb FROM (SELECT To_Char(First_Time,’YYYY-MM-DD HH24′) HOUR, Count(1) Count#, Min(RECID) Min#, Max(RECID) Max# FROM v$log_history GROUP BY To_Char(First_Time,’YYYY-MM-DD HH24′) ORDER BY
–set the SLA? –Use a logon trigger to set the maximum delay –whenever a user logs into the standby —
The following view shows Data Guard standby lag via a histogram updated every second since the instance was last booted.
I was patching an Oracle ASM grid oracle db standalone infrastructure and ran across the error with opatchauto “Patch Location
Overview Here is the process I used to apply the Oracle 2016 PSU 22191676 to Grid / Oracle Stand Alone
Purpose How to setup a device on Oracle Virtual Box – and use that device for a Oracle stand alone
Want more bash history than the default – try this in your .bashrc. Then save them to a file with
Want to know for certain if your dataguard standby is in REAL TIME APPLY mode? Here is how – execute