Tag: 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 *daily* TidBits” (#oratidbit) published on  Facebook, Twitter, and Google+ during weekdays in September 2018. Hope you find these helpful to learn something new or to remind you of its existence and use.

#oratidbit #license SQL Plan Management in Standard Edition- Only one SQL plan baseline per SQL statement is allowed and SQL plan evolution is disabled.

#oratidbit #license Oracle 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 these, use is limited to three primary shards.

#oratidbit #license Tablespace encryption is not available on Standard Edition (SE2) on-prem, but is included in the DBCS-SE (Oracle Database Cloud Service Standard Edition) offering.

#oratidbit Oracle Personal Edition includes all of the components that are included with Enterprise Edition, as well as all Oracle Database options except Oracle RAC. Oracle management packs cannot be used with Personal Edition.

#oratidbit You can enable or disable a CBO related bug fix using the _FIX_CONTROL parameter – gives granular control over specific features and bug fixes. Use V$SYSTEM_FIX_CONTROL to see what bug fix is implemented and detail.

#oratidbit The CDB_* views can be queried only by users with the SYSDBA system privilege or SELECT ANY DICTIONARY privilege, or SELECT_CATALOG_ROLE role, or by users with direct privileges granted to them.

#oratidbit CDB_* views include these hidden columns: CON$NAME: the name of the container whose data a given CDB_* row represents. CDB$NAME: the name of the CDB whose data a given CDB_* row represents.

#oratidbit The AWR_ROOT_* views show the AWR data stored only on a CDB root. In general, the AWR_ROOT views are equivalent to the DBA_HIST views.

#oratidbit A connection storm is a race condition in which application servers initiate an increasing number of connection requests, but the database server CPU is unable to schedule them immediately, which causes the application servers to create more connections.

#oratidbit Database Resident Connection Pool (DRCP) provides a connection pool in the database server for typical web application usage scenarios where the application acquires a database connection, works on the database for a relatively short time, and then releases the connection.

#oratidbit Database Resident Connection Pool (DRCP) is installed by default, but the DBA must start, and configure it using the DBMS_CONNECTION_POOL package.

#oratidbit When Database Resident Connection Pool (DRCP) is configured in a database in an Oracle RAC environment, the pool configuration is applied to each database instance. Starting or stopping the pool on one instance starts or stops the pool on all instances.

#oratidbit The Memoptimize Pool optimizes the read operation for select statements. Memoptimize Rowstore performs high-performance reads for tables specified with the MEMOPTIMIZE FOR READ clause.

#oratidbit DBCA (Database Configuartion Assistant) enables you to create and duplicate CDBs, and create, clone, plug in, and unplug PDBs.

#oratidbit #OEM13c You can upgrade only 13c Release 2 (13.2.0.0), 13c Release 1 (13.1.0.0), or 12c Release 5 (12.1.0.5) directly to 13c Release 3 (13.3.0.0).

#oratidbit Oracle Data Mining supports both supervised and unsupervised data mining. The DBMS_DATA_MINING package is the application programming interface for creating, evaluating, and querying data mining models.

#oratidbit A transformation is a SQL expression that modifies the data in one or more columns. The DBMS_DATA_MINING_TRANSFORM package implements a set of transformations that are commonly used in data mining.

#oratidbit Oracle R Enterprise is a component of the Oracle Advanced Analytics Option of Oracle Database Enterprise Edition. Oracle R Enterprise is comprehensive, database-centric environment for end-to-end analytical processes in R.