tag:blogger.com,1999:blog-66635432012-02-14T10:34:16.048ZThoughts, discoveries and otherwise maybe useful stuff about the Oracle RDBMSNiallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.comBlogger1631100tag:blogger.com,1999:blog-6663543.post-64400402059009709712010-04-28T10:14:00.001Z2010-04-28T10:24:19.290Z

This blog is now located at http://nlitchfield.blogspot.com/. You will be automatically redirected in 30 seconds, or you may click here. For feed subscribers, please update your feed subscriptions to http://nlitchfield.blogspot.com/feeds/posts/default.

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com16tag:blogger.com,1999:blog-6663543.post-1138105834324622362006-01-24T12:29:00.000Z2006-01-24T12:30:34.366Z

As I alluded to here I have been looking at moving and redesigning the site for a small while now. The move is more than a simple transfer of blog host from my ISP though. The new site at OraWin.Info, is designed to continue the existing blog on, as I say above, various thoughts, discoveries and otherwise maybe interesting Oracle related content, but also to serve as a resource focussed on the

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com3tag:blogger.com,1999:blog-6663543.post-1137598788091765432006-01-18T15:31:00.000Z2006-01-18T15:39:48.160Z

There is an interesting security advisory over at the security company imperva. The paper details a network exploit fixed by Oracle in the latest CPU. The exploit itself is interesting, but reading the advisory complete with 'advice' that regurgitates some of the recent discussion about the timeliness of Oracle's patching and suggests purchasing a type of product that the vendor supplies does

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com3tag:blogger.com,1999:blog-6663543.post-1137405665041270552006-01-16T09:50:00.000Z2006-01-16T10:01:05.063Z

Given my predelictions for both Coffee and Oracle, I can't believe that I have missed Life after Coffee up until now. This is a very nice looking blog, with great content. There is a bunch of Oracle stuff of course, but the neatest thing that I have found so far is a replacement method for determining what is on at the cinema. My previous method would be to try to recall the name of the local

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com2tag:blogger.com,1999:blog-6663543.post-1137144961468253092006-01-13T09:18:00.000Z2006-01-16T09:36:12.823Z

By way of an answer to a question on Oracle-l regarding how to intepret a 10053 trace file, I posted a link to one of a new series of articles available on Oracle's Metalink service. I think it worth mentioning these articles here as well, as I haven't seen any publicity for them. Oracle's Center of Expertise (COE) have put together a number (5 at the time of writing) of case studies from Oracle

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com2tag:blogger.com,1999:blog-6663543.post-1136470223782175442006-01-05T13:57:00.000Z2006-01-05T14:10:23.820Z

In this thread over on AskTom, Tom makes a thought-provoking observation namelyDBAs should not be allowed to directly modify application tables, they have no clue what the ramifications could be.No more than they would update the data dictionary! The argument is that DBAs, just like anyone else, should use the appropriate API or application to modify application tables. I rather like this

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com9tag:blogger.com,1999:blog-6663543.post-1136234849863743122006-01-02T20:18:00.000Z2006-01-02T20:47:29.926Z

Is how Howard describes this blog's look and feel here. (naturally just after I disappear off the net for two weeks). He goes on to make the most excellent point that look and feel counts and is a part of the content of the site. I have to say that quirky probably sums me up as well as most single word summaries would, and I'd consider it a compliment even if it were not so intended. However I do

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com9tag:blogger.com,1999:blog-6663543.post-1134597761012371792005-12-14T18:49:00.000Z2005-12-14T22:02:41.066Z

I'm off to sunny Florida tomorrow, followed by freezing NJ a week later, so I thought now would be a good time to look back at 2005. There are probably as many ways to do this as there are sunday newspaper supplements, but I've chosen to pick my choice of the top posts from various Oracle blogs (plus a couple of associated sites). I'll start, as my teachers taught me, at the beginning. Lisa

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com9tag:blogger.com,1999:blog-6663543.post-1134037412964720472005-12-08T10:15:00.000Z2005-12-08T10:23:58.906Z

I have added a couple of items to the Resources list on the right hand side of the site. The first is my Guide to Generic Connectivity which I inexplicably failed to link to when I originally posted it. The second is the second presentation that I gave at the recent UKOUG conference on retro-fitting Oracle 10g style end-to-end tracing (down towards the bottom of the page) to Oracle 9i and below

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com0tag:blogger.com,1999:blog-6663543.post-1133960147333124342005-12-07T11:32:00.000Z2005-12-07T12:55:47.366Z

Thanks to Doug Burns who points out this article that claims to show by deductive logic that SQL Server is a superior platform to Oracle. Now I don't think there are many who will rush to agree with the article, and as Doug says it is briefly amusing. Unfortunately I find it rather sad in the end. The reason I find it sad is that in fact the author does not employ deductive reasoning at all. His

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com5tag:blogger.com,1999:blog-6663543.post-1133906691154225692005-12-06T21:55:00.000Z2005-12-06T22:04:51.166Z

In common with other sources, I may have accidentally given the impression that Rafa Benitez clearly didn't have a clue what he was doing and that winning the Champions League last year was an unfortunate fluke that would permanently harm Liverpools progression; following Peter Crouch's match winning performance on Saturday and the second 0-0 win over Chelski in as many years I can only conclude

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com2tag:blogger.com,1999:blog-6663543.post-1133789044932939122005-12-05T12:49:00.001Z2005-12-05T13:24:04.983Z

