December 2015 archive

SQL Developer 4.1.3 Released

The newest version of SQL Developer was released while I was out of the office last week. The download is in the usual place. http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html   According to viagra pills for women sexologists, there are multiple reasons for this secrecy. During that time, liver bile is redirected to generic cialis the gallbladder. buy bulk viagra …

Continue reading

A Trip Through the GIMR

Oracle Grid Infrastructure includes the Cluster Health Monitor (CHM) which regularly captures OS-related performance information. In early versions, CHM use a Berkeley DB for its data store. In Grid Infrastructure 12.1.0.2, it is now required to use an Oracle database for the data store. This Oracle database is called the Grid Infrastructure Management Repository (GIMR). …

Continue reading

LongOpsWatcher in SQL Dev

I saw a video of someone who used the new command line utility, sqlcl to create a bar graph showing the progress of long operations in Oracle, as seen from V$SESSION_LONGOPS. That video inspired me to do something similar in SQL Developer. Below is a video of LongOpsWatcher in action. You can see the time …

Continue reading

Fast Split Partitioning

I have a partitioned table for some application logging. A few years ago, I partitioned the table with one partition per month. As we near 2016, its time for me to add partitions for the new year. The partitioned table has, as its last two partitions, the partition for December 2015 and a partition using …

Continue reading

SQLT in 12c Can’t Gather Stats

After upgrading to 12c, I did have some issues where processing in our database was running into the following errors: ORA-20000: Unable to gather statistics concurrently: insufficient privileges The fix was pretty easy. I found information on Tim’s Oracle Base website on the workaround here: https://oracle-base.com/articles/12c/concurrent-statistics-collection-12cr1 Today I tried to run SQLT’s sqlxtract script to help …

Continue reading