Technical Debt

As a system grows, it accumulates technical debt – improvements and cleanup that your really ought to get around to doing. However, no-one ever budgets time for this kind of refactoring and cleanup.

The consequence is that any major change opens a Pandora’s box of interrelated problems. I’m involved in a project where we thought we could simply make a minor change to all 2768 tables, but due various historical design decisions over the year (more...)

Making your JSON-P (JSR-353) code slightly prettier

The JSON-P API as described in JSR-353 is a limited API for working with JSON; but at the basic level it will do the job. It is possible to add a few utility methods that can make your code, in my eyes, prettier.

The first think that annoyed me was the use of Json.createObjectBuilder() and Json.createArrayBuilder() when trying to construct a JSONObject.

So lets create a nice helper class with some very short (more...)

TRUCEConf

Please consider participating in TRUCEConf (March 18-19 in Cincinnati)!

The goal is to help the tech community heal, through learning from others outside our industry and having an open dialogue and on how we can be better humans to each other in the world of tech.

You may remember fierce controversy around TRUCEConf when virtually nothing was known about it but its name; without solid information, it was easy to read bad connotations into the (more...)

Tools that I use – uptimerobot.com


http://uptimerobot.com is service that can monitor if you sites are up and running. I have been using it for more than 3 years and it works very well.
The service is free and you can add up to 50 monitors. It is easy to configure a monitor. You don’t have many options, but it can do just what I need.

You can create 4 types of monitors.

  • http(s): that’s perfect for website monitoring. The (more...)

Speaking at OTN Yathra (India)

Speaking @ http://t.co/E0KUudWOLn Mumbai/Pune/Chennai In-Database#MapReduce for DBAs and Database Developers using SQL or #Hadoop

Speaking during Collaborate 2014

Time is passing very quickly ……I’m just recalling year 2012 and I was at Collaborate 2012 in Las Vegas  and now year 2014…. & Collaborate 2014 is on !!! This year during Collaborate 14, I am pleased to share I have been selected to present at COLLABORATE 14: Technology and Applications Forum for the Oracle Community […]

The post Speaking during Collaborate 2014 appeared first on ORAERP.COM - Blogs.

WLST script for listing WebLogic Server memory usage

Here is a short script for listing Java heap usage for all WebLogic Servers in a domain.

domainRuntime()

servers = domainRuntimeService.getServerRuntimes();
print('################################################################')
print('# Java heap information per server')
print('################################################################')
print('%20s %10s %8s %8s %4s' % ('Server','Current','Free','Max','Free'))
for server in servers:
   free    = int(server.getJVMRuntime().getHeapFreeCurrent())/(1024*1024)
   freePct = int(server.getJVMRuntime().getHeapFreePercent())
   current = int(server.getJVMRuntime().getHeapSizeCurrent())/(1024*1024)
   max     = int(server.getJVMRuntime().getHeapSizeMax())/(1024*1024)
   print('%20s %7d MB %5d MB %5d MB %3d%%' % (server.getName(),current,free,max,freePct))

disconnect()
exit()

Execute (more...)

‘active txn count during cleanout’, part I

I was going to write a blog post about some peculiar side effects you can get into with the delayed block cleanout when running parallel DML but soon discovered that the entry became so big that I've decided to split it up into a series of more manageable posts.

For a good background on various themes of block cleanout check out Clean it up by Jonathan Lewis.

Active transactions, consistent reads and table scans

First (more...)

Changes and Book

I just realized that i have not blogged in a very long time. This has been partly because i switched jobs and started working for Oracle.  it has been an interesting six months and i have been enjoying the challenge of working with various customer and helping them solve problems.
The other thing that has been an important milestone in my career is the publishing of a book that collaborated with a very fine (more...)

January diet for IT departments

January is almost over, which means that most people have already given up their New Year’s resolution to become leaner in 2014.

However, your IT organization should become leaner – in January as in every other month. The application of “Lean” methodologies in IT (Lean IT) is well understood, but most organizations still have a lot of waste to eliminate.

