Re: OracleXE is garbage

Charles Hooper wrote:
> reqfoo wrote:
> > hpuxrac wrote:
> > > reqfoo wrote:
> > > > Once upon a time I used PostgreSQL and was happy. Then one day my
> > > > employer told me that we were all to use OracleXE while working on the
> > > > big new project. Since then I've come to hate Oracle.
> > >
> > > Maybe you should get a job that involves PostgreSQL then?
> > >
> > > You can become a member of the technology network for free and use (
> > > for development purposes subject to the licensing restrictions ) the
> > > regular enterprise edition packages if you so desire.
> > >
> > > If it's a "big new project" then it may grow outside the limits of
> > > OracleXE.
> > >
> > > >
> > > > Why is the installation so huge?
> > >
> > > Lots of integrated features and sample databases and code etc.
> > >
> > > >
> > > > Why does my computer crawl on startup if the DB is configured as a
> > > > service that automatically starts up?
> > >
> > > Maybe you don't have enough memory? Many of us would recommend
> > > ditching windows and using a different os.
> > >
> > > You may not need to start oracle at machine startup, you can change
> > > this setup as appropriate for your usage.
> > >
> > > >
> > > > Why does the web-based UI for the DB take a year to come up when I
> > > > haven't accessed it in awhile?
> > >
> > > Maybe your machine resources or disk IO configuration or operating
> > > system choice are involved?
> > >
> > > >
> > > > Why does the web-based UI give me an "invalid statement" error for its
> > > > own dynamically generated query?
> > >
> > > Give us a specific example please it's hard to provide help on such a
> > > general statement as yours above.
> > >
> > > >
> > > > I've also used several other Oracle products in the last couple years
> > > > and every single experience has contributed to the same verdict:
> > >
> > > Perhaps your mind was made up already before you started this project?
> > >
> > > Give yourself adequate resources to work in a productive manner is my
> > > recommendation.
> > >
> > > >
> > > > Oracle software might perform well in *very* specific situations, but
> > > > in general it is bloated garbage.
> > >
> > > The oracle learning curve does require a lot of time and effort and
> > > discipline to get to a good developing capable basis.
> > >
> > > If your projects involve creating generic database designs and then
> > > forcing them onto as many DBMS's as you can that's not a good model for
> > > being productive with oracle or other database systems.
> > >
> > > >
> > > > Thoughts?
> > >
> > > Tom Kyte has many books that you might consider learning from.
> > I appreciate your response, let me just say a few things as it seems
> > that people are very quick to assume that I am a complete newbie.
> >
> > In response to "Lots of integrated features and sample databases and
> > code etc.", this confirms my suspicion. Oracle just assumed I wanted a
> > bunch of stuff. Was there a prompt for this during the installation?
> > If so, I must have missed it. Does anyone know how to turn this stuff
> > off and if it will fix this issue?
> >
> > When I discovered Oracle XE was the cause of the sluggish performance
> > on startup I changed the service config to manual setup.
> >
> > About the web-based UI coming up slowly; I can open DBVisualizer and
> > start viewing the Oracle DB well before the web-based UI even loads.
> > This happens quite often when I haven't accessed the web-based UI in
> > awhile.
> >
> > About the annoying "invalid statement" error in the web-based UI; I
> > don't think this is very difficult to reproduce as I've seen it occur
> > on every machine XE is running on. Just use the table viewer for
> > awhile...it is sure to occur.
> >
>
> I wonder if some of this delay is caused by Oracle trying to recover
> from what was essentially a shutdown abort, if Oracle was not permitted
> sufficient time to issue a shutdown immediate during the previous
> system shut down. Recovery from a shutdown abort can take a while.

I have XE running on a W2K Pro, rarely use it, pound on the box all day with
x windows and the usual office apps. I've noticed when I do use XE, the startup
of anything, including sql*plus in a command box, is notoriously slow.

Since just about any other program such as Outlook or Excel does the same thing, I
think the finger should point at the OS. It may be as simple as an "optimization" to
keep memory available for programs that are actually being used. XE (and the EE I had
on more powerful boxes before it) just seems to be a bit worse than the others.

So I spend nearly all my time working on Oracle on unix boxes. The local PC is just a client
(or is that server for x?). It would be decent at that if it wasn't continually being assaulted by every script kiddie in spamworld and corporate monitoring programs.

>
> If the web based UI for XE is anything like the web based Enterprise
> Manager Database Control, I suspect that Oracle is trying to parse
> though the alert log to indicate the number of issues identified in the
> file, so that those issues may appear at the bottom of the web page.

I think it is just another aspect of being woken up after a nap.

>
> Just food for thought - why don't you use a utility like FileMon to see
> what files are being touched on your system when this sluggish
> performance is experienced. Post the filenames, and I bet that a dozen
> people on this group would be able to tell you exactly what is causing
> the sluggish performance.
>

Excellent suggestion. It's just such a trivial complaint...

jg

--
@home.com is bogus.
https://lfn.custhelp.com/cgi-bin/lfn.cfg/php/enduser/std_adp.php?p_faqid=2432&p_topview=1