Where can one find some information about Oracle's market share in the
various O/S markets. Like, UNIX,LINUX,NT etc.
Regards
Murali Vallath
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see
Cached
Quick IO gives you pre-fetch capabilities similar to EMC devices, of course, not
nearly as good, but it certainly does help on reads.
If you
have Veritas license, Quick IO is great. But raw is certainly still the
most effective. But Veritas gives you 95% of the advantages of Raw and
That would certainly work, although the time your typing, the datafile may
have changed, and thus your aborting older transactions. That is if vi can
even open the file as it has file open limits.
Walking on water and developing software from a specification are easy if
both are frozen.
Title: Crash Recovery
Hi All,
I have an interesting problem, on one of my databases, a data warehouse, a killed session was taking too long
to rollback. It was time for the backup, and I had to do a shutdown abort.
No its time to open the database, instance parallel recovery is taking place
It's always a good idea to include your platform, OS version
and most importantly, your Oracle version.
Since it's a DW, I'm guessing that the session in question
was doing parallel DML, and it's an older version of Oracle,
which does not have parallel rollback capability. ( forget
which
Naik, Kevin K wrote:
Hi All,
I have an interesting problem, on one of my databases, a data
warehouse, a killed session was taking too long
to rollback. It was time for the backup, and I had to do a shutdown
abort.
No its time to open the database, instance parallel recovery is taking
Naik, Kevin K wrote:
Hi All,
I have an interesting problem, on one of my databases, a data
warehouse, a killed session was taking too long
to rollback. It was time for the backup, and I had to do a shutdown
abort.
No its time to open the database, instance parallel recovery is taking
Title: RE: Crash Recovery
oops, forgot that,
Sun Solaris 5.6, its an E6000, 16 cpu box, running dbms 7.3.4.5.0
the online redo logs are 500 megs in size
the transaction used -+ 4 million records
-Original Message-
From: Paul Drake [mailto:[EMAIL PROTECTED]]
Sent: 10 June, 2001 21:10
Title: RE: Veritas Quick I/0 and Oracle/ Asycnchronous I/O
I
could not get this URL to work, are you sure it is "platypus.com".
I tried www.platypus.comand
it came up with some other non-related site. I would be greatly interested
in reading about this device.
"Walking on water and
Static data raid 5 is a very good option, it has great read performance and
very inexpensive.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Friday, June 08, 2001 6:20 PM
http://www.platypustechnology.com/default2.asp
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Drake
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Hi,
Oracle was doing full recovery in older version during crash recovery
( I guess pre
7.3, but I'm not sure). But now, Oracle does not do full database recovery
during
crash recovery. Some un-recovered blocks are recovered when a user
tries to use
them later. So, if your online log files are
AWESOME looking website
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Sunday, June 10, 2001 4:34 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Christopher Spence wrote:
AWESOME looking website
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
From: Paul Drake [mailto:[EMAIL PROTECTED]]
Sent: Sunday, June 10,
I've had something like this happen to me.
My solution was to make TEMP larger;
after enduring the LONG wait for recovery
to complete.
"Naik, Kevin K" wrote:
Hi All,
I have an interesting problem, on one of my databases,
a data warehouse, a killed session was taking too long
to rollback. It was
Since RAID5 means that data is striped, of course read performance is OK. As
soon as you talk write performance, however, RAID5 becomes something of a joke
since it was invented back in the 70's to offer a cheap alternative to the fast,
extremely expensive disks offered by IBM back then. So the
1 for PCI NVRAM for swap and online redo
I totally buy into using this sort of technology for online redo, but using it for swap just seems silly. You shouldn't be swapping anyway, and if you are it's much cheaper to buy ram than to buy a solid-state disk.
64 bit slots allow for (max) 350
George Schlossnagle wrote:
1 for PCI NVRAM for swap and online redo
I totally buy into using this sort of technology for online redo,
but using it for swap just seems silly. You shouldn't be swapping anyway,
and if you are it's much cheaper to buy ram than to buy a solid-state
Hmmm so it's a pci only interface, so I can't use it with my
Enterprise Sun systems, and drivers for Tru64 don't yet exist, so unless
you're running Windoze, AIX or Linux, you're out of luck. That's a real
bummer.
Anyone use Imperial's solid state disks? I played with them at a
clients
Kevin,
First off, I cc'd the list on this. When posting a
question to the list, it's a good idea to include the
list in any replies, as there's a lot of good folks
there. The respondent ( me in this case :) may not
have good information.
For instance, I don't have access to any 7.3 docs.
I
George,
Agreed about it being silly for swap on a *nix box, but if you're
running on a brain-dead OS that is going to page stuff out
uncontrollably (NT/W2K) even with lots of available memory - its still a
good idea to give the OS some pagefile space on NVRAM.
Ahh My lack of knowledge of
Rachel,
there is that small issue of not having a solaris box
- and 9i for wintel or Linux won't be out for awhile ...
didn't see anything I liked on Ebay in Sun hardware, either.
Paul
Rachel Carmichael wrote:
Paul,
the export worked... now import it into a different schema, if all
On Sunday 10 June 2001 16:15, Mogens Nørgaard wrote:
It becomes really absurd when you look at the SAN offerings on the market.
For instance, IBM's Shark only offers the customer the choice between JBOD
(Just a Bunch Of Disks, ie., Non-RAID) and RAID5. IBM has a red book out
regarding this
The reply below was a great post! As were replies prior to it. But, none of
the replies were for the original question.
The issue in hand is not which raid level to use or whether to use at all.
The question is, and I promise this is the very last time I post it: given 9
hard drives dedicated
On Sunday 10 June 2001 20:15, Gary Weber wrote:
The question is, and I promise this is the very last time I post it: given
9 hard drives dedicated for RAID5, should data reside on 6 drives via
volume group A and indexes on the other 3 drives via volume group B, or
should data and indexes be
On Sunday 10 June 2001 14:35, Paul Drake wrote:
http://www.platypustechnology.com/default2.asp
Interesting product. This would be great for redo logs.
I can't help picking at one of their 'success' stories however.
This is from their website:
This customer
Gary,
Here is where we have to know more details.
a 9 drive array on a single channel sounds like your peak I/O rate for
reads would be throttled by the controller channel speed. Now, if the
SCSI interface is ultra 160/m, and the drive support a sustained rate of
20 MB/sec - you're not pinched.
Thanks to all who replied.
following is what I have gathered after some rd:
- locks
Oracle generates internal locks on dict tables to maintain the data
integrity.
e.g.: I deleted a record from detail table in one session. In another
session I tried to delete a master record not related to the
Thanks to all who replied.
following is what I have gathered after some rd:
- locks
Oracle generates internal locks on dict tables to maintain the data
integrity.
e.g.: I deleted a record from detail table in one session. In another
session I tried to delete a master record not related to the
Hi,
I need some info regarding if there are any limitations in using index
organised tables compared to normal tables. Moreover, what is the deciding
factor to be considered to give preference to an index organised table over
a normal table.
on oracle 8.1.7
rgds
amar
--
Please see the
Hi,
I need some info regarding if there are any limitations in using index
organised tables compared to normal tables. Moreover, what is the deciding
factor to be considered to give preference to an index organised table over
a normal table.
on oracle 8.1.7
rgds
amar
--
Please see the
just visit www.oracle.com the official web site of Oracle Corp.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, June 10, 2001 8:45 PM
Where can one find some information about Oracle's market share in the
various O/S markets. Like,
hi rachel,
i recreated them in rbs tablespace, created all right. i created them as
public segments. i tried to give them private. but create private rollback
segment rbs1... failed.
how i could create them private.
after creating them as public, some are still shown as offline. when i tried
to
On Sunday 10 June 2001 21:50, Amar Kumar Padhi wrote:
- locks
Oracle generates internal locks on dict tables to maintain the data
integrity.
e.g.: I deleted a record from detail table in one session. In another
session I tried to delete a master record not related to the deleted detail
hi all,
has anybody using iSqlPlus tool,
provided by oracle.
what i know is , it's the internat
enabled extension of sql * plus, utilising the 3-tier architecture.
they say oracle 8.1.7 is required
for the implementation.
any suggestions.
saurabh
35 matches
Mail list logo