OracleNotes

Blog

  • Oracle TidBits – July 2020 #OraTidBit

    Oracle TidBits – July 2020 #OraTidBit

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

    #OrclDB #db20c Starting in Oracle Database 20c, the parameter to enable or disable password file case sensitivity is removed. All passwords in 20c password files are case-sensitive.
    #OraTidbit #OrclDB Oracle Blockchain tables are append-only tables in which only insert operations are allowed. Deleting rows is either prohibited or restricted based on time.
    #OraTidbit #OrclDB #db20c allows an expression when setting the value of an initialization parameter. This allows us to optimize the values set in initialization parameters when they depend on environmental characteristics, such as system configurations, run-time decisions, or the values of other parameters by using expressions.
    #OraTidbit #AutonomousDB With Autonomous Data Guard, the standby database is created in the same region as the primary database. If the region has multiple Availability Domains, the standby database is provisioned in a different availability domain than the primary database.
    #OraTidbit #AutonomousDB July 2020 Feature: You can create database links from an Autonomous Database to an Oracle Database Gateway to access Non-Oracle databases.
    #OraTidbit #GoldenGate Oracle GoldenGate Monitor is a real-time, Web-based monitoring console that delivers an at-a-glance, graphical view of all of the Oracle GoldenGate instances and their associated databases within your enterprise.
    #OraTidbit #OraleCloud #DataSafe is a unified control center for managing database security in the Oracle Cloud. Data Safe provides an integrated set of features enabling users to understand the sensitivity,
    evaluate risks, mask, implement security controls, assess user security, monitor user activity, and address data security compliance requirements.
    #OraTidbit #SE#db19c Oracle Database Standard Edition High Availability (available from 19.7) provides cluster-based failover for single-instance Standard Edition Oracle Databases using Oracle Clusterware.
    #OraTidbit (from the Oracle database licensing doc) Oracle Automatic Storage Management (Oracle ASM) is free to use with all Oracle databases and Oracle ACFS file systems (including Oracle Standard Edition).
    #OraTidbit Oracle Enterprise Data Quality (EDQ) provides a comprehensive data quality management environment that is used to understand, improve, protect, and govern data quality. EDQ facilitates best practice master data management, data integration, business intelligence, and data migration initiatives.
    #OraTidbit #OracleCloud #DBaaS provisioning has two options. Fast provisioning includes the Preview Version (currently 20c) and uses Logical Volume Manager (not ASM) for storage. Standard provisioning uses Automatic Storage Management and includes versions 11.2 to 19c.
    #OraTidbit #MachineLearning The OML4SQL API consists of Machine Learning extensions to Oracle SQL. The #MLPL/SQL packages are DBMS_DATA_MINING, DBMS_DATA_MINING_TRANSFORM, DBMS_PREDICTIVE_ANALYTICS.
    #OraTidbit #AutonomousDB #OrclAPEX Autonomous Database 19c includes Oracle Application Express Release 20.1. If your Autonomous Database instance is Database 18c, to use APEX 20.1 you must upgrade to Oracle Database 19c. APEX is automatically upgraded to APEX 20.1.
    #OraTidbit #db20c Oracle Data Pump supports adding, changing, and eliminating table compression. Oracle Database 20c introduces a new TRANSFORM parameter clause, INDEX_COMPRESSION_CLAUSE. This clause enables you to control whether index compression is performed during import.
    #OraTidbit #db20c #AutonomousDB Starting with Oracle Database 20c, Oracle Data Pump can perform exports from Oracle Autonomous Database into dump files in a cloud object-store.
    #OraTidbit #MachineLearning #ML Oracle Machine Learning Notebooks is an Apache Zeppelin-based collaborative web-based interface that provides a development environment to create data mining notebooks where you can perform data exploration and visualizations, data preparation and machine learning.
    #OraTidbit #MachineLearning #ML Oracle Machine Learning in the #AutonomousDB includes #OpenSource components Apache Zeppelin, Mockito, and JavaScript Extension Toolkit.
    #OraTidbit #AutonomousDB You can configure Autonomous Database to authenticate and authorize Microsoft Active Directory users. The integration of Autonomous Database with Centrally Managed Users (CMU) provides integration with Microsoft Active Directory. CMU with Active Directory works by mapping Oracle database users and roles to Microsoft Active Directory users and groups.
  • Oracle Tidbits – June 2020 #OraTidbit

    Oracle Tidbits – June 2020 #OraTidbit

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

    #OraTidbit You can pre-format SQL query output in #SQLDev and #SQLcl using SET SQLFORMAT. The options are csv, html, xml, json, ansiconsole, insert, loader, fixed, default, delimited. DELIMITED defaults to ‘,’ but can be set via SET SQLFORMAT DELIMITED.
    #OraTidbit #AutonomousDB Move to Autonomous Database (MV2ADB) tool is to migrate data from an on-premises Oracle Database Enterprise Edition deployment to an Oracle Autonomous database. MV2ADB uses Oracle Data Pump. “mv2adb auto” exports data from the source DB to OCI Object Storage, and then loads the data to the Autonomous Database.
    #OraTidbit #AutonomousDB The ADB Schema Advisor is a light-weight utility that analyzes on-premise or cloud Oracle Database schemas for the suitability of migration to the Oracle Autonomous Database. Move to Autonomous Database tool option ‘mv2adb advisor’ it will install/execute the advisor automatically.
    #OraTidbit #OraleZDM The major database release numbers of the source and target database must match for the Oracle Zero Downtime Migration (ZDM) job to succeed; higher patch release at the target is not a problem.
    #OraTidbit #OracleCloud Oracle Database Cloud Service – Bare Metal Enterprise Edition includes the Oracle Database Enterprise Edition, Data Masking, and Subsetting Pack, Diagnostics and Tuning Packs, and Real Application Testing.
    #OraTidbit #AWS #OracleRDS You can access trace files, audit log files, alert log file, listener log file using the Amazon RDS console or API. Use the procedures in rdsadmin.manage_tracefiles and rdsadmin.rdsadmin_util PL/SQL packages.
    #OraTidbit #AWS #OracleRDS Amazon RDS purges trace files by default and log files that are older than seven days. You can view and set the trace file retention period using the rdsadmin.rdsadmin_util.show_configuration and set_configuration procedures.
    #OraTidbit #AWS #OracleRDS You can create up to five read replicas of the Oracle RDS database. Amazon RDS upgrades the read replicas immediately after upgrading the source DB instance. You must own Active Data Guard license to create read replicas.
    #OraTidbit #AutonomousDB Use the DBMS_CLOUD.EXPORT_DATA procedure to specify a query to select the data from Autonomous Database to your Cloud Object Store as Oracle Data Pump dump file. Note that the dump files cannot be imported using Oracle Data Pump impdp.
    #OraTidbit #AutonomousDB Autonomous Database 19c provides Autonomous Data Guard where you can choose to enable a standby (peer) database to provide data protection and disaster recovery for your Autonomous Database instance. The standby database is created in the same region as the primary database.
    #OraTidbit #OracleCloud If you include Oracle Database software licenses in your Oracle Exadata Cloud@Customer subscription, then the included licenses contain all of the features of Oracle Database Enterprise Edition, plus all of the database enterprise management packs, and all of the Enterprise Edition options.
    #OraTidbit #OracleCloud Oracle Data Safe is a fully-integrated Cloud service focused on the security of your data. Features include Security Assessment, User Assessment, Data Discovery, Data Masking, and Activity Auditing.
    #OraTidbit Oracle Database Real Application Security is a database authorization model that: supports declarative security policies, enables end-to-end security for multitier applications, provides an integrated solution to secure database and application resources, and advances the security architecture of Oracle Database to meet existing and emerging demands of applications developed for the Internet.
    #OraTidbit #AutonomousDB #AWS The SQL Developer Amazon Redshift Migration Assistant, available with #SQLDev 18.3 and later versions provide a framework for easy migration of Amazon #Redshift environments on a per-schema basis.
    #OraTidbit #OracleAnalytics With Oracle Analytics Desktop, you can connect to many different data sources such as DB2, Azure SQL, Amazon Aurora, Amazon Redshift, Neteeza, Sybase, PostgresSQL and many more.
    #OraTidbit #AutonomousDatabase The ADB Schema Advisor is a light-weight utility that analyzes the on-premise or cloud Oracle Database schemas for the suitability of migration to the Autonomous Database. The Advisor discovers the schema objects and performs deep analysis to highlight is any differences exist when the object gets created on Oracle Autonomous Data Warehouse or Oracle Autonomous Transaction Processing database.
    #OraTidbit #OracleCloud You can obtain the OCI tenancy details of DBaaS or Autonomous DB by querying the CLOUD_IDENTITY column of the V$PDBS view. The identity includes Database name, Region, Tenant OCID, Database OCID, and Compartment OCID.
    #OraTidbit #OracleCloud #ExadataCloud Exadata Cloud Service is equipped with Oracle Database Enterprise Edition, plus all the database enterprise management packs and all the Enterprise Edition options, such as Oracle Database In-Memory and Oracle Real Application Clusters (RAC).
    #OraTidbit #OracleCloud #ExadataCloud Application users and administrators connect only to the database servers, using the supplied client and backup network interfaces. Oracle manages all hardware, firmware, and the Exadata Storage Server software by using a separate management network.