Monthly Archives: marzo 2016

ORACLE 12C :  Listener service registration
  • 21
    Mar

ORACLE 12C : Listener service registration

With previous releases PMON (Process Monitor) was responsible for registering database services to the Listener. Starting from Oracle 12C there is a change in architecture with respect to the service registration in Oracle Database Release 12c. Oracle has introduced a new mandatory background process dedicated for “database service registration to the Listener” and named LREG (Listener Registration Process). The...

Read More
ORACLE 12C : approx_count_distinct parameter
  • 2
    Mar

ORACLE 12C : approx_count_distinct parameter

The APPROX_COUNT_DISTINCT function was added, but not documented, in Oracle 11g to improve the speed of calculating the number of distinct values when gathering statistics using the DBMS_STATS package. Oracle database 12c (12.1.0.2) now includes the function in the documentation, so we are free to use it in our applications as a supported SQL function. It returns approximate...

Read More