We were having the NULL conversation at work today. During the course of which I asserted that you could build a unique index on a nullable column, but that the nulls would not be indexed. My colleagues asserted that you couldn't. So some testing was done. SQL> drop table t1;Table dropped.SQL> create table t1(c1 number not null, c2 number);Table created.SQL> insert into t1(c1,c2) values(1,null);

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com4tag:blogger.com,1999:blog-6663543.post-1133282299488458082005-11-29T16:28:00.000Z2005-11-29T16:38:19.490Z

To double post. I have removed the first version of the Oracle Express/AD posts from yesterday. Sorry about that. A question that hasn't been asked, but probably should have been, about yesterday's posts is Why would you want to do this in custom code?. HTMLDB already has an LDAP authentication mechanism built in. In my case the simple answer is that I just want to make my application available

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com3tag:blogger.com,1999:blog-6663543.post-1133195707720691432005-11-28T16:05:00.000Z2005-11-28T16:35:07.733Z

A recent post on the Oracle XE forum about replacing mod_ntlm as an authentication mechanism for applications on Windows prompted me to write up a mechanism you can use to authenticate users of your application against a Microsoft Active Directory. It works as follows. You create a custom authentication function for HTMLDB this must take two parameters of specific names, and only those two

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com10tag:blogger.com,1999:blog-6663543.post-1132675039318473292005-11-22T15:54:00.000Z2005-11-22T15:57:19.330Z

During a discussion about a poorly designed in-house system that has been extended in an ad-hoc, undocumented and uncontrolled fashion (I know my readers have none of these things but bear with me), the designer claimed.This behaviour is an emergent property of the systemBeats bug any day.

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com5tag:blogger.com,1999:blog-6663543.post-1132606984281571952005-11-21T20:28:00.000Z2005-11-21T21:03:04.363Z

Which is what the title of my last post becomes if you play Chinese Whispers for too long. The reason for this post, Howard has posted a follow up, to my follow up to Pete's followup to a post on pete's forum. Yep, Chinese whispers alright. Anyway Howard as usual makes some excellent points. In particularBut I'm afraid I take the old-fashioned view that a breach of security in a database means

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com4tag:blogger.com,1999:blog-6663543.post-1132577449286727252005-11-21T12:28:00.000Z2005-11-21T12:50:49.983Z

Pete Finnigan has posted an interesting article on his security related blog. In it he makes the following suggestions to Oracle Corp. Come on Oracle, lets have a secured installation option - (how about a secure wizard option?). * set all parameters that could cause insecurities to safe values * force all installed users passwords to be set - and not to any dictionary word * install

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com1tag:blogger.com,1999:blog-6663543.post-1131983696731521082005-11-14T14:55:00.000Z2005-11-14T15:54:56.766Z

As many will be aware the support for Oracle XE is peer support, by way of a hosted forum over at forums.oracle.com. This is a place I intend to frequent regularly, but boy is my patience wearing thin. I first started getting annoyed with the login process last week, but today I have tried 4 times to login. The average length of time from hitting go on the username/password screen to seeing the

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com8tag:blogger.com,1999:blog-6663543.post-1131704214363409432005-11-11T09:37:00.000Z2005-11-11T12:16:30.456Z

I got asked a question yesterday which required me to revisit some old knowledge. The question was this. I have a 9i database on server1 and I want to clone it to server2. I do have a cold backup of the database from server1 to restore to server2 but the directory structure is slightly different. In other words how do I duplicate a database from one location to another. My initial answer was as

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com5tag:blogger.com,1999:blog-6663543.post-1131344619597277992005-11-07T06:18:00.000Z2005-11-07T06:23:39.613Z

There is a thread on the new Express forum here (registration of Express required) on backing up Express Edition. If you have registered and have views on whether Express should ship with the same backup and recovery capabilities as the paid for editions of Oracle then this is the place to go. Just to be clear Express will have backup and restore capabilities, but there is an internal debate that

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com0tag:blogger.com,1999:blog-6663543.post-1130842688033155232005-11-01T10:42:00.000Z2005-11-01T10:58:08.050Z

Just some quick observations before I go attend Lisa Dobson's presentation on how to be a newbie. If you are arranging a big conference, do try to make sure you hold it in a city with reliable power. Central Birmingham losing all power just as registration opens for 2500 delegates was not a good thing. The organisers did fantastically well to keep day one on track. A note for foreign visitors. If

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com2tag:blogger.com,1999:blog-6663543.post-1130616110945741472005-10-29T19:26:00.000Z2005-10-29T20:01:51.026Z

