List Premium Category

How to Extend the Admin Group Properties in 12c OEM

by bsarchbsarch 26 Apr 2019 14:33

There is a default maximum for the number of values that can be supported for a target property as administration group criteria. If you see a warning message indicating that you have reached this maximum value, you can extend it using the OMS property admin_groups_width_limit. Specify the maximum number of values that should be supported for a target property. For example, to support up to 30 values for a target property that will be used in administration group criteria

How to Fix 12C OEM that is Missing Metrics for a Database

by bsarchbsarch 25 Apr 2019 12:47

On some systems, there have been reports of certain database metrics not showing in OEM. The guide below gives some pointers on how to diagnose this issue.

Online Table Reorg

by bsarchbsarch 16 May 2018 11:24

[[code type="SQL"]]

Check to see if a table can be reorganised.

How to Configure Database Express

by bsarchbsarch 19 Sep 2016 11:29

Database Console no longer exists from 12c onwards. Instead, a new tool called Database Express is available. It is similar to Database Console, but comes with less functionality and instead of being a separate install, it runs entirely within the database. This makes it very easy to install and configure. Unlike dbcosnole where you would have the following tasks to perform <insert link, the installation and configuration is a single command.

What are CDBs,PDBs and Containers?

by bsarchbsarch 12 Jun 2015 09:13

Database 12c brings a new architecture called multitenant architecture. This allows you to have a number of virtual databases called containers which exist inside one physical database called a container database. The containers can easily be "unplugged" or "plugged into" the container database and as such, the containers are also known as pluggable databases (PDB).

What are Common and Local Users and How to Create them?

by bsarchbsarch 29 May 2015 14:01

A common users, is a user that is created whilst connected to the root (CDB). When the command to create a common user is executed, the user gets created across all PDBs with the exception of the seed PDB. As such, a common users can connect to any PDB. Common users must also start with a c##. This distinguishes them from local users.

Adding Space to a Pluggable Database

by bsarchbsarch 29 May 2015 14:01

Both CDBs and PDBs have their own set of tablespaces and datafiles. As such, both CDBs and PDBs have storage administration requirements. This guide shows how to create tablespaces and add datafiles in both CDBs and PDBs.

How to Rename a Pluggable Database

by bsarchbsarch 29 May 2015 14:01

The following explains how to rename a container (pluggable databases).

How to Stop and Start a Pluggable Database

by bsarchbsarch 29 May 2015 14:00

The following explains how to stop and start a the container database and the containers (pluggable databases).

How to Create (Or Drop) a Pluggable Database

by bsarchbsarch 29 May 2015 14:00

The following explains how to create a pluggable database using the seed database.

List Earliest Flashback Database Time and SCN

by bsarchbsarch 10 Feb 2015 12:17

[[code type="SQL"]]

List Earliest Flashback Database Time and SCN.

Sort Usage Procedure

by bsarchbsarch 05 Nov 2014 13:53


— Title : monitor_sort_usage.sql
— Description : A script to create a procedure which captures
— sort usage of all users in the database.
— The output is stored in the table created by this
— script.

Usage/Notes : (1) Must run be run by a user that has access to gv$ views

Author : Mark Ramsay
— Date : 3 november 2014

Version : 1.00

Amendment :
— History

Copyright : 2014


Invalidating a Plan

by bsarchbsarch 13 Oct 2014 13:56

Table of Contents

Oracle Log Files and Trace Files

by bsarchbsarch 08 Sep 2014 10:43

The following tables detail the location and purpose of the Oracle database log files and trace files. This includes Database log files and Grid Infrastructure log files written to as part of a RAC cluster or Oracle's HA solutions. For example, Grid Interprocess Communication Daemon log file, Database Alert Log, rsmn trace files etc

How to Profile PLSQL

by bsarchbsarch 11 Feb 2014 13:05

There may be times when a normal SQL trace of a PLSQL package is not sufficient. For example, when the SQL statements seem to be running fast, but the procedure takes a long time. It may be useful to understand which calls in the PLSQL package are taking the time. With this in mind, this document provides a step by step guide to tracing PLSQL using DBMS_HPROF.

Blocking Locks (Verbose)

by bsarchbsarch 11 Jul 2013 13:50

Shows blocked session

RAC Interconnect Port Configurations for Switches

by bsarchbsarch 01 Mar 2013 13:23

Many organisations run operational tests on infrastructure before making a system live. In a high availability RAC environment with dual switches and network cards for resilience, one such test is to fail network cards in the server and to fail switches. This test is performed to ensure that the secondary network cards and switches carry on without interruption to service.

Get Historical Plans from the AWR Using SQLID

by bsarchbsarch 04 Feb 2011 11:40

[[code type="SQL"]]

Get Historical Plans from the AWR Using SQLID

SET PAUSE 'Press Return to Continue'

page 1 of 212next »
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License