Re: What is "SEGMENT_TYPE = CACHE"

From: Peter Sharman <psharman_at_us.oracle.com>
Date: Wed, 13 Jan 1999 21:24:42 -0800
Message-ID: <369D7F99.BA3FBF41@us.oracle.com>

Connore

The cache segment is Oracle's bootstrap segment. It's what we use to start the database. You'll see a segment name for it like 1.733 (file 1 - the system datafile, block offset 733). It's small (about 50K from memory) and you can't do anything with it, so just be aware its there.

Hope this helps.

Pete

Connor McDonald wrote:

> There is a segment with segment_type = 'CACHE' in dba_segments...
>
> Could someone explain what this is ?
>
> --
> ==============================================
> Connor McDonald
> BHP Information Technology
> Perth, Western Australia
> "The difference between me and a madman is that I am not mad"
> - Salvador Dali

Regards

Pete

Peter Sharman                              Email: psharman_at_us.oracle.com

WISE Course Development Manager            Phone: +1.650.607.0109
(int'l)
Worldwide Internal Services Education               (650)607 0109

(local)
San Francisco

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Wed Jan 13 1999 - 23:24:42 CST