Wim was the first with the news that Oracle will release a free version of the Oracle 10g R2 database, to be called Oracle Express Edition. You can grab yourself a copy for either Linux (hence Wim's interest) or Windows (hence mine) from OTN here. There are some interesting features of this product on first viewing. It doesn't use the Universal Installer, on windows it uses the Windows Installer

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com10tag:blogger.com,1999:blog-6663543.post-1130342800514459252005-10-26T15:47:00.000Z2005-10-26T16:06:40.570Z

A couple of things got me thinking about this this week. The first was a discussion on Oracle-l, but really it could be any forum, about RTFM replies and if the list should be split in 2; one for newbies and one for experienced dbas. The second was Sandy's posting about grumpy old men (and women). She, correctly in my opinion, identified a problem that we have as a group of professionals. Namely

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com5tag:blogger.com,1999:blog-6663543.post-1130182017382070852005-10-24T18:55:00.000Z2005-10-24T19:26:57.433Z

Jared Still pointed this article out on Oracle-L. It is difficult to describe how astonishingly stupid this research is, as reported. The premise of Gartner's argument is that as improvements in networking technologies eventually lead to real-time connectivity to any data, that that data is best kept closest to its natural source rather than at the intersection of a row and tuple of a database

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com13tag:blogger.com,1999:blog-6663543.post-1129926260219087402005-10-21T19:48:00.000Z2005-10-21T20:28:24.356Z

Well the official Agenda is at the UKOUG conference site here. This is my personal agenda, listed with two aims in mind. First, if the blog has been helpful or a hinderance and you will be there this will be an opportunity to pester me about it.Second, My mind is beginning to turn towards 2006 and various sessions that might be useful to run at the Oracle on Microsoft SIG of which I am a co-chair

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com3tag:blogger.com,1999:blog-6663543.post-1129819622515153152005-10-20T14:33:00.000Z2005-10-20T14:48:30.106Z

In passing Howard mentioned Oracle 10g licensing in this blog entry. In his words It seems to me the 10g licensing is all over the place on this one where this one refers to the premium content in EM, or Enterprise Manager packs as they are sometimes known. As this is about the third posting I have seen recently on this issue i thought I'd recap the situation I described earlier. The official

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com0tag:blogger.com,1999:blog-6663543.post-1129721901204829432005-10-19T11:31:00.000Z2005-10-19T11:38:21.210Z

Via Doug Burns posting on ANSI syntax (which I hugely prefer despite the odd suspicion that the implementation isn't as robust as the old style) I came across Nomad8's Oracle Blog. I suspect I'll keep coming back to this one. Anyway good things about it. The clear layout - I can't do GUI design nomad8 can. The evidencing of assertions It is another female member of the Oracle community - we need

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com3tag:blogger.com,1999:blog-6663543.post-1129661266588953162005-10-18T18:41:00.000Z2005-10-18T18:50:00.123Z

I was going to respond to a comment on Howard's blog. This requires both registration and word verification for the signup. A step more than mine but not unreasonable. The image I got however I thought most unreasonable. I'm only just 38 and found this more than a little unreadable. Perhaps I am a bot?

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com6tag:blogger.com,1999:blog-6663543.post-1129203835197797112005-10-16T20:11:00.000Z2005-10-16T19:16:04.070Z

I've been mulling over a few instances of wheel re-invention recently, the first was inspired by this entry over at Igor's lab. Igor has a neat way of displaying the time a record was committed. Unfortunately for me, it rather gets spoiled by the suggested applicationNormally, it is difficult to pick records added or updated in a table since a particular time, as the delay between change and

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com0tag:blogger.com,1999:blog-6663543.post-1129488955511794002005-10-16T18:53:00.000Z2005-10-16T18:55:55.516Z

to Howard Rogers for a nice email in which he pointed out one (of the possibly many) things that irritated him about this blog - no not the colour the bad width in the sidebar. And also gave clear and precise directions as to how to fix it. So, possibly with a ctrl+f5 to force refresh, you should be able to see the whole of the blog now.

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com0tag:blogger.com,1999:blog-6663543.post-1128366246006764532005-10-03T19:02:00.000Z2005-10-04T05:28:27.090Z

I could reference this to Tom Kyte's 4 years to get experienced thread (haven't these guys heard of Hendrix) but I won't. Peter Scott has a blog entry on describing one's job to one's children. I'm afraid it rather reminded me of an experience I had a while back at my sister in-law's wedding. I am married to a patent agent (that's patent attorney for all you American's - or evil incarnate for

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com15tag:blogger.com,1999:blog-6663543.post-1128339539699854512005-10-03T11:09:00.000Z2005-10-03T11:39:00.056Z

Release 2 of the Oracle Developer Tools for Visual Studio.Net is here. When coupled with Oracle Database 10g Release 2 on Windows, this makes building and deploying .Net managed stored procedures to the Oracle database a reality. Interestingly this confirms the prediction, but not the hopelessly incorrect dates, I made at the time of last years Open World that Oracle would support CLR stored

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com1tag:blogger.com,1999:blog-6663543.post-1128022781059664522005-09-29T19:30:00.000Z2005-09-29T19:39:41.066Z

Apparently around Don's way there is a classic database problem. No-one has surnames and they all have the same first name. One could of course use an artificial key, but Don has hit on a better solution. Sequence numbers for surnames. You never know it could be the way forward, in fact it might make the UK National ID Card a simpler implementation. Niall 666

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com7tag:blogger.com,1999:blog-6663543.post-1127737631435087052005-09-26T12:15:00.000Z2005-09-26T12:27:11.943Z

I just noticed that OTN has a new (to me) section for blogs from Oracle Executives. At the moment there are precisely 3, all apps, Senior VP blogs there. (What a terrible job title by the way - I'll bet my bottom dollar there isn't anyone with a post of Junior VP out there). John Wookey who is VP for Applications Development. Jesper Andersen who is VP for Applications Strategy. Cliff Godwin who

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com4tag:blogger.com,1999:blog-6663543.post-1127680109733487182005-09-25T19:51:00.000Z2007-07-10T18:31:13.499Z

Mark Rittman posted some interesting thoughts on confidentiality and blogging today. Tom Kyte picked up on them as well. Don Burleson has posted a number of links regarding hypothetical legal issues as well. Anyway Mark asked for thoughts from other bloggers, and partly by way of making a point, I thought I'd comment here. I happen to think, and am as confident as an educated layman can be that

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.comtag:blogger.com,1999:blog-6663543.post-1127421068526680602005-09-22T19:58:00.000Z2005-09-22T20:31:08.533Z

The annual conference of the UK Oracle Users Group is now only 5 weeks or so away. This conference, which is the largest Oracle gathering in Europe and is a user driven rather than Oracle marketing driven event, takes place in Birmingham UK from October 31 to November 2nd. For those of you that book early enough and can get there on Sunday this year we are introducing an Oak Table day. 10

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com3tag:blogger.com,1999:blog-6663543.post-1127402525979380112005-09-22T14:57:00.000Z2005-09-22T15:22:05.990Z

I was intrigued by one of Cary Millsap and Tom Kytes favourite new features in 10.2 I thought I'd have a look at a 10.2 trace file. There surely is a lot more information in there. I have a table t1 which is just a copy of all_objects with no indexes etc. I ran select count(*) from t1; against it in 10gr1 and 10gr2. About as simple a test case as you can get. The 10.1 outputPARSING IN CURSOR #9

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com2tag:blogger.com,1999:blog-6663543.post-1127072205832028502005-09-18T19:34:00.000Z2005-09-18T19:36:45.836Z

Well of mice and small children. I have a Microsoft wireless mouse. I have a not quite two year old boy called Sam. I have a toilet. The three have interacted in a perhaps predictable manner. Suggestions for a suitable replacement mouse (must work with Linux) are welcomed.

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com5tag:blogger.com,1999:blog-6663543.post-1126814355136218302005-09-15T19:49:00.000Z2005-09-15T19:59:15.136Z

Just saw via orablogs that Scott Spendolini has moved on. HTMLDB is, in my view anyway, probably the must have new feature that Oracle have released in the recent past. Apologies to Sue Harper but I'd much rather folk used HTMLDB than JDeveloper for almost all normal size developments. This is partly a healthy disregard for java/j2ee, but partly a suggestion that HTMLDB has nearly all most normal

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com3tag:blogger.com,1999:blog-6663543.post-1126813184587581902005-09-15T19:33:00.000Z2005-09-15T19:39:44.593Z

two daft things today,1. I don't have an iso utility that can extract files from an iso image. (long story - not looking for recommendations here; I just don't have one). So that is fire up vmware, use the iso of the SQLServer CTP that was just released as the cd drive, then copy the contents of the virtual cd drive (which was a file on the host) back to the host so as I am ready to install this.

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com2tag:blogger.com,1999:blog-6663543.post-1126643550251361752005-09-13T20:26:00.000Z2005-09-13T20:33:20.840Z

