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