Re: Crash course for an Oracle DBA

On Wed, March 7, 2007 15:11, Obnoxio The Clown said: > [...] > > Correct terminology. > > You can look at the issue of storage from different perspectives. As > far > as the database server is concerned, you can have "dbspaces", in which > you > can place tables. A dbspace consists of at least one "chunk", of > preferably raw disk. As the table(s) in the dbspace grow, you run out > of > space and hence need to add another chunk of raw disk to the dbspace. > > As far as tables within dbspace are concerned: space gets added in > "extents". When you create a table, you can specify the dbspace in > which > it gets created, and the size of both the initial extent and any > subsequent (or "next") extents. If a table starts getting too many > extents, the server will start doubling the next extent size. > > An "instance" of IDS is a collection of shared memory segments, > dbspaces > and processes that connect the two. An instance can contain multiple > "databases" (roughly equivalent to an Oracle schema, I believe.) > Tables > exist within databases and you connect to a_database@a_server. Remote > joins and queries are possible, either across databases in an instance > or > across instances. > > Does that answer everything, or was there something you still needed > to know? That's a fantastic start. Many thanks for that, an excellent treatise, succintly put. As to a free lunch, you are most welcome to share mine (mushroom soup, chili sauce flavoured and bread) anytime. You live anywhere near Stevenage UK? -- Tony

On 7 Mar, 15:34, "S. Anthony Sequeira" <t...@sequeira.org.uk> wrote: > > That's a fantastic start. Many thanks for that, an excellent > treatise, succintly put. As to a free lunch, you are most welcome to > share mine (mushroom soup, chili sauce flavoured and bread) anytime. > You live anywhere near Stevenage UK? > -- I live next to Canary Wharf but would visit and share knowledge for soup!

On Wed, 2007-03-07 at 15:25 -0800, david@smooth1.co.uk wrote: > On 7 Mar, 15:34, "S. Anthony Sequeira" <t...@sequeira.org.uk> wrote: > > > > That's a fantastic start. Many thanks for that, an excellent > > treatise, succintly put. As to a free lunch, you are most welcome to > > share mine (mushroom soup, chili sauce flavoured and bread) anytime. > > You live anywhere near Stevenage UK? > > -- > > I live next to Canary Wharf but would visit and share knowledge for > soup! Jeepers, things must be tough in the Informix world! All the way to Stevenage for some Tesco's mushroom soup! :) -- S. Anthony Sequeira ++ Let thy maid servant be faithful, strong, and homely. -- Benjamin Franklin ++

Tony Sequeira wrote: > On Wed, 2007-03-07 at 15:25 -0800, david@smooth1.co.uk wrote: >> On 7 Mar, 15:34, "S. Anthony Sequeira" <t...@sequeira.org.uk> wrote: >>> That's a fantastic start. Many thanks for that, an excellent >>> treatise, succintly put. As to a free lunch, you are most welcome to >>> share mine (mushroom soup, chili sauce flavoured and bread) anytime. >>> You live anywhere near Stevenage UK? >>> -- >> I live next to Canary Wharf but would visit and share knowledge for >> soup! > > Jeepers, things must be tough in the Informix world! All the way to > Stevenage for some Tesco's mushroom soup! :) S. Anthony Sequeira ++ Let thy maid servant be faithful, strong, and homely. -- Benjamin Franklin ++ Benjamin Franklin was quite the slut I hear. He liked to party. :-)