Oracle #DB12c New – PGA_AGGREGATE_LIMIT

Program Global Area (PGA) in Oracle database is a private memory region that contains the data and control information for a server process. PGA is allocated per server process, used for storing run-time area of cursor, sorting, bitmap merge, etc. Automatic PGA management in Oracle Database was managed by two parameters up until 11gR2 – … Read more

Oracle Tidbits – April 2015

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

Preventing CREATE (only) for a User

The PL/SQL reference guide has a short section and example for the INSTEAD OF CREATE ON SCHEMA trigger. Since the description was so little and could not find much detail on the internet, tried some examples as below. This feature is good to prevent any CREATE operation for an user, giving him/her privilege to alter or drop … Read more

Oracle Tidbits – March 2015

“Oracle *daily* TidBits” (#oratidbit) published at https://www.facebook.com/oraclenotes on weekdays in March 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… 2-Mar #oratidbit You can perform … Read more

TNSNAMES.ORA Learning

If I have an alias entry named “TEST1” in tnsnames.ora twice with different descriptions, which one will Oracle*Net use when connecting to database? What if the duplicate alias entry is in the IFILE referenced from tnsnames.ora – which entry will be used? In my tests, Oracle*Net reads the tnsnames.ora file from bottom up. So if there … Read more

Oracle Tidbits – February 2015

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

Oracle Tidbits – January 2015

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

Pre-Built Oracle Database 12.1.0.2 on VirtualBox

Step by step screenshots showing the installation of Virtual box and configuring pre-built Oracle Database 12.1.0.2 (including in-memory option). A quick way to get started on Oracle Database 12c. This is a very easy setup, though many do not know how easy it is to get started and playing with Oracle Database 12c on Linux … Read more