+1 401 783 6172 (International callers)
gary@skillbuilders.com
Request Info
Register Login

Login/Register to Access all of Skillbuilders' Content

Connect with:

Login with Facebook Login with Google Login with LinkedIn

Login with your site account

Connect with:

Login with Facebook Login with Google Login with LinkedIn


Lost your password?

Not a member yet? Register now

SkillBuildersSkillBuilders
  • Services
    • Oracle APEX Hosting on AWS
    • Oracle Database Admin/Remote DBA
    • Oracle APEX App Development
    • APEX Administration
  • Products
    • Oracle Database Manager (free)
    • Deprecated APEX Plugins
  • Training
    • Course Calendar
    • Oracle DBA
    • Oracle Developer
    • Oracle APEX
    • Web Development
    • Free Webinars
    • Mentoring
    • Free Oracle Database Tutorials
      • Free Oracle Database Administration Tutorials
      • Free Oracle Developer Tutorials
      • Free Oracle APEX Tutorials
      • Free Solaris 11, Oracle VM and ZFS Tutorials
      • Free Oracle Database Retired Tutorials
      • Free Groovy and Grails Tutorials
  • Blog
  • About
    • About Us
    • Our Team
    • Events
    • Case Studies
      • Oracle Database Administration
      • Oracle APEX Development
      • Oracle APEX Administration
      • Oracle and AWS Cloud
    • Client Testimonials
    • Contact
    • Services
      • Oracle APEX Hosting on AWS
      • Oracle Database Admin/Remote DBA
      • Oracle APEX App Development
      • APEX Administration
    • Products
      • Oracle Database Manager (free)
      • Deprecated APEX Plugins
    • Training
      • Course Calendar
      • Oracle DBA
      • Oracle Developer
      • Oracle APEX
      • Web Development
      • Free Webinars
      • Mentoring
      • Free Oracle Database Tutorials
        • Free Oracle Database Administration Tutorials
        • Free Oracle Developer Tutorials
        • Free Oracle APEX Tutorials
        • Free Solaris 11, Oracle VM and ZFS Tutorials
        • Free Oracle Database Retired Tutorials
        • Free Groovy and Grails Tutorials
    • Blog
    • About
      • About Us
      • Our Team
      • Events
      • Case Studies
        • Oracle Database Administration
        • Oracle APEX Development
        • Oracle APEX Administration
        • Oracle and AWS Cloud
      • Client Testimonials
      • Contact

    John Watson

    • Home
    • Author John Watson
    20 July

    Installing Database 19c on Oracle Linux 8

    • Posted by John Watson
    • Categories Blog

    Database release 19.7 (ie, 19c with the April 2020 RU) is at last certified for OL8, but there may be some hacking needed to get it installed. This certification is long overdue: our security admin has been pushing for the …

    Read More
    02 June

    Controlling distributed queries with hints

    • Posted by John Watson
    • Categories Blog

    Recently I’ve been working on tuning some distributed queries. This is not always straightforward. This is not a comprehensive discussion of the topic, rather a description of how one might approach the problem. The query I’m using for this demonstration …

    Read More
    22 February

    Database 20c docs

    • Posted by John Watson
    • Categories Blog, RDBMS Server

    Now available! https://docs.oracle.com/en/database/oracle/oracle-database/20/books.html Going through the New Features guide, there is a shed load of wonderful enhancements. Then you look at the Licensing guide, and most of them require Exadata or Oracle Cloud or both.

    Read More
    24 December

    How to move a table from one schema to another

    • Posted by John Watson
    • Categories Blog, RDBMS Server

    Many times I’ve seen the question on forums “How can I move a table from one schema to another?” and the answer is always that you can’t. You have to copy it. Or export/import it. Well, here’s a way. It …

    Read More
    04 November

    19c Standard Edition permits 3 PDBs per CDB

    • Posted by John Watson
    • Categories Blog, RDBMS Server

    A very nice licensing change in 19c: you can now have up to three PDBs in a Standard Edition Multitenant database. Apart from the obvious advantage of being able to do some database consolidation, it gives SE2 users the ability …

    Read More
    27 August

    Privilege Analysis included in Oracle Database 19c Enterprise Edition

    • Posted by John Watson
    • Categories Blog

    What is Privilege Analysis (included in Oracle Database 19c Enterprise Edition) Database 19c is nothing more than the re-badging of release 12.2.0.3: the terminal 12c release that will have extended support until March That having been said, there are a …

    Read More
    23 January

    12.2 upgrade – it can break all your outgoing https calls

    • Posted by John Watson
    • Categories Blog

    Do you know about multiple domain certificates? If not you may have to learn quickly, because Oracle has changed the way they are handled in release 12.2. This is going to break a lot of applications. A multiple domain certificate …

    Read More
    05 January

    Upgrading to 12.2 ? Make sure you won’t break JSON

    • Posted by John Watson
    • Categories Blog

    Will upgrade from 12.1 to 12.2 break your applications? It may if your developers are using JSON. In both release 12.1 and 12.2, there are these keywords: orclx> select * from v$reserved_words where keyword like ‘JSON%’ order by 1; KEYWORD …

    Read More
    27 April

    Oracle Database Manager, a Free Management Tool

    • Posted by John Watson
    • Categories News

    SkillBuilders Oracle Database Manager (SB-ODM) is a FREE lightweight Oracle database administration tool. SB-ODM is EASY To USE! It’s chock-full of features for everyday administration tasks including rman backup, datapump database export, datapump database import, apex exports, storage management, Oracle …

    Read More
    12 April

    12cR2 lots of new instance parameters

    • Posted by John Watson
    • Categories Blog, RDBMS Server

    Comparing database 12cR1 release 12.1.0.2 to 12cR2 release 12.2.0.0.3, I see these new parameters: adg_imc_enabled TRUE Enable IMC support on ADG allow_global_dblinks FALSE LDAP lookup for DBLINKS allow_group_access_to_sga FALSE Allow read access for SGA to users of Oracle owner group …

    Read More
    31 March

    Tuning with equivalent SQLs – a little challenge

    • Posted by John Watson
    • Categories Blog

    I am fascinated by what I call “equal SQL”: statements that are equivalent, in that they deliver the same result but may have hugely different performance characteristics. Here’s a little case study. Consider this example, working in the OE demonstration …

    Read More
    01 November

    Compression test, 12cR2

    • Posted by John Watson
    • Categories RDBMS Server

    HCC is available only on Oracle supplied storage, such as a ZFS storage appliance or (as in this case) an Exadata engineered system. Furthermore, it occurs only for direct loads: in my examples, using CTAS. This is the script I’m …

    Read More

    Copyright © Skillbuilders.com

    Interested in joining our team?

    View details
    Managed APEX Hosting on AWS

    Sorry. This form is no longer accepting new submissions.