Title: Message
I
would create a new version of the procedure that took the date from and to as
parameters and output a file named appropriately for the date range. You would
then just call this 24 times.
Niall
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL
Tanel,
Oracle 9-2 SQL Ref manual. Lob storage clause.
The options for lobs on creation are:
CACHE
NO CACHE
CACHE READS
I don't think the last one appeared until 9.2
I was wrong about caching only writes, though -
one of the joys of trying to quote everything from
memory.
The CACHE
It's just one example of my general suggestion that messing about
with block sizes rarely has any direct performance benefit. But
if you can put something out of the way where it can't do so much
damage then the performance of everything else might benefit.
Regards
Jonathan Lewis
Hi Jonathan,
I don't think the last one appeared until 9.2
I was wrong about caching only writes, though -
one of the joys of trying to quote everything from
memory.
Thank you for this note, I had somehow missed this important improvement.
The CACHE READS option means that the
LOB goes
?
From: Jonathan Lewis [EMAIL PROTECTED]
Date: 2004/01/30 Fri AM 04:09:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: [Q] wait time /lob def
Tanel,
Oracle 9-2 SQL Ref manual. Lob storage clause.
The options for lobs on creation are:
CACHE
NO CACHE
: Jonathan Lewis [EMAIL PROTECTED]
Date: 2004/01/30 Fri AM 04:09:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: [Q] wait time /lob def
Tanel,
Oracle 9-2 SQL Ref manual. Lob storage clause.
The options for lobs on creation are:
CACHE
NO CACHE
Friday, January 30, 2004, 2:24:25 AM, Jesper Haure Norrevang ([EMAIL PROTECTED]) wrote:
JHN Certainly som conversion is going on here. This might be the reason why
JHN there has been confusion about 7 or 8 bytes in a DATE datatype.
That's really interesting, that switch between 7 and 8
bytes.
Go to the SERVICES and start the service.
Dharminder
:
[EMAIL PROTECTED]Subject: Re: SV: Date Format: Mystery
.com
On 01/30/2004 09:29:26 AM, [EMAIL PROTECTED] wrote:
Hallo,
I would like to write the code to atrigger that makes insert into
another table inly if there is the condition
Oracle9i Application Developer's Guide - Fundamentals, Ch. 15. - Using
Triggers. There are examples there, too.
--
Please see
Thomas,
That is the real problem. I can start the database using Windows 2000
OracleServiceSID.
But I want to start up the database using OEM only.
Thanks.
-Original Message-
Thomas Day
Sent: Friday, January 30, 2004 9:19 AM
To: Multiple recipients of list ORACLE-L
start a
Go to the
Dharminder,
Changes the service to AutoStart when the machine reboots. As Thomas said,
the NT service has to be running for you to be able to start the database.
The service will stay running even if you shut the database down. Think of
the service as a backgrouond placeholder for the database.
Jared Still scribbled on the wall in glitter crayon:
A repost of a previous message.
This is the last day for this address folks.
good-bye fatcity my old friend, won't get to talk to you again...
--
Bill Shrek Thater ORACLE DBA
I'm going to work my ticket if I can... -- Gilwell
last post(its kinda like first post on slashdot.org)
joe
Thater, William wrote:
Jared Still scribbled on the wall in glitter crayon:
A repost of a previous message.
This is the last day for this address folks.
good-bye fatcity my old friend, won't get to talk to you again...
--
Bill
So, is anyone posting on the new list? I believe that I'm subscribed there
but I'm only getting fatcity posts.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Thomas Day
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
Jared, I think you should ask the maintainers of orafaq.com to update their
information about oracle-l as well, it's the first hit in google when you
search for oracle-l.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, January 30,
Title: Message
Keith,
To my
knowledge, RBO has not changed. That includes NOT dealing w/ IOT.
So, I think if you execute a query that references an IOT, you'll implicitly
invoke the CBO. That would explain why the plan is changing. So, did
you change a table from heap to IOT when you moved
Thanks Tanel, Frank is on top of it already.
Jared
Tanel Poder [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/30/2004 08:24 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: [Fwd: ! READ THIS - [EMAIL
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Starting Database from OEM 9.2 gives ORA-12500 Failed to star
Dharminder,
Changes the service to AutoStart when the machine reboots. As Thomas said,
the NT service has to be running for you
There is not enough memory to start a dedicated connection. sochange the server mode from dedicated to shared, (you can do it change some parameters in init_sid.ora file see oracle documentation).
If you are going to change the server mode to shared and you have two databaseon the same machine,
Logic
says one thing, experience says another. Question one, are the tables
analyzed? If so, since RBO is deprecated in 9i even setting
OPTIMIZER_MODE=RULE will invoke the CBO.
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Keith Moore
On 01/30/2004 01:24:26 PM, A Joshi wrote:
Hi,
In view v$log there is a column status. This changes from current
(if the redo log is in use) to atcive then to inactive. Documentation
says :
ACTIVE: The log is active but is not the current log. It is needed
for
crash recovery. It may be in use
, 2004 12:39 PMTo: Multiple
recipients of list ORACLE-LSubject: Re: Starting Database from OEM
9.2 gives ORA-12500 Failed to start a dedicated
There is not enough memory to start a dedicated connection.
sochange the server mode from dedicated to shared, (you can do it change
some
Tom,
As stated earlier, here the intention is to startup the database using OEM
only and without using windows service. As for as I understand if the
OracleServiceSID is properly setup and if startmode for the service is set
to automatic then it will startup the database automatically once you
Subject: RE: Starting Database from OEM
9.2 gives ORA-12500 Failed to star
Sent by:
ml-errors
There is a pretty good explanation in this usenet thread:
Well, you can't. Windows is different from other systems in that you have
these services that have to be running in the background. Once the
services are running, you can use OEM to shutdown and startup the database.
But the service has to be running first.
Sorry.
Have you looked at OEM Jobs?
Dharminder,
OracleServiceSID starts the database automatically, because by default
the registry key ORA_SID_AUTOSTART IN
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 is set to TRUE.
If you don't want your OracleServiceSID to start the database
automatically, change the value to FALSE.
This way
Mladen,
Thanks for info. So all the dirty blocks need to be written to disk after eachcheckpoint. After that is donethe status becomes 'INACTIVE'. Just that sometimes this is very unpredictable.
My question : Ifa log switch always causes a implicit checkpoint then what is the need for this
-Original Message-
Igor Neyman
OracleServiceSID starts the database automatically, because by default
the registry key ORA_SID_AUTOSTART IN
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 is set to TRUE.
If you don't want your OracleServiceSID to start the database
automatically, change
David Hau explained this much better and in much more clear
fashion then me. Here is the most important part from the usenet
thread he was referring you to:
**
This makes sense if you think about where the various v$ dynamic
Igor,
What you have mentioned is right i.e. if I set ORA_SID_AUTOSTART to
FALSE for the database in question and set OraceServiceSID startmode to
Automatic then as windows starts it starts the OracleSID service (or I
should say background services needed for the database to run and I believe
I
Yes, I'm sure.
If in the services control panel you change OracleServiceSID starup
properties, it does not affect ORA_SID_AUTOSTART key in
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 (and does not change the way
the database is started when the service is started).
What it does, it changes the
Thanks Mladen and David
It is great to get such detailed info.
If we take your example of three redo logs then you could have a situation where one is is 'CURRENT' status and two are in 'ACTIVE' status. As follows :
GROUP# STATUS-- 1 ACTIVE2 CURRENT3 ACTIVE
Now if group
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
last post
[EMAIL PROTECTED] wrote:
|
| bye...
- --
Joseph S Testa
Chief Technology Officer
Data Management Consulting
614-791-9000
It's all about the CACHE
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.1 (GNU/Linux)
Comment: Using GnuPG with
NOO!!
-Original Message-
Sent: Friday, January 30, 2004 7:44 PM
To: Multiple recipients of list ORACLE-L
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
last post
[EMAIL PROTECTED] wrote:
|
| bye...
- --
Joseph S Testa
Chief Technology Officer
Data Management Consulting
It's the end of an era. How long was the list hosted here?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jacques Kilchoer
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and
LGWR will always write to the redo-logs in a round-robin
fashion. So, on completing Group2, it would wait
for Group3 to be INACTIVE. {One exception is when you ADD a new Log
Group. If you added a new log
file without specifying a Group#, it would be allocated Group#4, would be
set to status
My guess would be that company is not a number but because you do compare
it to a number company=2000 Oracle does an implicit conversion
to_number(company)=2000 and that fails when it hits a row where company
is not numeric.
If my guess is right try company='2000'
At 07:59 PM 1/30/2004, you
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
last post
Wolfgang Breitling wrote:
| My guess would be that company is not a number but because you do
| compare it to a number company=2000 Oracle does an implicit
| conversion to_number(company)=2000 and that fails when it hits a
| row where
drop list ORACLE-[EMAIL PROTECTED]
\rm r FATCITY
bye
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Friday, January 30, 2004 5:24 PM
To: Multiple recipients of list
ORACLE-L
Subject: Bye...
bye...
Do you have any LOBs defined with
the nocache nologging attribute ?
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
Next public appearances:
Jan 29th
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Mladen Gogala
Sent: 29 January 2004 01:54
To: Multiple recipients of list ORACLE-L
Subject: Re: [Q] wait time on stat
Defaulty Windows installation usually creates log files of 20M. The
person
Hi!
Do you have any LOBs defined with
the nocache nologging attribute ?
This was what I initially thought would be the problem, but then I thought,
in case of nocache lobs you should see direct path writes (lob) a lot...
Tanel.
--
Please see the official ORACLE-L FAQ:
I have the same problem like you Rajesh, the query also gives different
rowcount each time executed eventhough there's no one updating base
tables, in my opinion it's because of the sorting operation (your group
by clause). In my case after I remove some group functions, the result
goes well. Also
Mladen,
Here I will humbly disagree with you. It is not fault of Windows but the
person who created the database and defined tiny size log files while
creation. If he used custom database option he can define whatever size he
wants. These options are same for both Windows and Unix.
Regards
Subject: RE: !!Please Read - Oracle-L is moving!!
may i just say - this resource is worth the minimal effort it took
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf
Of [EMAIL PROTECTED
: [EMAIL PROTECTED]
home: [EMAIL PROTECTED]
954-3752 (Mon - Fri 7am - 3pm)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of [EMAIL PROTECTED]
Sent: 2004-01-28 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: RE
PROTECTED]
Sent: 2004-01-28 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: !!Please Read - Oracle-L is moving!!
may i just say - this resource is worth the minimal effort it took
-Original Message-
From: [EMAIL
)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf
Of [EMAIL PROTECTED]
Sent: 2004-01-28 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: !!Please Read - Oracle-L is moving!!
may i just say - this resource
I really do not understand all this topic.
I just sent subscribe, reply to the message that I received and that's all.
Oh, yes, I had to update the e-mail address in my favorites. Another minute
down the drain.
Jared has enough work to do, without having to what is a minimal effort from
you.
This is a hack but ... you might want to look into ftp-ing a file to Unix,
run a 'tr' or 'sed' to get rid of the EOL character.
Thanks,
Nikhil
-Original Message-
Sent: Thursday, January 29, 2004 10:34 AM
To: Multiple recipients of list ORACLE-L
We are migrate from MS Access to
So, why don't you use migration workbench, when it's available?
On 01/29/2004 10:34:27 AM, dba1 mcc wrote:
We are migrate from MS Access to ORACLE(9.2.0.4) use
SQL*Loader. The problem we have are some of MS Access
dump records (ASCII output) have to several lines(EOL
before end of record). For
And these would be CPM (commits per minute) and RPM (rollbacks per minute).
If you really want a transaction, you have to code it yourself, otherwise all you can
get is CPM and RPM.
If your transactions_per_minute ( or commits_per_minute) is low use this handy script
to bump it up.
create
Thank you for answer. I did not said clearly. Most
records are fine. ONly some records have this
problem.
re-transfer from PC to UNIX will not fix problem.
--- Nikhil Khimani [EMAIL PROTECTED] wrote:
This is a hack but ... you might want to look into
ftp-ing a file to Unix,
run a 'tr
27-01-04 -0800, you wrote:
Anjo
So what was the deal with oraperf.veritas.com if you don't mind my asking?
I subscribed to it sometime before Christmas, but when I went to use it a
week or so ago, it had disappeared and I had to (re)subscribe to
www.oraperf.com.
--
David Lord
-Original
There is no simple way, What is important for you ... value of the element or the
index of the element in the pl/sql table? Looks like the index of the element is
important for you.
Tell us again what is the problem? is it that you have too many array elements? where
does the time goes? it
Jonathan / Tanel:
I, however, AM having this problem. Didn't know where
to look till I saw this message. (I love this list!)
I've yet to capture the sid (and therefore track back
to the table) where the 'direct path write' occurs.
Definitions for the tables were supplied by the
vendor. When I
There is a note in one of the manuals about nologging
lobs (or nocache lob, I forget which) that points out
that the unrecoverable SCN for file that holds the
LOB has to be updated in the control file whenever the
LOB is updated.
If you actually have a performance problem because of
this - i.e.
You may want to add CONTINUEIF clause and try the load again
...
infile 'data.asc'
CONTINUEIF NEXT (1) != ''
into table test
...
For complete reference, see this URL:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/ch05.htm#1005518
--
Thanks,
Krishna
RIP old friend!
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Thursday, January 29, 2004 12:24 PM
To: Multiple recipients of list ORACLE-L
A repost of a previous message.
This is the last day for this address folks.
---
[EMAIL
If what you are describing is completely accurate,
( no DML, change S_A_S fixes the problem ) then
it would appear you have encountered a bug.
A search on MetaLink is in order, and failing that,
you need to open a TAR.
Jared
On Thu, 2004-01-29 at 04:59, Wendry wrote:
I have the same problem
Can't do it (until version 10)
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
Next public appearances:
Jan 29th 2004 UKOUG Unix SIG - v$ and x$
That is an interesting use of an alternate block size Jonathan.
Jonathan Lewis [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/29/2004 09:59 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: [Q] wait time
Hi, for Merge command, how to specify if matched, not
to do anything, I tried NULL, not working. Thank you!
MERGE INTO caption c3
USING [EMAIL PROTECTED] c1
ON (c3.caption_id = c1.caption_id)
WHEN MATCHED THEN
NULL -- don't need to do anything when matched!
WHEN NOT MATCHED THEN
Jonathan,
about which version are you talking here?
(You do also have the option in more recent versions
of refining the caching properties so the LOB can be
readcache only, writecache only or read/write cache
or nocache, I believe).
I haven't found a way to explicitly set read or write
Rajesh,
A look into the docs might help you:
In date-format SS means seconds as of the seconds 00-59 in a
minute.
S means seconds since midnight, thus 0 - 86399
Compiling the statement the longest part is recocnized first.
So:
SS give 06 in your first example.
gives 20, but twice: 2020
, 2004
4:29 PMTo: Multiple recipients of list ORACLE-LSubject:
Re: Date Format: MysteryRajesh,A
look into the docs might help you:In date-format SS means seconds as
of the seconds 00-59 in a minute.S means seconds since midnight, thus
0 - 86399Compiling the statement the longest
Comments below.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 29, 2004 7:04 PM
Jonathan / Tanel:
I, however, AM having this problem. Didn't know where
to look till I saw this message. (I love this list!)
So do I ;)
I've
Thanks, Tanel.
Yes, I'll be at RMOUG.
I'll be in the front row for your presentation.
Again, thanks for the info.
Barb
--- Tanel Poder [EMAIL PROTECTED] wrote:
Comments below.
- Original Message -
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Thursday, January
:09 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: !!Please Read - Oracle-L is moving!!
One word -
exchange.
--David Lord
-Original Message-From: Hemant K
Chitale [mailto:[EMAIL PROTECTED] Sent: 23 January 2004
16:54To: Multiple recipients of list ORACLE
ORACLE-LSubject:
RE: !!Please Read - Oracle-L is moving!!
Hi
List Manger-
Couldn't a immigration of our subscribed accounts been the most logical
and error free option ?
All
this fire would have been avaoided.
CSW
Simon.
-Original Message-From: Lord David
one word ... CLOB field ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-Original
yes!
--- Daniel Fink [EMAIL PROTECTED] wrote:
Is there any interest in an Oracle-L gathering after the first
day at RMOUG TD?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Daniel Fink
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
disappeared and I had to (re)subscribe to
www.oraperf.com.
--
David Lord
-Original Message-
From: Anjo Kolk [mailto:[EMAIL PROTECTED]
Sent: 27 January 2004 13:29
To: Multiple recipients of list ORACLE-L
Subject: RE: What to look for in STATSPACK report
No, the server is in my basement
When running on a clustered environment, do all the servers have to be
identical?
Oracle says that the beauty of using blade servers is you buy what you need
now, then add later.
What if later is two years later? You might not be able to buy the same
machines, only more powerful ones.
Does
Hi
All I know is that we used to completely different machines to set up a
windows test RAC.
The requirement seems to be that the OS must be the same.
Jack
-Original Message-
Sent: Wednesday, January 28, 2004 4:24 PM
To: Multiple recipients of list ORACLE-L
When running on a
Charlie,
I understand a transaction as a succession of SQL statements between two successive
COMMITs or ROLLBACKs - you will find inside V$SYSSTAT how many COMMITs and ROLLBACKs
were issued.
If you are interested, besides transactions proper, in the number of statements
executed, then have
Well, as you are well aware of, you cannot measure without
impacting. I know of the following methods:
1) Turn on auditing, count all transactions from dba_audit_trail
table within a day and divide by the number of minutes in 9 hours.
That will give you an average TPM number during the working
Check out 'user commits','user rollbacks' and (maybe) 'user calls' in
v$sysstat. These get collected by statspack so you can plot a chart over
time.
Niall
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of [EMAIL PROTECTED]
Sent: 28 January 2004 15:29
Charlie,
I use the following to determine this:
EXEC SQL SELECT ROUND(VALUE/((SYSDATE-STARTUP_TIME)*1440),1)
INTO :tp
FROM V$SYSSTAT, V$INSTANCE
WHERE NAME='user commits';
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original
Logminer has been of use in looking at past activity as far as INSERT/UPDATE/DELETE
and then COMMIT;. Looking at a day of lofs we have been able to measure activity to
all of our tables, indexes and queues and as been very helpful in giving us infor we
need for future capacity planning.
respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: !!Please Read - Oracle-L is moving!!
Hi List Manger-
Couldn't a immigration of our subscribed accounts been the most logical and error free option ?
All this fire would have been
My reply would be something along the lines of
A transaction as you would like it to be measured is best measured
in the application. I can provide you with IO per minute, broken down
into reads and writes, and a number of other statistics.
What they are asking for cannot be measured from
way.
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Wednesday, January 28, 2004
12:09 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: !!Please Read - Oracle-L is moving!!You sir, have obvio
may i
just say - this resource is worth the minimal effort it took
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of
[EMAIL PROTECTED]Sent: Wednesday, January 28, 2004 12:09
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
!!Please
Charlie,
What is the perceived relevance of gaining this information? You would be
much better off correlating statistics such as overall non idle wait time
and database workload (# Users, Ion's/CPU etc...) to actual business
functions the database is performing (invoices, sales orders, etc...).
On 01/28/2004 12:34:26 PM, Post, Ethan wrote:
Charlie,
What is the perceived relevance of gaining this information?
The information is necessary so that manager and director can make a
lovely excell spreadsheet for the VP, who will, in turn, insert it into
a slide show for the CIO.
--
Mladen
12:25 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: !!Please Read - Oracle-L is
moving!!
may
i just say - this resource is worth the minimal effort it
took
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of
[EMAIL
- Fri 7am -
3pm)
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]Sent: 2004-01-28 12:25
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
!!Please Read - Oracle-L is moving!!
may
i just say - this resource
Subject: RE: !!Please Read - Oracle-L is moving!!
may i just say - this resource is worth the minimal effort it took
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf
Of [EMAIL PROTECTED
If that is what this is for, the formula is very simple. TPM = x*42 where
x is a number sufficient to justify the really cool hardware system you
want.
Mladen Gogala wrote:
On 01/28/2004 12:34:26 PM, Post, Ethan wrote:
Charlie,
What is the perceived relevance of gaining this information?
Hey Charlie,
I made a DBMS_JOB here that runs this procedure every 5 minutes:
CREATE OR REPLACE PROCEDURE QT_TX_MONITOR AS
-- 06/17/2001 REJesse Created.
v_value NUMBER;
BEGIN
SELECT SUM(VALUE) INTO v_value
FROM V$SYSSTAT
WHERE NAME IN ('user
: [EMAIL PROTECTED]
home: [EMAIL PROTECTED]
954-3752 (Mon - Fri 7am - 3pm)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of [EMAIL PROTECTED]
Sent: 2004-01-28 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: RE
PROTECTED]Sent: Tuesday, January 27, 2004
2:29 PMTo: Multiple recipients of list ORACLE-LSubject:
Re: UNION ALL Query: RiddleQ: What does "different results" mean? Different row count? Completely different data? Partially different data? Some columns have incorrect value? What a
PROTECTED]
Sent: 2004-01-28 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: !!Please Read - Oracle-L is moving!!
may i just say - this resource is worth the minimal effort it took
-Original Message-
From: [EMAIL
)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf
Of [EMAIL PROTECTED]
Sent: 2004-01-28 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: !!Please Read - Oracle-L is moving!!
may i just say - this resource
Increase redo logs to 250M each. You're checkpointing.
On 01/28/2004 03:09:26 PM, dba1 mcc wrote:
WE have ORACLE 9.2.0.3 database run under Win2000. I
run statspack and found Top 5 timed event. Look
like control file parallel write and redo file
parallel write take lots time. How to fix?
Daniel Fink scribbled on the wall in glitter crayon:
If that is what this is for, the formula is very simple. TPM = x*42
where x is a number sufficient to justify the really cool hardware
system you want.
as a serious question, is TPM a valid measurement for a database? or are
there other
1 - 100 of 67344 matches
Mail list logo