When working as a consultant, I get to experience the provisioning process of (more...)

The ASM password directory

Password file authentication for Oracle Database or ASM can work for both local and remote connections. In Oracle version 12c, the password files can reside in an ASM disk group. The ASM metadata structure for managing the passwords is the ASM Password Directory - ASM metadata file number 13.

Note that the password files are accessible only after the disk group is mounted. One implication of this is that no remote SYSASM access to ASM (more...)

IOUG’s 2014 Exadata Virtual Conference

IOUG is organizing a two-day virtual Exadata Conference on 29-30 Jan, 2014. More importantly the virtual conference is FREE. Following is the agenda as per the IOUG's website:

29-Jan-2014 (Wednesday)

10-11am CST
Minimizing Risks with Database Consolidation on Exadata using I/O Resource Manager (IORM)
Speaker: Sameer Malik, Exadata Technical Architect, Accenture
11am-12pm CST           
Introduction to the New Oracle Database In-Memory Option
Speaker: Kevin Jernigan, Senior Director, Oracle
12-1pm CST
Understand the Flash storage and (more...)

crsd.bin core dumps

Core dump issues sometimes can be notoriously difficult to troubleshoot. I've got a call this morning from one of my customers saying that after a power outage Grid Infrastructure is not able to fully come up on some nodes on their Exadata cluster. After further examining the situation it turned out that crsd.bin binary is simply core dumping upon start up.

Troubleshooting Grid Infrastructure startup issues when nothing is core dumping sometimes could be (more...)

WebCenter LDAP Filters Explained!

We recently has a client with some LDAP performance issues, and had a need to tune how WebLogic was querying their LDAP repository. In WebLogic, the simplest way to do this is with their LDAP Filters. While trying to explain how to do this, I was struck by the lack of clear documentation on what exactly these filters are and why on earth you would need them... The best documentation was in the WebCenter guide (more...)

Rocky Mountain Oracle Users group event

 
Join me at #RMOUG Feb 6th 8:30 Rm 504:; i'll be presenting #JavaPerf., Scalability, Availability & Security w Oracle #db12c --#OracleRac -- http://bit.ly/1cgzgy1

OTN Virtual Developers Days

Join me on Feb 24 @ http://t.co/nheuk9MBZd

at 10:15am: "In-Database MapReduce w SQL & Hadoop"  then 12:15pm "Best Practices 4 App Performance, Scalability and High-Availability with Oracle Database 12c"

Internet Access with VirtualBox & Host-only Networks (on OS X Mavericks)

Introduction

When creating VMs on my laptop I like to configure the minimum number network interfaces. I also tend to end up with environments where I want multiple VMs to be able to see each other, see the internet and see my physical host. It seems many people using VirtualBox use the approach of having a “Host-only Adapter” interface and a “NAT” interface. The only reason I have for not liking this is that it (more...)

Unwarrented Programmer Power

I’ve recently been involved with helping a customer decide on their strategic IT development direction for the next decade.

It never ceases to amaze me how much power programmers have. A decision that will affect the whole organization for years and years ends up being determined by which tool the developers like best.

And which tool do they like best? The one where you get to write a lot of code. No wizards, no assistance, (more...)

The Oracle SOA Suite and the OSB are now free for developers!

I did not notice it myself but over Christmas Oracle made the SOA Suite and the OSB free for developers.

I found out via the January issue of the Oracle SOA Partner Community Newsletter, issued by
Jürgen Kress. You can sign-up for the newsletter here: http://www.oracle.com/goto/emea/soa.

You can download most Oracle FMW software for free on the OTN download site. Although you do not have to pay to download the software, it is (more...)

Cloning Oracle 12c Home Binaries

Almost every backup and recovery concern is focused on protecting the data stored inside database and rightly so. But during the course of a DBA career, restoring the Oracle Home or duplicating is sometimes is necessary.

The post Cloning Oracle 12c Home Binaries appeared first on VitalSoftTech.