OracleNotes

“Oracle *daily* TidBits” (#oratidbit) published on  Facebook, Twitter, and Google+ during weekdays in December 2018. The list is short as there were no #oratidbit during the Christmas holidays. Hope you find these helpful to learn something new or to remind you of its existence and use.

HAPPY NEW YEAR 2019!

#oratidbit #orcldb When you move the online data file using ALTER DATABASE MOVE DATAFILE ‘filename’; without the TO clause, the file will be moved to DB_FILE_CREATE_DEST as Oracle Managed File – the DB_FILE_CREATE_DEST location can be ASM diskgroup or file system.

#oratidbit #orcldb Certain initialization parameters in a multitenant database could have different values for individual pluggable database. Such parameter values are stored in PDB_SPFILE$ and are queriable using V$SYSTEM_PARAMETER. CON_ID identifies the puluggable database.

#oratidbit The SEC_RETURN_SERVER_RELEASE_BANNER parameter controls the display of the product version information in a client connection. An intruder could use db release number to find information about security vulnerabilities. Default value is FALSE (hide product info).

#oratidbit If the Oracle Database 12c database hosts a database link to an Oracle Database 10g database, then the SQLNET.ALLOWED_LOGON_VERSION_CLIENT parameter should be set to SQLNET.ALLOWED_LOGON_VERSION_CLIENT=10 (sqlnet.ora) for the dblink to work.

#oratidbit #SQLPlus With SET FEEDBACK ONLY command, so you can run queries but the resulting rows are not shown in the display. They are still queried and fetched, only the feedback is shown, not rows. Best for testing performance.

#oratidbit #db18c A CDB fleet is a collection of CDBs that you manage as one logical CDB. A lead CDB is the central location for monitoring and managing the CDBs in the fleet.

#oratidbit #orcldb If JOB_QUEUE_PROCESSES parameter is 0 in a PDB, then DBMS_JOB and Oracle Scheduler jobs cannot run in this PDB, regardless of the JOB_QUEUE_PROCESSES setting in the CDB root.

#oratidbit #sqlplus SQL*Plus product-level security feature will be unavailable in Oracle Database 19c. The PRODUCT_USER_PROFILE (PUP) table provides a mechanism to control product-level security. Starting in 18c, the SQL*Plus PUP table is deprecated.

#oratidbit #sqlplus #db18c The SET FEEDBACK SQL_ID command displays the sql_id for the currently executed SQL or PL/SQL statement. The sql_id will be assigned to the predefined variable _SQL_ID.

#oratidbit #orcldb #sql Use ALTER DATABASE DICTIONARY to encrypt obfuscated database link passwords and use the TDE framework to manage the encryption key. Encrypt sensitive credential data stored in SYS.LINK$ and SYS.SCHEDULER$_CREDENTIAL system tables.

#oratidbit #oraclecloud You can programmatically provision and manage Oracle Database Cloud Service instances and associated database deployments by using REST (REpresentational State Transfer) application programming interfaces (APIs).

#oratidbit #orcl101 V$RSRC_CONSUMER_GROUP shows CPU utilization statistics for each consumer group when the Oracle Database Resource Manager is running.

#oratidbit #oraclecloud The Oracle Cloud at Customer includes Oracle Advanced Support Gateway (OASG), which includes the hardware and software required to securely connect your Oracle Cloud at Customer environment to the remote Oracle Operations team.

“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).