Dave,
Benchmarking is very difficult with replication as
it's very dependent on the data involved and since
every db is different it makes it very hard to compare
apples to apples. Tx propagation rates are pretty
useless as all tx's are not equal. Is the data
involved in a tx that adds a new
Jared Still wrote:
Many things that are easier on unix with Perl are simply
not possible on Windoze without Perl. ( unless you want
to program in C or VB. Ugh on both counts )
Ask me how I know. ;)
Jared
well always being one to raise to a challenge:
how do you know?;-)
--
Bill
Larry,
Sounds like a marketing ploy.
It would have to be some book to improve
on Guy Harrisons efforts.
Jared
On Saturday 04 August 2001 06:55, Larry Elkins wrote:
Listers,
I went to the Oracle Press section of Osborne
(http://www.osborne.com/oracle/index.html). Prominently displayed is
Rachel Carmichael wrote:
oh, my library is relatively small -- when you add in all technical,
fiction, science fiction, mystery, craft books, throw in the knitting
magazines I still only have about 7 bookcases.
only 7?;-) sadly my collection was ... um... dispatched by a
vindictive
Srinivas:
What you're looking to do is find the value of physical reads/db block gets.
So, you want the value1/value2 where value1 is 'physical reads' and value2
is 'db block gets'. So, what you need to do is put the literals 'physical
reads' and 'db block gets' in the where clause somehow
Srinivas,
You nearly had it. You just need to wrap each decode with a SUM (the same
technique used to rotate a table except you are doing division instead of
displaying each column):
select
sum(decode(name,'physical reads',value)) /
sum(decode(name,'db block gets',value))
from
v$sysstat
well always being one to raise to a challenge:
Cuz I find myself working on a number of databases
than run on: you guessed it, windoze.
Simple stuff like checking the amount of space available
on a filesystem and sending mail to the DBA's cell phone
if it reaches a critical stage for some
Hi Friends,
When Iam rebuilding my index and clearing TEMP tablespace frequently..that
time I got this error..Any suggestions??
ORA-00600: internal error code, arguments: [510], [1073758876], [sort extent
poo
l], [], [], [], [], []
Thanks
Raghu.
Get this book : Mastering Windows NT Server 4 (7th Edition) by Mark Minasi.
Everything you ever wanted to know about NT. It's all in there.
There are many other books on NT, but I have the 5th edition of this book.
Regards,
- Kirti Deshpande
Verizon Information Services
Raghu:
What I have found suggests that you are having latch contention on the SORT
EXTENT POOL.
The 510 indicates that a call was made to free a latch that is unowned.
The second parameter is the address for that latch. The third argument is
the type of child latch that the kernel was trying to
7 of books that I want to keep. I won't even attempt to count the number of
books that I have bought, read and given away. And then there are those that
I take out of the library
I go to bookstores with a pad and pen... and write down the names of books I
want to read, but not to own (or
Thankyou very jon.
From: Jon Walthour [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: ora-600 ..sort extent pool??
Date: Sat, 04 Aug 2001 14:40:18 -0800
Raghu:
What I have found suggests that you are having latch
Thankyou very much jon.
From: Jon Walthour [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: ora-600 ..sort extent pool??
Date: Sat, 04 Aug 2001 14:40:18 -0800
Raghu:
What I have found suggests that you are having latch
--- A. Bardeen [EMAIL PROTECTED] wrote:
Brijesh,
Even though OPTIMIZER_MODE=RULE, the CBO will be
used
in the presence of other features (e.g.
partitioning,
degree of parallelism, etc...).
In this case TEST is getting a better plan because
the
CBO is being used. You can tell this
Brijesh,
Another thing to check is if the tables involved have
been analyzed on prod database.
Sukumar Kurup
__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
Please see the
call support
joe
Raghu Kota wrote:
Hi Friends,
When Iam rebuilding my index and clearing TEMP tablespace frequently..that
time I got this error..Any suggestions??
ORA-00600: internal error code, arguments: [510], [1073758876], [sort extent
poo
l], [], [], [], [], []
Thanks
Raghu.
Oracle High-Performance SQL Tuning
by Donald Burleson. Anyone have
any comments on the book
It won't be published until the end of this month.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
INET: [EMAIL PROTECTED]
Fat City Network Services--
I don't know if any of these guys played in the same movie or not, but I can
guarantee you they all are within six degrees of Kevin Bacon...
http://www.cs.virginia.edu/oracle/
i.e.:
The Oracle says: Red Skelton has a Bacon number of 2.
Red Skelton was in Fuller Brush Girl, The (1950) with
can anybody tell me
how to kill the background processes (SNP) that are currently
running/sleep mode.
alter system kill session is not working.
saying user session id does not exist.
srinvas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tatireddy, Shrinivas
Friend :
I think you can use it :
CREATE OR REPLACE PACKAGE cv_types AS
TYPE DeptCurTyp is REF CURSOR RETURN dept%ROWTYPE;
END cv_types;
CREATE OR REPLACE PROCEDURE dept_rpt
(dept_cv IN OUT cv_types.DeptCurTyp) AS
BEGIN
OPEN dept_cv FOR SELECT * FROM DEPT;
END;
VARIABLE odcv
I watched a lot of those shows as a kid, what about the Thunderbirds, back
on free to air TV here in the mornings or what about the Banana Splits. My
old boss and I used to talk about them and my wife just looks at us
strange, ten years is a long time it seems.
Peter
At 07:50 PM 4/08/2001,
Listers,
I went to the Oracle Press section of Osborne
(http://www.osborne.com/oracle/index.html). Prominently displayed is the
book Oracle High-Performance SQL Tuning by Donald Burleson. Anyone have
any comments on the book? I have recommended Guy Harrison's Oracle SQL
High-Performance Tuning
Rachel Carmichael wrote:
you are mixing up two of my favorite authors :)
e.e. cummings (never used uppercase)... was a poet. He wrote my most
favorite poem... somewhere i have never travelled
bill shrek thater doesn't use capitals either, too many years of
writing c code.;-) but yup, i
ron - now that is a large area from orlando to jacksonville. having worked in s. fla
last 3 yrs, the rumor is jacksonville pays well for florida, similar to the n.e.
there appear to be more sa positions than dba. good luck and if i hear of anything, i
will let u know!
[EMAIL PROTECTED]
hr puffnstuff
joe
Peter McLarty wrote:
I watched a lot of those shows as a kid, what about the Thunderbirds, back
on free to air TV here in the mornings or what about the Banana Splits. My
old boss and I used to talk about them and my wife just looks at us
strange, ten years is a long time
Hi guru's,
Can anybody tell me where can i get detail information about windows NT
Registry.(ie how information is stored in registry,how one can modify that
etc.)
Thanx in advance
Regards,
Anand.
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, August 02, 2001 7:00 AM
To: Multiple
hi lists
can anybody help me for the flwng :
i need to do calculation dividing phy reads value/db block gets
i am following the principle
select decode(name,'physical reads',value)/decode(name,'db block
gets',value)
from v$sysstat
where name in ('db block gets','physical reads')
just this
Okay..
In this case waht you can do is , you can randomly
dump few redo logs (few blocks) and SEE what actually
is in those files. Without checking those file dumps
it is bit difficult to tell it is excessive or not.
And to avoid the redo generation. during the batch
loads you can use direct
read windows docs, this is not a windoze forum(god forbid for us unix
bigots), now if you asked how to what do i need to edit in the registry
for oracle products, that would be a differen story.
joe
Anand wrote:
Hi guru's,
Can anybody tell me where can i get detail information about windows
Shrinivas,
It sounds like the SNP session you're trying to kill
is rolling back. If the serial# in V$SESSION is
changing, then the session is rolling back.
Keep in mind that when you kill an SNP process, unless
you've broken the job first, as soon as it's finished
rolling back the job will
it's not all that odd that they are named similarly. There is a limit to the
number of combinations of words you can have that express the contents of a
book. Heck, there is someone out there who self-published a book called
Oracle DBA 101 -- at the exact same time our book came out. I KNOW we
oh, my library is relatively small -- when you add in all technical,
fiction, science fiction, mystery, craft books, throw in the knitting
magazines I still only have about 7 bookcases.
I keep only books I have loved and want to re-read. Others I either pass on
to other people, donate to the
On Wednesday 01 August 2001 18:30, [EMAIL PROTECTED] wrote:
And if you have written a .bat file since the late '80s, brush up on your
DOS commands.
Forget many of the DOS commands; Learn Perl.
Learn to use the Win32, Win32::AdminMisc and Win32::Daemon
Perl modules.
Many things that are
Srinivas,
That's because the values are in 2 different rows.
Notice that your query returns 2 rows. One row
will have the 'db block gets', the other will have
the 'physical reads'.
This will do it:
select a.value/b.value
from v$sysstat a, v$sysstat b
where a.name = 'physical reads'
and
34 matches
Mail list logo