This asktom threadIn which Burleson consulting employees (and a part owner) break their own guidelines in order to offer largely baseless attacks on fellow professionals.

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com9tag:blogger.com,1999:blog-6663543.post-1126556086742549622005-09-12T19:15:00.000Z2005-09-12T20:14:46.810Z

Nope, not posts to forums from people who ban their employees from posting to forums. Not vendors explaining that 'we never have this trouble with SQL server', not designers^H^H^H architects saying that integrity will be handled by the n-tier xml based client, nope pretty much nothing can prevent my joy tonight. The Ashes are home. 16 years we've waited. 16 years of second - or to be honest more

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com7tag:blogger.com,1999:blog-6663543.post-1126341970583967842005-09-10T08:44:00.000Z2005-09-10T08:46:10.586Z

TUSC are offering free help and support to businesses directly affected by Katrina. This is an excellent initiative. Well done to Rich Niemic and the rest of TUSC.

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com0tag:blogger.com,1999:blog-6663543.post-1126081844010613942005-09-07T08:23:00.000Z2005-09-07T08:30:44.073Z

There is a nice little example on the Daily WTF of how not to do things. Its a T-SQL example but neatly illustrates some common pitfals. Check out the responses here. Lessons to pick up. Use correct datatypes - storing numbers in chars. Bad Idea 1. Use the features of the db, don't reinvent the wheel in the name of cross platform compatability. SQL Server has an identity datatype that would have

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com1tag:blogger.com,1999:blog-6663543.post-1126037712385500212005-09-06T19:44:00.000Z2005-09-06T20:16:47.260Z

In an article dated June, but published today Don Burleson is at it again - enlisting big names in the aid of advertising books. This time the name is Charles Phillips, president of Oracle Corp. The quote from a search Oracle article "Moore's Law is coming to an end ... we are not seeing the same price performance improvement we have seen in the past," Phillips said.The 18-month rule where chip

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com2tag:blogger.com,1999:blog-6663543.post-1125667779654921202005-09-02T13:20:00.000Z2005-09-05T19:35:32.153Z

Just read Lisa's Oracle Newbie blog and saw she has some helpful tips for newbies. Tom Kyte had a similar set of suggestions on his blog a while ago. It got me thinking though. There ought to be a comparable set for experienced folk who take it upon themselves to offer help. I thought these might help. Newbie tips in Italics. Oldie Tips in bold.State your problem clearly. On a forum I frequent

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com3tag:blogger.com,1999:blog-6663543.post-1125603987399949572005-09-01T19:36:00.000Z2005-09-01T19:46:44.476Z

