OracleNotes

Category: TidBits

  • Oracle TidBits – December 2015

    “Oracle *daily* TidBits” (#oratidbit) published at https://www.facebook.com/oraclenotes on weekdays in December 2015. 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…

    Publish Date TidBit
    1-Dec #oratidbit After software only Oracle cluster install, configure the cluster using $ORACLE_HOME/crs/config/config.sh wizard. The wizard can configure one node, multiple nodes or upgrade Oracle Grid Infrastructure.
    2-Dec #oratidbit Oracle Cluster Registry is managed using the ocrconfig utility. Use ocrconfig to add, remove, replace, repair, backup, restore Oracle Cluster Registry Location.
    3-Dec #oratidbit In Oracle Clusterware, each node in a cluster has a local registry for node-specific resources called Oracle Local Registry (OLR), that is installed and configured when Oracle Clusterware installs OCR.
    4-Dec #oratidbit olsnodes command provides the list of nodes participating in the cluster. Use olsnodes to quickly check cluster is operational, and all nodes are registered as members of the cluster.
    7-Dec #oratidbit V$OBSOLETE_PARAMETER displays information about obsolete initialization parameters. If any row of the view contains TRUE in theISSPECIFIED column, then you should examine why.
    8-Dec #oratidbit V$PATCHES shows the patches applied on an Oracle ASM instance and the list of patches applied to an Oracle Grid infrastructure home directory.
    9-Dec #oratidbit V$RESERVED_WORDS displays a list of all SQL keywords. To determine whether a particular keyword is reserved in any way, check theRESERVED, RES_TYPE, RES_ATTR, and RES_SEMI columns.
    10-Dec #oratidbit V$SESSION_BLOCKERS displays the blocker sessions for each blocked session. Each row represents a blocked and blocker session pair. If a session is blocked by multiple sessions there will be multiple rows for that blocked session.
    11-Dec #oratidbit In #DB12c, V$BACKUP_NONLOGGED view displays information about nonlogged block ranges in data file backups recorded in the control file.
    14-Dec #oratidbit DBMS_ROLLING PL/SQL package is used to implement Rolling Upgrade Using Active Data Guard feature, which streamlines the process of upgrading Oracle Database software in a Data Guard configuration in a rolling fashion.
    16-Dec #oratidbit DBA_PDB_SAVED_STATES dictionary view shows information about the current saved PDB states in the CDB.
    #oratidbit Set NONCDB_COMPATIBLE=TRUE parameter if have a single PDB in CDB configuration and have legacy code that causes ORA-65040 when you run it in the PDB.
    21-Dec #oratidbit In CDB 12c architecture, standby recovery is always at the CDB level. ALTER PLUGGABLE DATABASE RECOVER statement is not supported on the standby.
    22-Dec #oratidbit in CDB 12c standby architecture, redo from primary must always shipped to the service defined on the root container (CON_ID=1).
    23-Dec #oratidbit #OEM13c Brownouts: monitoring continues during planned maintenance of targets but no notifications are sent.
    24-Dec #oratidbit DB12c 12.1.0.2 is the only supported database for #OEM13c 13.1 install.
    25-Dec #oratidbit In #OEM13c BI Publisher is integrated. You have option to enable BIP during OEM 13c install.
    28-Dec #oratidbit When installing #OEM13c, AL32UTF8 is the strongly recommended character set for EM repository.
    29-Dec #oratidbit #OEM13c 13.1.0.0 install distribution comes with 12.1.0.2 database template with core sysman schema and predefined repository parameters.
    30-Dec #oratidbit V$PARAMETER_VALID_VALUES displays a list of valid values for list initialization parameters.
    31-Dec #oratidbit V$CON_SYSSTAT displays system statistics, including OLAP kernel statistics for the container from which it is queried.

  • Oracle Tidbits – November 2015

    “Oracle *daily* TidBits” (#oratidbit) published at https://www.facebook.com/oraclenotes on weekdays in November 2015. 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…

    Publish Date TidBit
    2-Nov #oratidbit DB 12cR2 Feature (heard from #oow15): Flashback single PDB possible.
    3-Nov #oratidbit DB 12cR2 Feature (heard from #oow15): The number of PDBs you create in Container Database Architecture increases to around 4096.
    4-Nov #oratidbit DB 12cR2 Feature (heard from #oow15): Online PDB clone. Currently to clone a PDB, it must be in read only mode.
    5-Nov #oratidbit DB 12cR2 Feature (heard from #oow15): Apply PSU and smaller patches on standby first, before applying to primary.
    6-Nov #oratidbit DB 12cR2 Feature (heard from #oow15): AWR will work on Active Data Guard Database, so you can tune your reporting database.
    9-Nov #oratidbit DB 12cR2 Feature (heard from #oow15): A diskgroup in ASM can have file groups to group files belonging to PDBs or databases.
    10-Nov #oratidbit SQL Plan Management (SPM) is a preventative mechanism that enables the optimizer to automatically manage execution plans, ensuring that the database uses only known or verified plans.
    11-Nov #oratidbit SQL Plan Management (SPM) Evolve Advisor (new in 12c) is a SQL advisor that evolves plans that have recently been added to the SQL plan baseline. The advisor simplifies plan evolution by eliminating the requirement to do it manually.
    12-Nov #oratidbit SQL Management Base (SMB) is a logical repository that stores statement logs, plan histories, SQL plan baselines, and SQL profiles. The SMB is part of the data dictionary and resides in the SYSAUX tablespace.
    13-Nov #oratidbit DBA_SQL_MANAGEMENT_CONFIG view shows the current configuration settings for the SQL Management Base (SMB). The SMB stores information that the optimizer can use to maintain or improve SQL performance. Use DBMS_SPM.CONFIGURE to change SMB setting.
    16-Nov #oratidbit SQL Profiles and SQL plan baselines are internally implemented using hints. SQL plan baselines are proactive, whereas SQL profiles are reactive.
    17-Nov #oratidbit Use DBMS_SPM.CREATE_STGTAB_BASELINE procedure to create a staging table that enables to transport SQL plan baselines from one database to another.
    19-Nov #oratidbit Zone maps in #DB12c reduce the I/O and CPU costs of table scans by tracking the sets of contiguous data blocks, or zones, in which certain column values are stored.
    20-Nov #oratidbit In #DB12c ROW LEVEL LOCKING clause of CREATE TABLE can be used to control whether row level locking is used during DML operations for tables compressed with Hybrid Columnar Compression.This improves the performance of DML operations when accessing Hybrid Columnar Compressed data.
    23-Nov #oratidbit In #DB12c using the INVISIBLE attribute in CREATE VIEW, you can make a column in a view invisible. By default, view columns are VISIBLE regardless of their visibility in the base tables, unless you specify INVISIBLE.
    24-Nov #oratidbit on Oracle Database Appliance, ORAChk tool can be accessed as “oakcli orachk” from either ODA node.
    25-Nov #oratidbit Trace File Analyzer (TFA) diagnostics collection is performed on ODA as “oakcli manage diagcollect”
    26-Nov Thank you to all #oratidbit followers! Happy Thanksgiving!!
    27-Nov #oratidbit on Exadata, use the dcli command to execute cellcli and other commands on remote cells. dcli (distributed command line interface) uses ssh.