OracleNotes

Blog

  • Oracle Tidbits: September 2020 #OraTidbit

    Oracle Tidbits: September 2020 #OraTidbit

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

    #OraTidbit #OracleCloud #AutonomousDB Sep 2020 #New: Refreshable clone of Autonomous DB. With a refreshable clone, the system creates a clone that can be easily updated with changes from the source database.
    #OraTidbit #OracleLinux #Linux Spacewalk provides a set of tools for managing the Oracle Linux software life cycle. Spacewalk helps to automate a kickstart installation, system configuration, and maintenance tasks, which enables you to rapidly deploy proven and consistent software configurations for Oracle Linux systems.
    #OraTidbit #db19c Automated Transaction Draining for Oracle Grid Infrastructure Upgrades provides automatic draining of transactions against the database instances one node at a time in a rolling fashion according to the database service configurations.
    #OraTidbit #OracleCloud Oracle #DataSafe supports Oracle Databases on Compute instances in OCI by using an Oracle Data Safe private endpoint. The Compute instance and the Oracle Data Safe private endpoint reside on your private virtual cloud network (VCN), and the Oracle Data Safe service resides on the Oracle Data Safe VCN.
    #OraTidbit #OracleCloud (Finally!) You can configure compute virtual machine (VM) instances to remain stopped after a maintenance event affects the underlying infrastructure, instead of being automatically rebooted. This lets you restart the instance on your own schedule.
    #OraTidbit #OrclDB Oracle Database AutoUpgrade enables you to upgrade one or many databases without human intervention all with one command and with a single configuration file. AutoUpgrade runs the preupgrade tasks, performs automated fix-ups where needed, runs the database upgrade, and finishes by completing post-upgrade tasks.
    #OraTidbit #OracleCloud Oracle Exadata Cloud@Customer uses virtual machine (VM) technology to separate the customer-managed and components managed by Oracle on each compute node. You have root privilege for the Oracle Exadata compute node VMs. You do not have administrative access to the physical compute node hardware, which Oracle administers.
    #OraTidbit #OracleCloud Oracle Exadata Cloud@Customer uses Oracle Exadata Storage Servers for database storage. The storage is allocated to disk groups managed by Oracle ASM. You have full administrative access to the Oracle ASM disk groups, but Oracle administers the Oracle Exadata Storage Server hardware and software.
    #OraTidbit Centrally managed users in #OrclDB provides a simpler integration with Microsoft Active Directory to allow centralized authentication and authorization of users. This integration enables organizations to use Active Directory to centrally manage users and roles in multiple Oracle databases with a single directory along with other Information Technology services.
    #OraTidbit #OrclDB Zero-downtime Oracle Grid Infrastructure Patching enables patching of Oracle Grid Infrastructure without interrupting database operations. Patches are applied out-of-place and in a rolling fashion, with one node being patched at a time, while the database instances on the node remain operational.
    #OraTidbit #OracleLinux The Oracle Cloud Infrastructure OS Management service allows you to manage updates and patches for the operating system environment on your Oracle Cloud Infrastructure instances. The OS Management service is an agent-based service.
    #OraTidbit #OracleCloud Cloud Guard is a cloud-native service that helps customers monitor, identify, achieve, and maintain a strong security posture on Oracle Cloud. Use the service to examine your Oracle Cloud Infrastructure resources for security weakness related to configuration, and your Oracle Cloud Infrastructure operators and users for risky activities. Upon detection, Cloud Guard can suggest, assist, or take corrective actions, based on your configuration.
    #OraTidbit #OracleCloud The Oracle Data Cloud platform is an enterprise-level, cloud-based tool that enables you to organize and categorize your consumer data from all sources, including your website, CRM database, and mobile apps, into a single hierarchical taxonomy.
    #OraTidbit #OracleCloud Oracle Fusion Analytics Warehouse enables you to analyze your Oracle Applications Cloud data and generate visualizations and reports. This packaged service includes Oracle Analytics Cloud, extracts data from your Oracle Applications Cloud into an instance of Oracle Autonomous Data Warehouse.
    #OraTidbit #OracleCloud Oracle Fusion Analytics Warehouse (FAW) formerly known as Oracle Analytics for Applications (OAX) is built on top of Oracle Analytics Cloud (OAC) and is powered by Oracle Autonomous Data Warehouse (ADW).
    #OraTidbit #AutonomousDB You can select an Autonomous Database operation mode. The default mode is Read/Write. If you select Read-Only mode users can only run queries. In addition, for either mode, you can restrict access to only allow privileged users to connect to the database.
    #OraTidbit #AutonomousDB Autonomous Database includes extensive, sophisticated audit capabilities to track, monitor, and record database actions. In addition to default auditing, you can configure Oracle Data Safe and configure Oracle Database Audit Policies.
  • Oracle Tidbits – August 2020 #OraTidbit

    Oracle Tidbits – August 2020 #OraTidbit

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

    #OraTidbit #OrclDB When gathering optimizer statistics manually, you can reproduce the object prioritization of automatic collection by using the DBMS_AUTO_TASK_IMMEDIATE package. This package runs the same statistics gathering job that is executed during the automatic nightly statistics gathering job.
    #OraTidbit #OrclDb To check whether optimizer statistics are stale, query the STALE_STATS column in DBA_TAB_STATISTICS and DBA_IND_STATISTICS. Values: YES-The statistics are stale. NO-The statistics are not stale. null-The statistics are not collected.
    #OraTidbit #AutonomousDB New in August 2020: If the #ADW/#ATP database version is 19c or higher, you can rename the Autonomous Database. After you rename a database, download a new wallet. Applications also must be updated to use the new connection string.
    #OraTidbit Oracle Data Safe helps to understand the sensitivity of data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements. You can use #DataSafe with #AutonomousDB.
    #OraTidbit Enabling block change tracking (BCT) facilitates fast incremental backups. Using BCT for Fast Incremental Backup on Physical Standby requires Oracle Active Data Guard option.
    #OraTidbit #db20c The result cache in an Active Data Guard standby database is utilized to cache results of queries that were run on the physical standby database. In the case of a role transition to primary the standby database result cache will be preserved ensuring performance for offloaded reporting and other queries continue without compromising the performance benefits of the standby result cache.
    #OraTidbit #db20c A new PL/SQL package called DBMS_FLASHBACK_ARCHIVE_MIGRATE enables the migration of Flashback Data Archive enabled tables from a database on any release (in which the package exists) to any database on any release (that supports Flashback Data Archive).
    #OraTidbit #db20c The SQL set operators now support all keywords as defined in ANSI SQL. The new operator EXCEPT [ALL] is functionally equivalent to MINUS [ALL]. The operators MINUS and INTERSECT now support the keyword ALL.
    #OraTidbit #db20c Init parameter MAX_IDLE_BLOCKER_TIME sets the number of minutes that a session holding needed resources can be idle before it is a candidate for termination. MAX_IDLE_TIME sets limits for all idle sessions, whereas MAX_IDLE_BLOCKER_TIME sets limits only for idle sessions consuming resources.
    #OraTidbit #db20c You can configure database clients to maintain multiple Secure Sockets Layer (SSL) sessions using different SSL certificates. Useful for database clients simultaneously connecting to various cloud databases, each with a separate certificate.
    #OraTidbit #db20c Convert a set of existing databases running the same application into a sharded database without modifying the database schemas or the application (Federated Sharding). The databases can be geographically distributed and can have some differences in their individual schemas.
    #OraTidbit #db20c Oracle ASM Flex Disk Group Support for Cloning a pluggable database (PDB) in One multitenant container database (CDB) to a New PDB in a Different CDB in 20c. Previously point-in-time database clones could only clone a PDB in a CDB to a new PDB in the same CDB.
    #OraTidbit #db20c Blockchain tables are append-only tables in which only insert operations are allowed. Deleting rows is either prohibited or restricted based on time. Rows in a blockchain table are made tamper-resistant by special sequencing & chaining algorithms.
    #OraTidbit #OracleCloud Oracle #Blockchain Platform gives a pre-assembled platform for building and running smart contracts and maintaining a tamper-proof distributed ledger.
    #OraTidbit #OracleCloud #AutonomousDB #JSON Autonomous JSON Database is an Oracle Cloud service that is specialized for developing NoSQL-style applications that use JavaScript Object Notation (JSON) documents. To provision, click Autonomous JSON Database from the OCI left navigation list.
    #OraTidbit Oracle Trace File Analyzer generates a real-time health summary report, which shows performance degradation due to faults and workload issues. The health summary consists of scores in the categories of availability, health, workload, and capacity broken down from cluster-wide through the database, instance, service, and hardware resource.
    #OraTidbit #OracleCloud Secure Global Desktop (SGD) is a secure remote access solution for cloud-hosted enterprise applications and desktops that run on Microsoft Windows, Linux, Solaris, and mainframe servers. The difference between SGD and SSH or VPN is that the client never enters the network and the administrator of SGD controls all access, including client features such as copy and paste, printing or device access.