Article presents how to create simple report to monitor PGA in Oracle database using ASH or AWR as source.
PGA is dedicated memory structure in SGA stores stores following areas:
Cursors and private sql areas
- opened cursors, links to shared SQL areas in shared pool
- bind variable for cursors
- query execution state information
SQL work areas
- sort operations (order by, group-by, rollup, window function)
- bitmap merge
- bitmap create
This article presents methods to transform an SQL to XML format with minimum effort possible.
Let’s take simple SQL
SELECT owner, table_name
WHERE table_name LIKE 'USER%' and owner='SYS';
and try to transform it into XML format
This article presents installation of Oracle database 12C(12.1) on Fedora 23. Read following article to install Fedora 23 Linux: Install Fedora 23(for comfort set 4G memory for your virtual machine). Continue reading
This article presents how to install Oracle 11G on Fedora 23.
Read following article how to install Fedora 23 Linux: Install Fedora 23 (for comfort set 4G memory for your virtual machine before proceeding with Oracle software installation).
Installation software is available on OTN version 184.108.40.206 or metalink 220.127.116.11. In this installation I’m presenting installation for 18.104.22.168 but for previous version 11.2.0.X it shouldn’t be different.
Check article for new release Install Oracle 12C Release 1 (12.1) on Fedora 23
Oracle software that was verified
WITH clause is commonly used to simplify SQL statements. This article shows impact of dedicated hints MATERIALIZE and INLINE for processing data with WITH clause.
This article presents how to generate GANTT reports using sql.
A GANTT charts are commonly used in project management or batch processing, as one of the most popular and useful ways of showing activities (tasks or events) displayed against time. On the left of the chart is a list of the activities and along the top is a suitable time scale. Each activity is represented by a bar; the position and length of the bar reflects the start date, duration and end date of the activity. This allows you to see at a glance:
- What the various activities are
- When each activity begins and ends
- How long each activity is scheduled to last
- Where activities overlap with other activities, and by how much
- The start and end date of the whole project
This article focus on ORA_HASH function in Oracle. This function computes a hash value for a given expression.
This short article presents how to solve ORA-22828 error.
ORA-22828 happens when you try to replace part of a CLOB with a CLOB bigger than 32K using standard functions like REPLACE, REGEXP_REPLACE.
This article presents how to install Fedora 23 – Live Workstation version.
I assume you have already downloaded Fedora 23 64 bit Live Workstation(about 1,37 G) and you know how to use VirtualBox 64 bit(100M). Create virtual machine with default settings for Linux Fedora 64 bit. 2GB ram and 64G(includes extra space for Oracle installations) for disk is enough plus increase video memory to 128M. Rest of options you can keep default.
This article show how to translate string separated by a character