Lutz Haake | Freelance Oracle Consultant

https://anargodjaev.wordpress.com/2013/12/17/how-to-cleanup-orphaned-datapump-jobs-from-dba_datapump_jobs/

The customer was experi­encing off SQL*net problems, so I did a client side trace. The tracing worked just…

Use the sys_extract_utc() function to convert systi­mestamp to UTC before comparing ntimestamp#! select * from sys.aud$…

http://www.google.com/patents/US20040225639

After patching 11.2.0.3.12, the “top activity” view in OMS12c stpped working properly. The calendar control in…

This is how to display the exact kind of hints included in a SQL patch or SQL…

Need to drop a database link in another user’s schema? This is how. define link_name='SOME_DBLINK' define link_owner='SOME_OWNER' declare…

Using the WITH CLAUSE, loops and even nested loops can be imple­mented using plain SQL. To illus­trate…

dba_hist_event_histogram holds a lot of infor­mation which can prove useful when analyzing the overall system performance. To…

SQL patches are used to add hints to SQL state­ments that you cannot modify directly. This…