I make unpleasing sequences of 0s and 1s into pleasing sequences of 0s and 1s.
Here is some code to update the previous widget to show data in a green/yellow/red bar graph like an audio meter: The code is here: CREATE OR REPLACE FUNCTION GetGraph (p_value IN NUMBER, p_total IN NUMBER DEFAULT 100) RETURN VARCHAR2 IS -- David Mann --…
I'm trying not to scare my users off with endless rows and columns of numbers. I have an app that analyzes memory usage and swap space usage of some of our servers. Instead of throwing all kinds of computer sciency '65535' and '32767' numbers at…
If you use Solaris Zones sometimes it is nice to be able to know the name of the global/parent machine the zone is running on. Using 'arp -a' you can get information about network interfaces shared by the hosts on 1 machine. I'm not going…
Now that I am working in an environment where I am responsible for more database instances it seems like data is always moving around. Machines are being retired, platforms are changing, all kinds of fun stuff. I often have to move using regular old Oracle…
I added a new tutorial to my collection of SQL Developer information. The tutorial covers creation of a HTML Custom Report for SQL Developer. Here is an example of the report running and showing 1 long operation (click to enlarge): If you would like to…
I had some trouble adding a new database to an OEM Grid installation this weekend. I didn't find too many references to the above error so I wanted to post about it here. Of course Metalink was all doom and gloom. Note 745795.1 says to…
When copying or moving databases it is nice to know if features are used or not. Sure you can always query DBA_REGISTRY to see what has been set up on the source databases, but is it always necessary to install everything that shows up in…
You may notice a new look. I left WordPress in the dust and have adopted <a href="https://www.drupal.org">Drupal</a> Content Management software. For 2 years I had problems trying to get Perl, shell scripts, and PL/SQL code to show up correctly in WordPress. Once I had a…
After using many different tools to generate DDL I usually end up back at DBMS_METADATA. DBMS_METADATA is an Oracle supplied package that became available with Oracle 9. DBMS_METADATA is an API that can be used to generate the DDL of most any object in an…
In past Oracle versions you may have used USERENV() to access some of this information. The information is now available in the 'USERENV' namespace of the sys_context function. http://www.techonthenet.com/oracle/functions/sys_context.php Here is a useful example. When monitoring the current in-flight SQL it is nice to exclude…
I'm still an Application Express beginner -- I'm used to web development that is closer to the HTML. While I am getting used to Apex's Regions and Templates sometimes you just need to build some HTML on your own. I have found some Apex helper…
I've been doing some speed testing of rebuilding indexes. I have been adding the PARALLEL clause to my alter index ... rebuild; statements but it has been suggested to me to also run multiple indexes rebuilds in parallel. So if I am wanting to run…
Its time to test some IO. I have used OraBM/OraStress in the past to throw a load at an Oracle server. (DMann 08-APR-2015 Note: Hammerora has been renamed HammerDB and is available at : http://www.hammerdb.com/ - This post may not be up to date with…
Yup. I'm tired of hearing this from users. Since I changed jobs from a software development house to a more focused DBA role I hear this a lot. As much as I'de like to just log into their app server and comb through logs to…
I had a user that called me about jobs not running on a 9i database. I logged in and found a complete mess. Broken jobs, some DBMS_JOB calls would hang, jobs existed for users that no longer existed (I didn't even know that was possible!).