Re: memory usage, 2 javas, 2 apaches?

"Howard J. Rogers" wrote:
> "Amy Hughes" wrote in message:
> > Wrox "Beginning Oracle Programming" book
>
> An *excellent* choice, Amy !! ;-)

Hi, Howard. Good to see you here. I'm working my way through your book now. If you're curious, I chose it because it starts at the beginning and assumes little beyond knowledge of RDB concepts and SQL, and on past good experience with Wrox titles. And if you'll take suggestions I might mention that installation, though it boiled down to a few simple selections, required decision making about tools I wasn't familiar with. A chapter describing the components to be installed, the licensing issues and what to expect to find running on my machine after installation would be helpful. I found some of what I was looking for in the installation manual, though.

> Shame about the Personal Oracle decision, though...some key bits and
> pieces are missing from Personal which would be in Enterprise Edition.
> I always advise learning with Enterprise Edition...it's entirely free...

I was so pleased to find the one-user licenses so affordable that I didn't pursue the free version. For some reason I thought it was a 30-day trial. Probably getting it crossed with AutoCAD. If I need the extra pieces I guess I can get the enterprise edition. Thanks.

> No...adding more memory won't cause those settings to be dynamically
> adjusted.

This being the case, I'm willing to throw a stick of memory at it.

> You can trim shared_pool down to 32M relatively comfortably, and for
> testing/learning, a db_cache_size of 8M is OK.
> Other things ...

Using your suggestions I was able to free up enough memory to run my normal development environment *and* oracle. Thank you!

> > Also, my hard disk is accessed about once per second. This is a new
> > behavior since installing Oracle. What's it doing?
>
> Probably incremental checkpointing.

Having read TFM I was referred to it's still not clear why checkpointing a database that isn't being updated would require constant disk access, but having replaced the noisy drive this is less an issue. Guess I can learn about this later.

> Right now you are asking Oracle to ensure you never take longer than
> 300 seconds to recover your instance, so it checkpoints as often as
> necessary to achieve that

I don't think I have any such requirement, so perhaps when I get that far in the learning I can relax this constraint. Thanks for the tip.

Thank you,
Amy Received on Mon May 19 2003 - 07:47:02 CDT