Install Fedora 24

This article presents how to install Fedora 24 – Live Workstation version.

I assume you have already downloaded Fedora 24 64 bit Live Workstation(about 1,4 G) and you know how to use VirtualBox 64 bit(100M). Create virtual machine with default settings for Linux Fedora 64 bit. 4GB ram and 64G(includes extra space and memory for Oracle installations) for disk is enough plus increase video memory to 128M. Rest of options you can keep default.

fedora24_1

Continue reading

Oracle PGA monitoring using ASH and AWR

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)
  • hash-join
  • bitmap merge
  • bitmap create

Continue reading