OracleNotes

Author: biju.thomas

  • Oracle Tidbits – November 2018 #oratidbit

    Oracle Tidbits – November 2018 #oratidbit

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

    #oratidbit #oraclecloud DBaaS Cloud Service Bare Metal is a dedicated instance with Oracle Database 11g, 12c, or 18c, including the multitenant option. Infrastructure ranges from virtual machines with 1 to 24 cores, 256 GB to 40 TB storage.
    #oratidbit #oraclecloud Oracle Database Exadata Express Cloud Service is a fully managed database cloud service. Network configuration, storage, database patching & upgrade are taken care of for you.
    #oratidbit #oraclecloud Oracle #DataHub Cloud Service enables you to consistently provision and manage NoSQL database clusters such as Apache Cassandra on Oracle Cloud.
    #oratidbit #oraclecloud Oracle #EventHub Cloud Service is a managed, cloud-based messaging platform that leverages the combined power of Oracle Cloud and Apache #Kafka to enable you to work with streaming data.
    #oratidbit #oraclecloud Oracle #NoSQL Database Cloud is a fully managed database cloud service that is designed to handle large amounts of data
    #oratidbit #orachk Oracle Trace File Analyzer automatically runs SRDC (Service Request Data Collection) when ORA-600, ORA-4030, ORA-4031, ORA-7445 events are detected.
    #oratidbit #orachk Installing Oracle Trace File Analyzer as root on non-engineered systems automatically sets up and runs the ORAchk daemon. The daemon restarts at 1 am every day to discover any environment changes.
    #oratidbit #oraclecloud #dbaas The “Data Guard Standby for Hybrid DR” database type on Oracle Database Cloud Service is a single-instance database acting as the standby database in an Oracle Data Guard configuration. The primary database is on your own system.
    #oratidbit #oracleXE Oracle Database 18c XE (Express Edition) limits itself automatically to two cores for processing. The maximum amount of user data in XE database cannot exceed 12GB. If the user data grows beyond this limit, then an ORA-12592 error will appear.
    #oratidbit #oracleXE A Pluggable Database (PDB) created in Oracle Database XE 18c can be migrated to another Multitenant Container Database (CDB) Enterprise Edition (EE) 18c. Unplug a PDB from XE 18c database and plug it into another EE 18c database of the same release.
    #oratidbit #oracleXE Oracle GoldenGate can not be used with Oracle Database Express Edition.
    #oratidbit #oracleXE The maximum amount of user data in an Oracle Database XE database cannot exceed 12 gigabytes. Use Advanced Compression option to store more data. Use “ROW STORE COMPRESS ADVANCED” (table) “COMPRESS ADVANCED <LOW | HIGH>” (index) clauses.
    #oratidbit #oracleXE To deinstall 18c XE, perform as root 1) “/etc/init.d/oracle-xe-18c delete” to remove data files, listener and configuration files 2) “yum remove oracle-database-xe-18c” to remove the software.
    #oratidbit #orcldb Oracle Database monitors simple database operations when SQL statements or PL/SQL subprograms have consumed at least 5 seconds of CPU or I/O time in a single execution.
    #oratidbit #orcldb When the CONTROL_MANAGEMENT_PACK_ACCESS init parameter is set to DIAGNOSTIC+TUNING, you can use /*+ MONITOR */ hint to enable monitoring of specific SQL statements. The MONITOR hint can enforce monitoring of statements that do not meet the time criteria.
    #oratidbit #oraclecloud Oracle Database Backup Cloud Service supports two Oracle Database optimizations: RMAN backup encryption and RMAN backup compression algorithms.
    #oratidbit #oraclecloud In addition to RMAN interface, you can use Oracle Enterprise Manager Cloud Control 13c to configure the backup module and perform backup and recovery operations in the Oracle Database Backup Cloud Service.
    #oratidbit #oracleoem Oracle Enterprise Manager Ops Center is Oracle’s comprehensive solution for managing the physical and virtual assets in the data center: operating systems, firmware, BIOS configurations, bare metal server and so on.
    #oratidbit #oracle101 If you enter values for a multi-value initalization parameter on multiple lines in the pfile, then the entries must be on consecutive lines. If they are not, then the first entry will not be processed.
    #oratidbit #oracle101 The ALTER SYSTEM … DEFERRED statement does not modify the global value of the init parameter for existing sessions, but the value will be modified for future sessions that connect to the database. (Not all parameters are eligible for DEFERRED).
  • Oracle Tidbits – October 2018 #oratidbit

    Oracle Tidbits – October 2018 #oratidbit

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

    #oratidbit #db18c You can convert a conventional disk group (disk group created before Oracle ASM 18c) to an Oracle ASM flex disk group without using the restrictive mount (MOUNTED RESTRICTED) option.
    #oratidbit #asm Oracle Automatic Storage Management 18c supports Database 18c or older software versions, including Oracle Database 10gR1 (10.1). When using different software versions, the database instance supports Oracle ASM functionality of the earliest release in use.
    #oratidbit #asm Use ASMCMD command orapwusr to add, drop, or modify an Oracle ASM password file user. Command lspwuser list the users from the local Oracle ASM password file.
    #oratidbit #asm Use ASMCMD command lsop to list the current operations on a disk group in an Oracle ASM instance. lsop displays information from the V$ASM_OPERATION view.
    #oratidbit Oracle Database provides a set of mapping v$ views to show a complete mapping of a ASM data file to locate the exact disk on which any block of a file resides. To enable file mapping, set the FILE_MAPPING initialization parameter to TRUE.
    #oratidbit #OEM13c Oracle Enterprise Manager Cloud Management Pack for Oracle Database helps to set up a Database Cloud and operate the Database as a Service model.
    #oratidbit #oracleVM Features in OVM Release 3.4: vCPUs per host raised from 900 to 4096; maximum vdisk size on NFS raised from 2 TB to 10 TB and on OCFS2 from 10 TB to 64 TB. Support for Fibre Channel over Ethernet (FCoE) and Unified Extensible Firmware Interface (UEFI).
    #oratidbit #db18c Private temporary tables are temporary database objects that are dropped at the end of a transaction or session. Private temporary tables are stored in memory and each one is visible only to the session that created it. Must be prefixed with ORA$PTT_.
    #oratidbit #OracleVM #VMWare Partition alignment on both physical machines and VMFS partitions prevent performance I/O degradation caused by I/O crossing track boundaries. Partition misalignment add latency to workloads due to a single I/O having to cross physical boundaries.
    #oratidbit #db18c Use the CREATE PRIVATE TEMPORARY TABLE statement to create a private temporary table. The ON COMMIT clause indicates if the data in the table is transaction-specific (ON COMMIT DROP DEFINITION – the default) or session-specific (ON COMMIT PRESERVE DEFINITION).
    #oratidbit #db18c The SLEEP procedure that belonged to DBMS_LOCK in earlier releases is now in package DBMS_SESSION. For backward compatibility, DBMS_LOCK.SLEEP is still available, but not documented.
    #oratidbit #db18c Names of private temporary tables must be prefixed according to the initialization parameter private_temp_table_prefix. Default is ORA$PTT_. Value must begin with ORA$. After setting the prefix, regular table, view, and object names cannot use the same prefix.
    #oratidbit A SQL patch is a patch that contains SQL scripts which need to be run after OPatch completes. DBA_REGISTRY_SQLPATCH contains information about the SQL patches that have been installed in the database. DBA_REGISTRY_SQLPATCH is updated by the datapatch utility.
    #oratidbit #oracleTFA The Trace Filey Analyzer recommended install on Linux is as root daemon mode to get the richest capabilities. Recommended install location is /opt/oracle.tfa.
    #oratidbit #oracleTFA Use “tfactl summary” for a quick real-time view of all key database components using the Trace File Analyzer. It shows any potential problems with important elements (database, clusterware, ASM, patch, listener, OS, network).
    #oratidbit #oracleTFA Use the “tfactl changes” command to view the changes detected by Oracle Trace File Analyzer. Report any noted changes in the system setup over a given time period. This includes database a parameters, OS parameters, patches applied.
    #oratidbit #oracleTFA The Oracle Trace File Analyzer install includes a Web Application Resource (WAR) file (TFA_HOME/jlib/tfa.war) to enable the REST service via Apache Tomcat.
    #oratidbit #oracleTFA Oracle Trace File Analyzer root installations on Linux or Solaris will automatically setup and run the ORAchk daemon. The daemon will be restarted at 1am every morning, in order to discover any environment changes.
    #oratidbit #dbupgrade Make all tablespaces OFFLINE NORMAL or make READ ONLY except for SYSTEM, SYSAUX, <UNDO> prior to upgrade. If upgrade fails, only the SYSTEM and rollback datafiles need to be restored rather than the entire database.
    #oratidbit #dbupgrade Database Upgrade Assistant (DBUA) has an option to use flashback database feature for restoring and recovering the Database in case of upgrade failure. This can be done by selecting the option “Use Flashback and Guaranteed Restore Point”.
    #oratidbit #Multitenant You can create up to 252 PDBs with Oracle Enterprise Edition (on-prem). On Oracle Engineered Systems (EE-ES) and Oracle Cloud (DBCS & ExaCS), you can create up to 4096 PDBs.
    #oratidbit #Sharding No limit on the number of either primary shards or standby shards if every shard has an Oracle Active Data Guard, Golden Gate, or Oracle RAC license. Without license, use is limited to three primary shards, with basic Data Guard standbys.
    #oratidbit #oraclecloud Exadata Cloud Service Bare Metal can scale up to 336 cores and 8 nodes, with high memory and storage capacity (over 1 petabyte) and unlimited I/Os. Exadata Cloud Machines include Oracle Database Enterprise Edition Extreme Performance.