Re: DataGuard vs Hardware mirroring for DR
From: jgar the jorrible <joel-garry_at_home.com>
Date: Fri, 20 Feb 2009 14:35:44 -0800 (PST)
Message-ID: <b22a0a3f-2cc7-4a50-9471-1a48bd632cb1_at_j1g2000yqi.googlegroups.com>
On Feb 19, 10:00 pm, Noons <wizofo..._at_gmail.com> wrote:
> On Feb 20, 5:52 am, joel garry <joel-ga..._at_home.com> wrote:
>
>
>
> > Grabbed by this quote from May, 2005 by Hrishy from Pa: "Just a
> > thought with the 10g ASM and RMAN plus the flash back redo.I think
> > oracle is trying to enter the arena of storage .This is increasingly
> > observable when you use flash back database technology :-).Just a
> > matter of time i think when oracle would be there."
>
> > Wow, talk about hitting the nail on the exadata.
>
> http://dbasrus.blogspot.com/2007_01_01_archive.html
> look for the "no moore" series.
> I did explain the exadata "push the sql to the disk subsystem"
> principle of operation.
> And IO speed of GB/s still is not enough for the HB-class db:
> we need a lot more than that - or disks that can do the query
> themselves!
> ;)
Date: Fri, 20 Feb 2009 14:35:44 -0800 (PST)
Message-ID: <b22a0a3f-2cc7-4a50-9471-1a48bd632cb1_at_j1g2000yqi.googlegroups.com>
On Feb 19, 10:00 pm, Noons <wizofo..._at_gmail.com> wrote:
> On Feb 20, 5:52 am, joel garry <joel-ga..._at_home.com> wrote:
>
>
>
> > Grabbed by this quote from May, 2005 by Hrishy from Pa: "Just a
> > thought with the 10g ASM and RMAN plus the flash back redo.I think
> > oracle is trying to enter the arena of storage .This is increasingly
> > observable when you use flash back database technology :-).Just a
> > matter of time i think when oracle would be there."
>
> > Wow, talk about hitting the nail on the exadata.
>
> http://dbasrus.blogspot.com/2007_01_01_archive.html
> look for the "no moore" series.
> I did explain the exadata "push the sql to the disk subsystem"
> principle of operation.
> And IO speed of GB/s still is not enough for the HB-class db:
> we need a lot more than that - or disks that can do the query
> themselves!
> ;)
"Then, make it so that Oracle or db2 or SQL Server can download a simplified meta-SQL interpreter - the output of the optimizer - into each of these very large capacity disks...among all the storage units it knows about. And automatically have a local index on that aggregation key stored in meta-data somewhere else..."
Yes, that is spot on! I sure didn't think at the time it would be out in the wild as a mainline product this quickly.
Now back to figuring out how to deal with a metadata change in the app upgrade that borked a DSS inquiry the VP of manufacturing uses...
jg
-- _at_home.com is bogus. Yet Another MySQL Loss: http://www.datacenterknowledge.com/archives/2009/02/19/magnolia-data-is-gone-for-good/Received on Fri Feb 20 2009 - 16:35:44 CST