Thanks to Rob Vollman I came across oracle-wtf tonight. Inspired by the Daily-WTF its an Oracle specific what on earth were they thinking site. It should probably be read side by side with AngryDBA. Anyhow, this little example caught my attention. Why. Well a little while ago I came across this gem in a live system. CREATE TABLE (table name removed)(..."MONTH" VARCHAR2(255),"AGE" VARCHAR2(50),"

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com4tag:blogger.com,1999:blog-6663543.post-1125518956518616792005-08-31T20:07:00.000Z2005-08-31T20:09:16.523Z

My feed just disappeared from feedburner - and hence orablogs. Its a conspiracy I tell you. Or cock up on my part obviously.

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com1tag:blogger.com,1999:blog-6663543.post-1125504132507869672005-08-31T15:23:00.000Z2005-08-31T16:02:12.586Z

I note today that another reference to pga_memory_management has appeared on Don Burleson's Oracle News site. Its a reprint of a tip submitted to dba-village by Franck Pachot.Presumably its intended as yet more support for the Undocumented Secrets article on SearchOracle - though perhaps its a replacement for the various comments on Burleson Consulting related websites on the subject that have

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com10tag:blogger.com,1999:blog-6663543.post-1125002256999234802005-08-25T20:27:00.000Z2005-08-25T20:37:37.006Z

Thanks to Gabe on Tom Kyte's blog I became aware that blogger now attempts to stop spambots by the use of word identification. I've enabled this, and also enabled anonymous comments again. More to the point one of the things that came out of the Undocumented secrets debacle was the problem of rating good bad or indifferent web pages. David Aldridge pointed us towards stumble upon. This tool (its

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com3tag:blogger.com,1999:blog-6663543.post-1124894769762940592005-08-24T14:44:00.000Z2005-08-24T14:46:09.766Z

From Sarah Satterthwaite on the Oracle-l mailing listWhen documenting your code, be sure to also document your doubts about howyou did it. I find that most of the bugs that are found in my code arethings I wasn't very confident about at the time!

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com2tag:blogger.com,1999:blog-6663543.post-1124830780189166092005-08-23T20:11:00.000Z2005-08-23T20:59:40.230Z

I'm guessing that many of you that read this, also read Tom Kyte and Jonathan Lewis. The reverse is unlikely to be true for good reasons. Those of you that don't need to do some background reading now. 1. Tom's blog and comments 2. Jonathan's article3. Don's revised article (registration required - but its free and its an ok site, just avoid the spam).I'm actually quite glad of this disagreement

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com11tag:blogger.com,1999:blog-6663543.post-1124370445702668822005-08-18T13:00:00.000Z2005-08-18T13:07:25.706Z

I just noticed, thanks to Rob Vollman, that Anjo Kolk - of YAPP and Oraperf fame has started a blog. Definitely one to keep your eye on.

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com3tag:blogger.com,1999:blog-6663543.post-1124315874550245812005-08-17T21:44:00.000Z2005-08-17T21:57:54.566Z

Brother Roger of the Taize community in France was murdered yesterday. Those that know my religious background will likely not be surprised that this man, and his community, was and is, a huge influence on me. Roger Schutz was a man who, in WW2, in France founded a community that welcomed french, germans and brits in peace and for who they are. Taize today still follows that example. Those who

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com5tag:blogger.com,1999:blog-6663543.post-1124223349813017452005-08-16T19:16:00.000Z2005-08-16T20:15:49.853Z

Then I'll begin. This is how Listen with Mother started, way back when you could make sexist assumptions about the make up of your daytime radio audience. It's a great line and still used on the rather excellent cbeebies today. Mothers were also used in an interesting comment on usability on Tom Kyte's blog, to whit What would my mother do? That's the test I always apply to Windows software, and

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com1tag:blogger.com,1999:blog-6663543.post-1124134979074321112005-08-15T19:39:00.000Z2005-08-15T19:42:59.076Z

A talent Ricky Ponting and Shane Warne appear to possess in spades. Well done Australia. Now stop seeding our clouds - we have enough rain as it is.

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com1tag:blogger.com,1999:blog-6663543.post-1124118605328718672005-08-15T10:45:00.000Z2005-08-15T19:39:29.136Z

Each time that Oracle release a new version of the product a lot of attention is paid to the new features in that release. In fact once you've got an OCP then you get exams specially targetted at you, that only look at new features. Something that gets little attention is that the feature set differences between editions also tends to change. In particular Enterprise Edition features have a

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com0tag:blogger.com,1999:blog-6663543.post-1123771891816312732005-08-11T14:32:00.000Z2005-08-11T14:51:31.823Z

A long time ago, I took a first degree in Economics at the University of Bristol. Apart from explaining my tendency to waffle, and my desire to see theories backed up by evidence, it was where I first came across the latin ceteris paribus. This phrase translates roughly 'all else the same' and is used in thought or math experiments by economists to imagine all other variables being artificially

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com3tag:blogger.com,1999:blog-6663543.post-1123450816400409702005-08-07T21:37:00.000Z2005-08-07T21:40:16.406Z

Game On.Oracle service will be resumed shortly.

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com6tag:blogger.com,1999:blog-6663543.post-1123258698018837552005-08-05T16:13:00.000Z2005-08-05T16:18:18.023Z

If anyone else has downloaded the 10g Release 2 Developer Preview for Windows (aka beta 3 so far as I can tell) have you had any joy recreating the general purpose db - my creation fails because the restore of the users tablespace fails. I'm curious as to whether I got a bad download or it is repeatable error.

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com1tag:blogger.com,1999:blog-6663543.post-1123232277708398292005-08-05T08:22:00.000Z2005-08-05T08:57:57.770Z

I noticed on Chris Foot's blog, and confirmed by way of the readme, that in 10gR2 the CONNECT role has been neutered. Historically I, and many others, have advocated the banning of the CONNECT and RESOURCE roles, instead recommending using user-created roles or granting required privileges directly to user accounts. The CONNECT role has been a particular bug bear since it rather suggests that it

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com6tag:blogger.com,1999:blog-6663543.post-1121889830923926162005-07-20T19:45:00.000Z2005-07-20T20:08:03.213Z

No, really. I know if you've engaged a support analyst in fruitless conversations this can occasionally seem hard to believe. Still. Oh, what you wanted evidence as well? I'm afraid its that HTMLDB team again.not fit, shoelaces, tie. rearrange this into a well known phrase or saying and apply to me. It so happens that HTMLDB engage a guy called Tyler Muth (this is either a made up name or he is

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com7tag:blogger.com,1999:blog-6663543.post-1121799812379216122005-07-19T18:52:00.000Z2005-07-20T07:57:03.850Z

HTMLDB is in my view one of the coolest technologies ever released by any software company. It beats both 1-2-3 (I guess I'm showing my age) and WordPerfect for delivering real power to end-users and not geeks. Sergio from the HTMLDB team points out that training for the technology is available. The probably beats reading all the manuals, browsing the forums, reading the HOWTOs and googling.

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com4tag:blogger.com,1999:blog-6663543.post-1121780015438885152005-07-19T13:15:00.000Z2005-07-19T13:33:35.443Z

Duncan Mills posted just the other day about respect amongst experienced members of a technological community. What about respect for people that are just starting to engage with a community - in my case the dba/developer community? Well, I just noticed on Tom Kyte's blog that Lisa Dobson has made public a request for useful information for a presentation that she is doing for the UKOUG Annual

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com6tag:blogger.com,1999:blog-6663543.post-1121283790320156982005-07-13T19:42:00.000Z2005-07-13T19:43:10.326Z

site is currently down. as it is a free service I can hardly complain. try again later

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com0tag:blogger.com,1999:blog-6663543.post-1121255875057135522005-07-13T11:37:00.000Z2005-07-13T12:07:22.423Z

I was looking at speeding up a particular set of Create Table scripts today. This isn't something I'd normally bother much with - you create the tables once and that is it. However this script may be run repeatedly in development and so the developers wanted me to take a quick look see what you can do? I fired up EM Console and took a look at the session information dialog, primarily to see how

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com11tag:blogger.com,1999:blog-6663543.post-1120682030991238812005-07-06T19:17:00.000Z2005-07-06T20:58:22.590Z

10g includes some very significant advances in both manageability and diagnosis. Most of these features are exposed both through the Enterprise Manager product and internal PL/SQL APIs. However, should you be a Standard Edition customer, then these features are largely unavailable to you. In fact, Oracle Database 10g EM removes functionality that was available in 9i to all customers. I believe

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com8tag:blogger.com,1999:blog-6663543.post-1120596333883145382005-07-05T20:41:00.000Z2005-07-05T20:45:33.886Z

so. you added a datafile in the wrong place to the wrong tablespace because you never could type. The cure - just drop it - woops not available. Till now.In Arup Nanda's 10gR2 series. drop empty datafiles if you've never done this you'll be thinking, so what. If on the other hand you did this you'll be think whoopeee.

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com0tag:blogger.com,1999:blog-6663543.post-1120549670666713482005-07-05T07:45:00.000Z2005-07-05T07:47:51.236Z

As so often is the case with Danes, Niels Bohr was rightPrediction is difficult, especially if it is about the future.

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com4tag:blogger.com,1999:blog-6663543.post-1120222310807454432005-07-01T12:31:00.000Z2005-07-01T12:51:50.813Z

I got a question just the other day regarding problems with HTMLDB. Specifically the questioner had followed a perfectly sensible installation guide, but was getting a 404 error when trying to access HTMLDB. I replied most likely cause is that the listener isn't running, or that the database isn't registered with the listener. . This is a great example of how not to answer a technical question. A

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com3tag:blogger.com,1999:blog-6663543.post-1120034459504727232005-06-29T08:34:00.000Z2005-06-29T08:40:59.506Z

Developers may just have noticed that the JDeveloper IDE is now free of charge (support costs mind you). Anyway when I was playing around I noticed that os authentication does not work in the 10.1.0.3 developer preview - I assume it doesn't in any of the production versions either. It turns out that this is a bug in the oci jdbc driver shipped with the base install of Oracle 10g database (and

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com0tag:blogger.com,1999:blog-6663543.post-1119989781956588022005-06-28T20:13:00.000Z2005-06-28T20:16:21.960Z

from unattributable comments from todays UKOUG Oracle on Windows special event - more later - it would appear that 10gR2 will be available for download from June 30th. Don't expect windows then just the likely platforms *cough* linux *cough*.

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com0tag:blogger.com,1999:blog-6663543.post-1119938648151021222005-06-28T05:37:00.000Z2005-06-28T16:54:18.880Z

There's an interesting discussion over on Tom Kyte's blog about the software development process. It drew the following comment which I thought worth looking at a little more. RAD and iterative development methods have pretty much killed design skills as far as I can see. Not that there is anything wrong with these as concepts. As always the problem is their implementation. A large number of

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com8tag:blogger.com,1999:blog-6663543.post-1119443978788325222005-06-22T12:15:00.000Z2005-06-22T12:39:38.823Z

Techies hate marketeers. It's one of those timeless truths, like your project will be at least one of Late Overbudget Below expectations Only today has rather brought back to me that it needn't be like this. First I was rather nice about Oracle Corporation marketing in a discussion about RAC on large numbers of nodes over at Oracle-L. Then, whilst I'm waiting for data to come back off tape I

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com0tag:blogger.com,1999:blog-6663543.post-1119086541856617502005-06-18T09:13:00.000Z2005-06-18T09:22:21.863Z

It was pointed out to me that I, and Mark Bobak, are referred to here as noted Oracle Internals Experts, now whilst it is almost always nice to be called an expert, in this case the attribution of such a term to me is clearly misplaced. If you follow the original article you'll find that it was Mark who offered the nearest thing to Internals information - actually a clarification of terms, My

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com0tag:blogger.com,1999:blog-6663543.post-1118780963687615112005-06-14T20:16:00.000Z2005-06-14T20:29:23.693Z

I know, I know. I said little to no advocacy on these pages. This is a rule with very few exceptions. I am about to make 2. The second of these is Oracle related, but I'll be contacting a few folk at Oracle Corp first to make sure that I express myself fairly. The second is UK related, and thanks to Shrek for bringing the site to my attention. if, like me you regard the National ID Card proposals

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com4tag:blogger.com,1999:blog-6663543.post-1118436280104802342005-06-10T20:43:00.000Z2005-06-10T20:44:40.106Z

You restart the database server. The disks are no longer visible to the OS. Of such is deep joy made.

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com6tag:blogger.com,1999:blog-6663543.post-1118228266923691782005-06-08T10:49:00.000Z2005-06-08T10:57:46.926Z

A great line which I entirely agree with from Jeff Hunter's Top 11 Backup and Recovery list. Jeff is absolutely right, because (as Tom says in the comments) you just cannot be allowed to get recovery wrong, the amount you have to think when performing the recovery should be effectively zero. Got to do PITR because you accidentally dropped the wrong table or an end user deleted the wrong account.

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com3tag:blogger.com,1999:blog-6663543.post-1118225712106508442005-06-08T09:56:00.000Z2005-06-08T10:15:12.113Z

Yesterday was a good day up at the Scottish OUG in Edinburgh. Thanks to a little encouragement from Anjo Kolk we saw Mogens Norgaard in a kilt, not perhaps the best thing in the world to be greeted with at 9am. Doug Burns presented on Parallel Execution, you can read his paper here and if like me you have never really investigated parallel operations, (not really feasible with single-user scripts

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com2tag:blogger.com,1999:blog-6663543.post-1117538342327545042005-05-31T10:51:00.000Z2005-05-31T11:19:02.333Z

One of the things I have been working on recently is a simple script to extract schema creation ddl from various dev schemas that we have around the place, whose documentation is.. ,well perhaps light is the politest word. anyway that was the idea, first set some transforms to get rid of extraneous stuff (like the storage clauses), and to add in the sqlterminator to each statement, then loop

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com1tag:blogger.com,1999:blog-6663543.post-1117200969934044612005-05-27T13:25:00.000Z2005-05-27T13:36:09.940Z

There was a discussion over on the Dizwell Forum regarding ASM, which as discussions tend to do moved on to Oracle Managed Files and the fact that you don't need to specify file name or file size anymore. I felt that this didn't quite go far enough. C:\Documents and Settings\user>oradim -new -sid demoInstance created.C:\Documents and Settings\user>orapwd file=e:\oracle\10g\db\database\pwddemo.ora

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com1tag:blogger.com,1999:blog-6663543.post-1117138329386753082005-05-26T20:00:00.000Z2005-05-26T20:12:09.390Z

Ever read the contents of $ORACLE_HOME/rdbms/admin? Loads of good stuff in there. Right now I'm evaluating dbms_metadata - and sadly coming to the conclusion that you don't want to use it to dig out schema ddl. So I've logged at least one tar ORA-31608 when extracting grant information doesn't mean I errored out, it probably means no grant information to return. In the mean time Ive dug into

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com2tag:blogger.com,1999:blog-6663543.post-1117034901137578482005-05-25T15:23:00.000Z2005-05-25T15:28:21.143Z

I just noticed today that Sue Harper, who is the Designer product manager at Oracle corp has a designer/jdeveloper blog going here. It looks like this will be a prime site for developers and architects using Oracles development tools.

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com2tag:blogger.com,1999:blog-6663543.post-1116967042516084042005-05-24T20:25:00.000Z2005-05-24T20:37:22.520Z

Thanks to the surfer who visited here looking for a picture of Rachel Carmichael (yes, she's beautiful; no, I don't have pictures), I rediscovered her top 20 mistakes a dba can make on search Oracle(registration required). If you are interested I've only made 9 of them, I feel quite smug really. (Number 10 tomorrow I expect). Anyway mistake 19 reads Don't script anything, and don't save or

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com2tag:blogger.com,1999:blog-6663543.post-1116838142029339712005-05-23T08:22:00.000Z2005-05-23T08:49:04.606Z

If you are anything like me you generate a lot of sql scripts. Then when you come to reuse them you vaguely remember that you had a script that did this but can't remember what it was called or where it was located. In my case I wanted to find the wrapper for DBMS_METADATA to generate schema ddl that I wrote earlier last year. One of the enhancements that Windows XP Search brings is that it no

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com2tag:blogger.com,1999:blog-6663543.post-1116537195598541592005-05-19T21:08:00.000Z2005-05-19T21:13:15.603Z

Regular visitors will have noticed a colour change, from Orange which my friends over at the Dizwell forum universally hated, to blue on pale yellow (that's yellow Howard, not Pink :)). This change has met with, as the saying goes, a mixed reception. I still need to fix the right hand side bar, so any feedback on how horrific the site now looks - or alternatively how refreshing it is to see a dba

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com6tag:blogger.com,1999:blog-6663543.post-1116535716426807432005-05-19T20:02:00.000Z2005-05-19T20:48:36.473Z

A throwaway comment over at the rather excellent Dizwell Forum, let me to think that I'd be meaning to reflect on the vanishingly small number of female DBAs for a while. This is part, of course, of a wider problem of representation of women in IT, one that Governments are recognising. I've been fortunate to either work with, or know a few women who do work as DBAs or in IT generally, but if

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com7tag:blogger.com,1999:blog-6663543.post-1116361133578165132005-05-17T20:06:00.000Z2005-05-17T20:18:53.583Z

Tom Kyte posted an interesting discussion about Rules of Thumb (ROT). One of the lines in it that could have made my hackles rise a bit was It all depends. Think of some of the ROT you know about topics like gathering statistics, reorgs, access paths (there are people that will never use NOT IN, there are people conversely that will never use NOT EXISTS - because they had a 'bad experience' with

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com4tag:blogger.com,1999:blog-6663543.post-1116221166217508992005-05-16T05:10:00.000Z2005-05-16T11:46:33.916Z

Something that occasionally bugs me is the habit in our industry to want to throw out all the old rubbish and start over. This time we'll do it right. I think I first noticed this phenomenon in respect of our Intranet development, for a while there it seemed like it would get a new redesign about every 6-9 months. This usually meant a revamp of its appearance and moving everything around so no

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com2tag:blogger.com,1999:blog-6663543.post-1115325799264465782005-05-05T20:02:00.000Z2005-05-12T07:22:01.616Z

Its tempting to write about Mike Ault's myths paper that appeared in Search Oracle today (registration required), but I won't because others have covered much the same ground elsewhere. Instead I've been meaning for a while to go back to the scientist thing.Despite being a part of the OakTable Network, I don't regard what Oracle practitioners usually do as Science. Instead I regard it as

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com3tag:blogger.com,1999:blog-6663543.post-1115120763016500942005-05-03T11:30:00.000Z2005-05-03T11:46:03.016Z

Mark Rittman, whom I am now even more jealous of because he now gets sensible connectivity on his local train "service" whereas I get none at all and no prospect of any on First Great Western and pay a fortune for it, points out an article by way of /. which may well have the DBA's (or reactionaries as the article has it) spluttering over their keyboards. The article, which is a collaboration by

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com1tag:blogger.com,1999:blog-6663543.post-1114765214203070882005-04-29T08:21:00.000Z2005-04-29T09:00:14.203Z

Niall's corollary to my first law of disaster recovery from yesterday You never notice the disaster until 5 minutes after you can easily recover itIf you comment publicly on someone else's unfortunate error, you will make one yourself within 24 hoursSo I decided that I was going to rejig the file layout on my laptop, moving Oracle to a different dedicated volume, as its a laptop I just decided

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com1tag:blogger.com,1999:blog-6663543.post-1114609747191290452005-04-27T13:37:00.000Z2005-04-29T08:16:00.596Z

Two semi-related things to talk about this morning. The first is a new policy for Burleson Consulting. [blockquote]We are under no obligation whatsoever to provide reproducible evidence or test-cases to beginners and it is our readers trust in our judgment and real-world experience that counts. Resist the temptation to fall-in to the “prove it” trap.[/blockquote] I really don't know what to say

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com1tag:blogger.com,1999:blog-6663543.post-1114433985382431232005-04-25T12:41:00.000Z2005-04-25T12:59:45.383Z

I almost always find it interesting when real people write about real projects with which they are involved. It is one of the things that makes Tales of the Oak Table(ignore the first barking mad review) a must buy book (Dave Ensor's potted history of Oracle corp is the other). It can also be enlightening to discover how often accidents of fate, huge problems and smart people combine to add real

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com0tag:blogger.com,1999:blog-6663543.post-1113912629857992822005-04-19T12:00:00.000Z2005-04-19T12:10:29.856Z

Question. Whats the difference between a data warehouse and an OLTP system? Well there are a bunch of differences, but David Aldridge has an interesting take on tuning in his new blog He describes a tuning exercise that resulted in execution times that were massively improved. The only problem, the end-users didn't care. I think David has nailed part of the problem, the attention-span thing, but

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com3tag:blogger.com,1999:blog-6663543.post-1113904630344239392005-04-19T08:28:00.000Z2005-04-19T09:57:10.350Z

There are a number of articles scattered around the internet, for example here, here and here that suggest that DBAs should routinely set two optimizer parameters optimizer_index_caching and optimizer_index_cost_adj to values other than their default. There are rather fewer articles that describe what these parameters do, or note that setting them has an unpredictable (in practice rather than

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com0tag:blogger.com,1999:blog-6663543.post-1113337015661387302005-04-12T19:07:00.000Z2005-04-12T20:16:55.673Z

There have been a number of concurrent threads on a large number of different forums scattered around the net recently, all concerning the merits of taking an evidence based approach versus that of taking a holistic experienced practitioner's view to Oracle performance problems.I'm not going to comment too much in this entry on the subject, but I am considering a slightly longer article on what

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com3tag:blogger.com,1999:blog-6663543.post-1113330464543940002005-04-12T18:26:00.000Z2005-04-12T18:27:44.543Z

Very short one.When I logged on to blogger to post the next post, there was a short note there is a problem with the problem page that is being fixed.Don't you hate it when error handlers cause errors.Recursively.

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com0tag:blogger.com,1999:blog-6663543.post-1112781417078998442005-04-06T09:28:00.000Z2005-04-06T11:18:56.030Z

A recent discussion on the merits of investigating Oracle behaviour with single-user scripts, which I won't link to since it rather degenerated, rather than relying on the accumulated experience of experts led me to upload a script that I use for running an arbitrary number of concurrent sqlplus scripts, this can be an effective way of simulating load on a server.The script needs to be run from a

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com0tag:blogger.com,1999:blog-6663543.post-1112706597374311002005-04-05T13:06:00.000Z2005-04-05T13:09:57.376Z

Raymond Allo points out that there is a typo in my instructions for relinking Oracle for asynchronous io on Linux. This should read make -f ins_rdbms.mk async_on rather than asynch_on.

Niallhttp://www.blogger.com/profile/07109750882834293686noreply@blogger.com0