Oracle *daily* TidBits” (#oratidbit) published on Facebook, Twitter, and Google+ during weekdays in September 2017. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use.

#oratidbit #db12cR2 The V$MANAGED_STANDBY view is deprecated in Oracle Database 12c Release 2 ( Use the new view V$DATAGUARD_PROCESS.
#oratidbit #db12cR2 Starting in Oracle Database 12c Release 2 (12.2), the Advanced Replication feature of Oracle Database is unsupported. Start using Oracle GoldenGate.
#oratidbit #db12cR2 DBUA in Database 12cR2 has pause and continue functionality: You can stop the upgrade, and continue the upgrade at a later time.
#oratidbit #db12cR2 init parameter DATA_GUARD_SYNC_LATENCY defines the maximum amount of time (in seconds) that the primary database may wait before disconnecting subsequent destinations after at least one synchronous standby has acknowledged receipt of the redo.
#oratidbit #db12cR2 init parameter ENABLED_PDBS_ON_STANDBY specifies a subset of pluggable databases (PDBs) for replication on a physical standby of a multitenant container database (CDB). In prior releases, you had to specify either all PDBs or none.
#oratidbit #db12cR2 Oracle Diagnostic Pack can be used with an Oracle Active Data Guard standby database that is open read-only.
#oratidbit #db12cR2 When a physical standby database is converted into a primary, STANDBY_DB_PRESERVE_STATES init parameter lets you keep any sessions connected to the standby during the switchover/failover.
#oratidbit The Enterprise Manager Command Line Interface (EM CLI) enables to access Enterprise Manager functionality through a command-line interface or scripts. EMCLI operates in standard command mode, interactive mode or script mode.
#oratidbit OEM13c EMCLI client is downloaded from your OMS – https:///em/public_lib_download/emcli/kit/emclikit.jar. To be able to do scripting download emcliadvancedkit.jar.
#oratidbit The Oracle Database Provider for DRDA is a network front-end that enables client programs to connect to Oracle Database using the Distributed Relational Database Architecture (DRDA) protocol.
#oratidbit Starting with #DB12cR2, Oracle Net listener supports multiple redirects with the parameter, ALLOW_MULTIPLE_REDIRECTS_listener_name. It supports seamless migration of a PDB from a local database to Public Cloud.
#oratidbit Starting with #db12cR2, data compression can be set in the sqlnet.ora file using parameters SQLNET.COMPRESSION and SQLNET.COMPRESSION_LEVELS. Setting these parameters in the sqlnet.ora file affects all the connections using the sqlnet.ora file.
#oratidbit The Automatic Diagnostic Repository (ADR) is a systemwide tracing and logging central repository. The repository is a file-based hierarchical data store for depositing diagnostic information, including network tracing and logging information.
#oratidbit #db12cR2 Oracle RAC Reader Nodes facilitate Oracle Flex Cluster architecture by allocating a set of read/write instances running Online Transaction Processing (OLTP) workloads and a set of read-only database instances across Hub Nodes and Leaf Nodes in the cluster. In this architecture, updates to the read-write instances are immediately propagated to the read-only instances on the Leaf Nodes, where they can be used for online reporting or instantaneous queries.
#oratidbit Start and stop Oracle instances with Oracle Enterprise Manager, SQL*Plus, or SRVCTL. OEM and SRVCTL provide options to start and stop all of the instances in an Oracle RAC database with a single step.
#oratidbit If you stop database instances using “crsctl stop crs” or “crsctl stop cluster -all”, databases are stopped with “shutdown abort”.
#oratidbit Oracle database startup looks for initialization parameter file in $ORACLE_HOME/dbs directory. The file names checked are spfile<sid>.ora, spfile.ora, init<sid>.ora, in order.
#oratidbit In #db12cR2 the optimizer uses the UNION-ALL operator to perform the OR expansion. Earlier, CONCATENATION operator was used.
#oratidbit DBMS_STATS.GET_STATS_HISTORY_RETENTION function shows the current optimizer statistics history retention value. DBMS_STATS.GET_STATS_HISTORY_AVAILABILITY function retrieves the oldest time stamp when statistics history is available.

Oracle *daily* TidBits” (#oratidbit) published on Facebook, Twitter, and Google+ during weekdays in August 2017. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use.


#oratidbit #orcldb If you are installing 64-bit Oracle Database software, and your existing Oracle Database is a 32-bit Oracle Database installation, then your existing Oracle Database is automatically converted to 64-bit during the upgrade.
#oratidbit You can install Oracle R Enterprise Server in a pluggable database (PDB) within a multitenant container database (CDB). The database may not be the root database.
#oratidbit An external procedure is a procedure invoked from a program that is written in a different language. Oracle Database uses an external procedure agent named extproc to support external procedures.
#oratidbit #orcldb #datapump Setting the parameter _OPTIMIZER_GATHER_STATS_ON_LOAD=FALSE might improve the table loading speed. Use this parameter if you include EXCLUDE=STATISTICS, and plan to collect stats after the import.
#oratidbit ROracle is an open source R package that enables interaction between R and an Oracle database. ROracle is maintained and supported by Oracle. ROracle is licensed under LGPL v.2 or later and not under the terms of your Oracle license agreement.
#oratidbit #db12cR2 SQL92_SECURITY initialization parameter default is TRUE in 12.2. Meaning, users must have been granted the SELECT object privilege in order to execute UPDATE or DELETE statements.
#oratidbit Parallel upgrade utility in 12c is In #db12cR2 use the dbupgrade (Linux/Unix) or dbupgrade.cmd (Windows) shell script instead of using
#oratidbit Oracle ASM Filter Driver (Oracle ASMFD) is a kernel module that resides in the I/O path of the Oracle ASM disks. Oracle ASM uses the filter driver to validate write I/O requests to Oracle ASM disks and rejects any I/O requests that are invalid.
#oratidbit Oracle ASM disk scrubbing checks logical data corruptions and repairs the corruptions automatically in normal and high redundancy disks groups. The feature is designed so that it does not have any impact on the regular input and output (I/O) operations in production systems.
#oratidbit Automatic memory management is enabled by default on an Oracle ASM instance, even when the MEMORY_TARGET parameter is not explicitly set.
#oratidbit #orcldb A proxy PDB is a PDB that uses a database link to reference a PDB in a remote CDB. When you issue a statement in a proxy PDB while the PDB is open, the statement executes in the referenced PDB.
#oratidbit #orcldb GV$AQ_MESSAGE_CACHE_ADVICE provides advice on how much STREAMS_POOL should be allocated for sharded queues based on a snapshot of the current messaging load.
#oratidbit A subset of GDSCTL commands are applicable to Global Data Services (GDS) configuration and another subset of GDSCTL commands are for Oracle Sharding configuration.
#oratidbit chactl commands are to administer Oracle Cluster Health Advisor basic monitoring functionality on the RAC targets.
#oratidbit The Trace File Analyzer control utility, TFACTL, is the command-line interface for Oracle Trace File Analyzer. You need root access or sudo access to tfactl to run administration commands.
#oratidbit #db12cR2 After installing database a pre-existing database link SYS_HUB exists as a requirement to clone a remote PDB.
#oratidbit #orcldb The SPARE6 column in SYS.USER$ table keeps track the last successful login time of the user in Oracle Database 12c. This is a very good security feature, without enabling “AUDIT SESSION” to find when the user last used the database.
#oratidbit #orcldb In Oracle Database 12c, 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 Oracle Database 12c has new CASCADE clause for TRUNCATE statement. This truncates all child tables that reference the truncated table if the foreign key is defined with ON DELETE CASCADE option and the FK constraint is in ENABLED status. Children, grand children are truncated.
#oratidbit #db12cR2 The DBMS_DEBUG package is deprecated in Oracle Database 12c release 2 (12.2). Use DBMS_DEBUG_JDWP instead.
#oratidbit #db12cR2 DBUA in Database 12cR2 has priority-based PDB upgrades. You can set priority for PDB upgrades so that higher priority PDBs are upgraded first.
#oratidbit #db12cR2 The DBMS_JOB package is deprecated and may be unsupported in a future release. Use DBMS_SCHEDULER instead.
#oratidbit #db12cR2 DBUA in Database 12cR2 has Standalone Prerequisite Checks: You can run DBUA with the -executePrereqs option to check prerequisites for upgrades at any time.

Oracle *daily* TidBits” (#oratidbit) published on Facebook, Twitter, and Google+ during weekdays in July 2017. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use.


#oratidbit Oracle Database Backup Cloud Service is used to store Oracle Database backups only. To store other types of data, use Oracle Storage Cloud Service.
#oratidbit #orcldb To implement an Information Lifecycle Management (ILM) strategy for data movement in the database, use Heat Map and Automatic Data Optimization (ADO) features.
#oratidbit #orcldb Heat Map and Automatic Data Optimization (ADO) features are enabled by setting HEAT_MAP parameter to ON. For ADO, Heat Map must be enabled at the system level.
#oratidbit #orcldb Using bigger ASM allocation unit size reduces the memory requirements for Oracle ASM and thus improve the ASM startup time.
#oratidbit To monitor #DB12cR2 (12.2), you must be on EM 12c PS4 with Bundled Patch 2 or later applied. The EM agent that is used to monitor the database must be an EM 12c PS4 agent with Agent Bundled Patch 3 or later applied.
#oratidbit #orcldb Oracle Database Clients on 32-bit are not supported to connect to #DB12cR2.
#oratidbit #orcldb JOB_QUEUE_PROCESSES defaults to 1000. The job coordinator process starts only as many job queue processes as are required, based on the number of jobs to run and available resources. You can set JOB_QUEUE_PROCESSES to a lower number to limit the number of job queue processes.
#oratidbit #orcldb If JOB_QUEUE_PROCESSES is 0, both DBMS_JOB and Oracle Scheduler (DBMS_SCHEDULER) jobs are disabled. Both use the same job coordinator to start job slaves.
#oratidbit #orcldb Inside a PDB container, 0 and 1000 are the only valid values for job_queue_processes. 0 (zero) means that no jobs can be run for that PDB. 1000 means that jobs are allowed to run in that PDB.
#oratidbit When Linux HugePages is configured, the Grid Infrastructure Management Repository (GIMR) system global area is installed into HugePages memory. The GIMR SGA occupies up to 1 GB of HugePages memory.
#oratidbit #db12cR2 The CREATE USER and ALTER USER SQL statements lets you set a new profile parameter, INACTIVE_ACCOUNT_TIME, which enables you to automatically lock inactive accounts.
#oratidbit #db12cR2 For multitenant environments, the PDB_OS_CREDENTIAL initialization parameter enables a different operating system user to execute external procedures using the EXTPROC process.
#oratidbit #orcldb #db12cr2 #rac INSTANCE_MODE init parameter indicates whether the instance is read-write, read-only, or read-mostly. Read-only and read-write instances can co-exist within a single database.
#oratidbit #orcldb #db12cR2 MAX_DATAPUMP_JOBS_PER_PDB init parameter determines the maximum number of concurrent Oracle Data Pump jobs per PDB. The default is 100. The main resource Oracle Data Pump uses is shared pool in the SGA for the database.
#oratidbit Oracle #Exadata comes in three flavors – Cloud Services, Cloud at Customer, On Premises.
#oratidbit Active Data Guard extends Data Guard capabilities by providing advanced features for data protection and availability as well as offloading read-only workload and backups from a production database. Active Data Guard is included in the Extreme Performance Database Cloud Service and Exadata Service.
#oratidbit #orcldb Database releases or higher, or higher can upgrade directly to version 12.2. Direct upgrade not supported for 11gR2 database versions and
#oratidbit #orcldb If the PDB COMPATIBLE value is lower than CDB$ROOT COMPATIBLE, the PDB COMPATIBLE parameter value is increased automatically to the same COMPATIBLE setting as CDB$ROOT.
#oratidbit #orcldb Oracle Enterprise Manager Lifecycle Management Pack supports performing database upgrade (12c database and higher).
%d bloggers like this: