Careers & Certifications

00:30 AM
Commentary
Commentary
Commentary
50%
50%

More Fun With Databases

Today's entry is brought to you by the number 01114 and the letters O,R and A. That's right, it's "ORA-01114: IO error writing block to file 201" I started seeing this one late this afternoon while testing one of the...

Today's entry is brought to you by the number 01114 and the letters O,R and A.

That's right, it's "ORA-01114: IO error writing block to file 201"

I started seeing this one late this afternoon while testing one of the products in our BI review and now, at 7:30 in the evening, I have the problem fixed. For some reason the TEMP tablspace in Oracle is maxed out at 4GB. But the real problem was that it must have gotten locked at some point and wouldn't allow any large queries to go through. A quick reboot of the server cleared the TEMP files and released the locks, so finally the BI tools are able to figure out how much $$$ in sales we've made off specific categories of widgets.

In case you're curious, here's the results from the horse's mouth:

SUM(ORDERS.TOTAL) CATEGORY
----------------- ------------
       14103848.9 CAFFEINE
       12289291.3 IM
       13287830.4 LASER
       16861087.5 LIGHT
        9980358.7 MP3
       11493839.8 ROBOTS
       11513981.1 SMART CARD
       22925430.2 STORAGE
       12541190.6 VOICE
       12713046.1 WATCHES
         18839119 WIRELESS

Previous
1 of 2
Next
Comment  | 
Print  | 
More Insights
Cartoon
Slideshows
Audio Interviews
Archived Audio Interviews
Jeremy Schulman, founder of Schprockits, a network automation startup operating in stealth mode, joins us to explore whether networking professionals all need to learn programming in order to remain employed.
White Papers
Register for Network Computing Newsletters
Current Issue
Video
Twitter Feed