| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.tools -> Re: Is Oracle deliberately difficult?
Based on my 3 years experience with a mainframe database (Unisys DMSII) and my 1 year self-taught and part time experience with Oracle, I can give a few specific examples of things about Oracle that I am finding difficult. Perhaps they are second nature to more experienced, or more formally trained, Oracle people, but here they are:
I don't know if it's an ANSI standard, or just the way things developed, that when you do a SELECT it is supposed to be consistent with the state of the database when the query started, but I don't think it makes the best sense. Say you're going to look through your whole customer list for everyone who has a bill over 90 days due and send them a nasty letter. You start the select, then someone in bookkeeping posts a payment on an account. However, your select doesn't see that. I KNOW that it could have happened that the statement was past that account by chance anyway, but if it WASN'T, then why is the Oracle way the best way?
2) Space management
Oracle makes you do too much work with worrying about extents, block
sizes, etc. You can justify some of it by saying you can tweak your
performance, but not for what the effort seems to be.
3) Process management
It seems to be someone of a chore to deal with who is locking the
database, what is running at what priority, batch vs. online
transactions at the same time, etc.
I know there are solutions to these, but they are some of the big ones that I have dealt with.
On Mon, 28 Aug 2000 22:16:25 +0100, Sid_James <sid.james_at_virgin.net> wrote:
>I've been learning Oracle for a while now and I do think of it as quite
>challenging in an enjoyable way. I don't use Enterprise Manager, I'd
>rather get to to know the 'nuts and bolts'. However, having done a SQL
>Server administrator's course, I can't help thinking that Oracle is
>rather more difficult to use than maybe it should be.
>
>Sensible, rational responses that shoot me up in flames are always
>preferable!
>
>e d
 |
 |