Want to turn off / disable Oracle's automatic tasks ( dbms_auto_task_admin.disable ):
note: be careful copying the code below from Windows to Unix as a Windows copy may corrupt the single quotes […]
note: be careful copying the code below from Windows to Unix as a Windows copy may corrupt the single quotes […]
While many Oracle features are turned on by default, that does not necessarily mean you are using them. If you
12c? Yes, but not for the features Oracle wants you to like. So far anyway, I’m not seeing much use
Here are a few tidbits (not comprehensive – I’ll leave that to Oracle) about “oraInventory”. Generally, it’s directory structure containing
This is not advanced troubleshooting and does not address mis-configurations. But, if your OEM agent is not communicating with OMS
Here is an example of how to run Oracle new command line SQLCI tool – a super sqlplus based on
jdbc:oracle:thin:[USER/PASSWORD]@[HOST][:PORT]:SID jdbc:oracle:thin:[USER/PASSWORD]@//[HOST][:PORT]/SERVICE
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 —