Search

Top 60 Oracle Blogs

Recent comments

Jonathan Lewis's tweets

A golden oldie - but with an update that says things got worse in 18.3.0.0: the overhead of "set role" in your code: https://t.co/5VihoM3QUh3 hours 31 min ago
Today's little irritant - dbms_diag.accept_sql_patch (i.e. from an SQL tuning task) includes a FORCE_MATCH option,… https://t.co/DOAErtR2953 hours 54 min ago
@codehater @fritshoogland A question worth pursuing - but probably not. The session has to find a profile from the… https://t.co/dHaCuTvaQS1 day 3 hours ago
Here's a golden oldie that starts out with column groups, but ends up highlighting the importance of thinking about… https://t.co/VL6Gswarq91 day 20 hours ago
@fritshoogland Which means you can get a huge “pct miss” in the library cache activity report under SQL AREA in the AWR report. — 1 day 21 hours ago
@oraclebase It means you should stop flying off on all these international tours and spend the money you save on a proper barber. — 2 days 5 hours ago
Here's a quirky little aberration that I hadn't noticed before, relating to upgrading to 12.2.0.1:… https://t.co/5BZEhIIZQ03 days 5 hours ago
@NiceTheoryVidar @sqldaily @DBoriented insert /*+ append */ into local_table select from remote_table does append,… https://t.co/9UX4nLCYKI3 days 22 hours ago
RT @ToonKoppelaars: Join me at #OUGIreland19 on 4-5 Apr – I’ll be speaking on AWR reports. Take a look at the agenda and register today. ht… — 3 days 22 hours ago
This came out on auto-pilot earlier on today - I'd forgotten it was due. A little piece (possibly contentious) on h… https://t.co/VPYXSEPlhT4 days 19 hours ago