Oracle Tidbits – November 2016 #oratidbit

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

Oracle Tidbits – October 2016 #oratidbit

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

OTN Appreciation Day: The ORAchk and EXAchk Tools #ThanksOTN

Thanks Tim for coming up with this idea! Pretty neat… And THANK YOU OTN!! There are quite a few features I like in the Oracle Database, but today I choose ORAchk (and EXAchk). Troubleshooting and diagnostics are my favorite area and I was amazed by the enhancements Oracle made in integrating the various diagnostics tools and preserving … Read more

Rest of 2016!

On LinkedIn I wrote a note on the conferences I will be speaking in 2016. Read it here…. Dallas Oracle User Group – October 7 East Coast Oracle Conference – November 3 German Oracle User Group (DOAG) – November 17 Hope you see you in one of these conferences… 🙂  

Oracle Tidbits – September 2016

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

Approximate Query Processing in 12c Release 2

Approximate Query Processing appears to be a major feature of Oracle Database 12c Release 2 SQL. In 12cR1 patchset 2 (12.1.0.2), we saw one approximate query function appear – APPROX_COUNT_DISTINCT to use instead of COUNT(DISTINCT). In 12.2 there are several APPROX functions introduced:   APPROX_COUNT_DISTINCT_DETAIL APPROX_COUNT_DISTINCT_AGG TO_APPROX_COUNT_DISTINCT APPROX_MEDIAN APPROX_PERCENTILE APPROX_PERCENTILE_DETAIL APPROX_PERCENTILE_AGG TO_APPROX_PERCENTILE According to Oracle … Read more