OracleNotes

Blog

  • #OOW19 Session: It’s all in the presentation of data!

    #OOW19 Session: It’s all in the presentation of data!

    Date: Tuesday, 2019-SEP-17 11:15 AM
    Location: Moscone West – Room 3020A
    Room Setup: OPEN AIR – AUDIENCE HEADSETS
    Session: CON2173

    Abstract:
    DBAs usually collect a lot of data and present it in a tabular format, but management and users like and understand visual representation of data better. The tabular format does not make the impact or get the attention you desire. Attend this session to see how easily you can convert those tabular formats to pictures using the free and open-source Google Charts. Google Charts is a pure JavaScript-based charting library to enhance web applications by adding interactive charting capability. This session includes two demos and is geared for DBAs, architects, and sysadmins who present data to end-users or management.

    Though my abstract sounds this as a DBA specific session, it is not. Developers and end-users (even managers) who use SQL to get data from a database for reporting purposes will benefit from this session on using Google Charts. I first got a taste of Google Charts from EBD360 (Carlos Sierra) and SQLD360 (Mauro Pagano) tools. [Note: If you are DBA and not familiar with these tools, you must download the latest SQLDB360, which includes both tools]. The reports from these tools use Google charts extensively. Thought it would be hard to learn, and never tried until I saw a presentation by Kapil Goyal on Database Capacity planning. He used Google charts extensively. A short chat with him revealed that it is not hard to learn Google Charts if you can generate a dataset from the database to draw charts. He also graciously shared the db_capacity.sql script with me (thank you, Kapil).

    So here we are, my session is about drawing pie charts, line charts, bar charts, etc using Google charts. The SQL templates I provide can be used to generate your own HTML reports. The ZIP file you download from OOW Session Catalog will include the session slides as well as the template files. See you on Sep 17th @ 11:15 AM #OOW19

    SQL*Plus HTML Formatting Attributes

    SQL Data embedded in HTML file

  • Oracle Tidbits: August 2019 #OraTidbit

    Oracle Tidbits: August 2019 #OraTidbit

    “Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in August 2019. Hope you find these helpful to learn something new or to remind you of its existence and use.

    #Oratidbit Fast-Start Failover (FSFO) is a feature of the Oracle Data Guard Broker that enables an automatic failover to the standby database upon failure of the primary. FSFO can be configured in either an active or an Observer only mode.
    #OrclEBS #OracleCloud Oracle E-Business Suite Cloud Manager provides a graphical user interface for creating, managing, configuring, migrating Oracle E-Business Suite environments on Oracle Cloud Infrastructure (OCI).
    #OraTidbit You can use Oracle Enterprise Manager to discover and manage dedicated Autonomous Transaction Processing databases, if you are using Enterprise Manager version 13.3 with EM DB Plugin Bundle Patch 13.3.2.0.190731 or higher.
    #OraTidbit #SQLDev Oracle SQL Developer Web provides a development environment and a data modeler interface for Oracle Autonomous Databases (ATP/ADW).
    #OraTidbit #OracleCloud #OCI The minimum retention requirement for Archive Storage is 90 days. If you delete objects from Archive Storage before the minimum retention requirements are met, you are charged a deletion penalty.
    #OraTidbit #OracleCloud #OCI Oracle Cloud Infrastructure offers 1-node DB systems on either bare metal or virtual machines, and 2-node RAC DB systems on virtual machines.
    #OraTidbit #OracleCloud #OCI When you enable Data Guard for a virtual machine DB system database, a new DB system with the standby database is created. For bare metal DB system, DB system to be used as the standby must already exist before you enable Data Guard.
    #OraTidbit #OracleCloud Oracle Functions is a fully managed, highly scalable, on-demand, Functions-as-a-Service platform, built on #OCI and powered by the Fn Project open-source engine. Access Oracle Functions using the Console, a CLI, and a REST API.
    #OraTidbit #OracleCloud The #OCI Health Checks service provides high-frequency external monitoring to determine the availability and performance of any publicly facing service, including hosted websites, API endpoints, or externally facing load balancers.
    #OraTidbit #OracleCloud The #OCI Monitoring service actively and passively monitor your cloud resources using the Metrics (to monitor resources) and Alarms (to notify you when these metrics meet alarm-specified triggers) features.
    #OraTidbit #OracleCloud #ThinkAutonomous The data_pump_dir directory is available in an Autonomous database. You can now use CREATE DIRECTORY and DROP DIRECTORY commands to create and drop additional directories.
    #OraTidbit The I/O calibration feature of #OrclDB is using the DBMS_RESOURCE_MANAGER.CALIBRATE_IO procedure- issues one megabyte of random I/O intensive read-only I/Os to the database files to determine the maximum IOPS and MBPS that can be sustained by the storage subsystem.
    #OraTidbit #DB19c Real-Time Statistics feature is when a DML operation is currently modifying a table, Oracle Database dynamically computes values for the most essential statistics. The NO_GATHER_OPTIMIZER_STATISTICS hint prevents the collection of real-time statistics.
    #OraTidbit #DB19c If real-time statistics are available, then you can access them using DBA_TAB_COL_STATISTICS and DBA_TAB_STATISTICS views. Real-time statistics are indicated by STATS_ON_CONVENTIONAL_DML in the NOTES column and SHARED in the SCOPE column.
    #OraTidbit The Oracle Data Masking and Subsetting (DMS) pack of the Oracle Enterprise Manager (OEM) provides an automated, flexible, and easy-to-use solution that masks and subsets sensitive production data, allowing data to be shared safely across a non-production environment
    #OraTidbit #OracleVM The Oracle VM Paravirtual Drivers for Microsoft Windows improve performance for network and block (disk) devices on Microsoft Windows guests running in a virtual environment on Oracle VM.
    #OraTidbit #OracleVM Oracle VM provides support for Hybrid Columnar Compression (HCC) on Oracle Database Release 18c (or higher) with Oracle ZFS Storage Appliance and Oracle FS1 Series Flash Storage Systems.
    #OraTidbit #OracleVM Enabling viridian support ensures improved performance for all Microsoft Windows guest operating systems on Oracle VM. Viridian support enables the exposure of Windows virtualization compatible entitlements to Microsoft Windows guest operating systems.
    #OraTidbit #OracleVM Oracle Enterprise Manager Release 13.2 or later is required to manage Oracle VM Release 3.4.x. Oracle VM Manager integrates with OEM so that you can manage the entire Oracle VM environment from within OEM.
    #OraTidbit #Vagrant is an open-source software product for building and maintaining portable virtual software development environments, for #VirtualBox, KVM, Hyper-V, #Docker containers, #VMware, and #AWS.
    #OraTidbit #ThinkAutonomous Oracle Autonomous Database (ADW/ATP) allows CREATE DIRECTORY statement to create directories. If the file system directory exists then CREATE DIRECTORY only creates the database directory object.
    #OraTidbit #ThinkAutonomous You can create directories in Oracle Autonomous Database (ADW/ATP). CREATE DIRECTORY command creates the necessary directories and subdirectories on the OS side for you.
    #OraTidbit #ThinkAutonomous Autonomous Database (ADW/ATP) allows user directories. Since there is no OS access to ATP/ADW machines, use DBMS_CLOUD.LIST_FILES function to list files in a directory. Use DBMS_CLOUD.DELETE_FILE function to remove a file.