Saved Searches

    You have no Saved Searches ...

    Breadcrumb

    Search Results

    All

    Results Timeline Dynamic

    • This talk details the architecture of Oracle Berkeley DB that has made it the reliable, high performance database library that has served the open source community for over 20 years.

       
    • Oracle Grid Infrastructure 12 includes an integrated feature that enables simple, low-risk and large-scale deployment and maintenance of software homes across all nodes of a database estate. This demo deploys and starts a three-node 11.2.0.4 Oracle RAC Database.
       
      Oracle Contributor
    • Rapid Home Provisioning includes simple commands to performing rolling updates (patches) and upgrades of Oracle Grid Infrastructure. This recording shows the process to easily switch a 12.1.0.2 GI deployment to a patched home.

       
      Oracle Contributor
    • RHP is a feature of Grid Infrastructure 12 which enables rolling RAC patching with a single command. This demo also shows Application Continuity protecting a running workload, so that end users so no impact from the maintenance operation. For more collateral visit http://www.oracle.com/goto/rhp

       
      Oracle Contributor
    • Rapid Home Provisioning can upgrade an Oracle Database - Single Instance, RAC One Node or RAC - with a single command. This recording shows a sample environment and the flow of the operation.

       
      Oracle Contributor
    • Oracle Grid Infrastructure 12.1 introduced Rapid Home Provisioning, an integrated feature that enables low-risk, large-scale deployment and maintenance of software homes in your Oracle Database Estate.  This demo shows the single command that provisions and starts on new cluster from a centralized server.

      See http://www.oracle.com/goto/rhp for more collateral 

       
      Oracle Contributor
    • This video walks through the install of the pre-built binaries and the features of the application. 

       
    • Bulk processing (FORALL and BULK COLLECT), along with the function result cache, are the "big ticket" items when it comes to performance optimization with PL/SQL. But there's still more we can do to tweak our code for even better response times for our users. This third webast in the series starts with the automatic compiler optimization, showcases the extraordinary speediness of PGA data manipulation (a.k.a., package variables), and demonstrates the effect of the simple NOCOPY hint. We finish up with an introduction to pipelined table functions and some thoughts on optimizing your algorithms.

       
    • Watch as Steven explains what he means by hard-coding in PL/SQL.

       
      Oracle Contributor
    • That's right. VARCHAR2 declarations mean that you have to provide an "N" or constraint on the size of the variable. If you have such declarations all over your code, that's a form of hard-coding and you are likely to get hammered by VALUE_ERROR exceptions. This video shows how to fix this problem.

       
      Oracle Contributor
    • Since we write software using our brains, it is hard to avoid the impact of psychology and physiology of our brains on our code. This manifests quite clearly when it comes to hard-coding.

       
      Oracle Contributor
    • For DBAs looking to streamline the process of cloning a database for development and test efforts, the Oracle Snap Management Utility (SMU) for Oracle Database may help solve that need. The SMU software coordinates storage cloning from the Oracle ZFS Storage Appliance with the process to mount the new clone to a database host from a single interface. Take cloning for development databases from weeks to minutes and accelerate dev/test with SMU.


      Scott Ledbetter, Oracle Application Integration Engineer, shows how to easily clone an Oracle database instance using the Oracle Snap Manager Utility for Oracle Database. To learn more and obtain a free trial, go to http://oracle.com/storage/nas/snap/in....

       

       
    • Consistent, robust error management is a critical feature of any successful application. Developers need to know all that is possible in PL/SQL regarding the raising, handling and logging of errors, and that standardize the way in which those tasks are performed.
       
      Steven goes beyond the basics of exception handling in PL/SQL to explore the wide range of specialized error management features in Oracle. We will cover FORALL's SAVE EXCEPTIONS, DML error logging with the DBMS_ERRLOG package, the AFTERSERVERERROR trigger, the DBMS_UTILITY.FORMAT_ERROR_BACKTRACE function, and more. 
       
      In addition to covering error-related functionality, we'll also take a look at using assertion procedures to validate assumptions and execution tracing to better understand what is happening in your code.
       
    • Consistent, robust error management is a critical feature of any successful application. Developers need to know all that is possible in PL/SQL regarding the raising, handling and logging of errors, and that standardize the way in which those tasks are performed.
       
      Steven goes beyond the basics of exception handling in PL/SQL to explore the wide range of specialized error management features in Oracle. We will cover FORALL's SAVE EXCEPTIONS, DML error logging with the DBMS_ERRLOG package, the AFTERSERVERERROR trigger, the DBMS_UTILITY.FORMAT_ERROR_BACKTRACE function, and more. 
       
      In addition to covering error-related functionality, we'll also take a look at using assertion procedures to validate assumptions and execution tracing to better understand what is happening in your code.
       

    Filters

    Search Criteria