Re: OracleXE is garbage

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.

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.
Received on Tue Nov 28 2006 - 13:01:32 CST