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
Title: Meddelelse
Rajesh,
SYSDATE is of datatype DATE (that's what the documentation says), i.e. it
contains century, year, month, day, hour, minute and second (without
decimals).
I have made a little test. FirstIdump a
SYSDATE to see the internal representation. Then Icreate a table with
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
Title: Meddelelse
Sorry! I was mixingformat-masks. The last SQL should read (i.e.
instead of ):
select to_char(systimestamp, '.MM.DD
HH24:MI:SS.'), dump(systimestamp)
from dual;
/Jesper
-Oprindelig meddelelse-Fra:
[EMAIL PROTECTED] [mailto:[EMAIL
i apologize if someone posted this answer(i missed it if you did), but why do cached
lobs require writes on the control file? and jonathan said that isnt 'necessarily'
bad. is that because there isnt alot of I/O?
so caching lobs are primarily useful for read only or read 'mostly' LOBs?
Hi!
i apologize if someone posted this answer(i missed it if you did), but why
do cached lobs require writes on the control file?
NOCACHE NOLOGGING LOBs require writes to controlfile, because last nologging
operation to a datafile has to be reflected somewhere, for being able to
determine which
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
Hallo,
I would like to write the code to atrigger that makes insert into another table inly
if there is the condition
PREFERED_NUMBER = 1 and TELEPHONE_TYPE_ID in (1,2, 5)
How can write this in a simple way?
Thanks in advance.
Roland
--
Please see the official ORACLE-L FAQ:
How does dba_jobs decide what it's nls_env values are?.
They seem to vary according to whether I queue the job from a windows client
or from unix.
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services
Hi,
From Note: 69028.1 on Metalink
The datatype returned is 13 and not 12, the external DATE datatype.
This occurs because we rely on the TO_DATE function!
External datatype 13 is an internal c-structure whose length varies
depending on how the c-compiler represents the structure.
Note that
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,
We move an application that uses
OPTIMIZER_MODE=RULE from Oracle8 to 9i. Most of it is fine, but there are two
queries that have a very different execution plan. In one case, the execution
time increases from less than a minute to more than an hour. Neither query uses
any of the new Oracle
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
The Windows service implements Oracle's VOS ( virtual OS )
This is not noticed on *versions, as there is no separate step.
See James Morle's book 'Scaling Oracle 8i'.
Jared
Mercadante, Thomas F [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/30/2004 07:44 AM
Please respond to ORACLE-L
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
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 for block recovery. It might or might not be
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
Mauricio
I do
not think it is a memory issue because I can startup the database using Windows
2000 OracleServiceSID service and it does not fail.
Thanks.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Mauricio
VilezSent: Friday, January 30,
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
That's true.
Dharminder
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
Hello,
Ihave a procedure that open a cursor anddumps some data for last 24 monthsto a file. The date range is static condition definedinside the cursor. Procedure is working great, but Iwhat I'm havingproblemfiguring outisif there is a way to create not one file with all the data, but multiple
bye...
-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
I am running a query:
select
from
WHERE COMPANY=2000 AND LOCATION='CDJ01' AND
ITEMLOC.ACTIVE_STATUS='A' AND POVAGRMTLN.PROCURE_GROUP='SMAR'
AND RTRIM(LTRIM(POVAGRMTLN.VEN_AGRMT_REF)) = 'COM1-21-LARROC NANCY'
AND RTRIM(LTRIM(POVAGRMTLN.VENDOR))='21'
and in the next part of the where
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
the OT list is significantly smaller than this list and I clean
addresses every 6 months or so. It's not easy being a list owner, Jared
has my utmost respect for the work it takes to manage this huge list.
It took me 3 seconds to send the first message to subscribe and less
than that to verify
Oops ... Had a typo in the second sentence
It should have read
But if it clears out the dead subscribers,
perhaps we should CHANGE list addresses every 6 months ;-)
I was AGREEING that the changing list addresses was a minimal amount of work compared
to the amount that we get back out of
I was agreeing with you. :)
--- [EMAIL PROTECTED] wrote:
Oops ... Had a typo in the second sentence
It should have read
But if it clears out the dead subscribers,
perhaps we should CHANGE list addresses every 6 months ;-)
I was AGREEING that the changing list addresses was a
Phew, I would hate to have the Oracle Goddess in disagreement with me.
I have already had a bad enough day Arguing with one of the other DBAs about how
long a recovery took. (It was just testing that recovery would work... Proof of
concept... Not testing for recovery timing AAAarrgh!)
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.
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 example:
control file:
load data
infile 'data.asc'
into table test
fields terminated by ','optionally
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'
I still go to www.oraperf.com and it still greets me with the same interface and
provides the same services that it did before
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email
I have been trying
to get stored outlines to work.It seems simple enough, but it is working
the exact oppositeas I think it should. Anyone else use these?
I am on 8.1.7.4 on HP-UX 11.00
In a nutshell, I
verify my query is using the correct explain plan. I grant 'create any
outline' to
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
A repost of a previous message.
This is the last day for this address folks.
---
[EMAIL PROTECTED] is shutting down as of 1/31/2004
If you have already subscribed to the new location for
Oracle-L, then you may discard this message.
To those of you still reading:
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$
Hi All,
See the following -
1) select to_char(sysdate,'-MM-DD HH24:MI:SS AM') from dual;
result = 2004-01-29 12:52:06 PM
2) select to_char(sysdate,'-MM-DD HH24:MI: AM') from dual;
result = 2004-01-29 12:52:2020 PM
3) select to_char(sysdate,'-MM-DD HH24:MI:SS AM')
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
Hey all,
Following is the environment.
Windows 2000
Oracle Enterprise 9.2,
OEM 9.2
I have two 9.2 database installed on my system. OEM is configured properly.
One of the database is in automatic startmode and this DB contains OEM
repository.
I start the machine, open OEM, login to OEM and then
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
Carel-Jan,
This explanation helps. Thanks a
lot.
Could you also answer if displaying
centiseconds or milliseconds or 1/10th of a second in oracle is possible or
not
Thanks,
Rajesh
-Original Message-From: Carel-Jan Engel
[mailto:[EMAIL PROTECTED]Sent: Thursday, January 29,
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
Title: Message
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
[mailto:[EMAIL PROTECTED]Sent: Monday, January 26, 2004
Title: Message
I
don't recommend using Word as the editor for Outlook... Subscribe to the Windows
and Office lists from www.woodyswatch.com
Patrice.
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: January 28, 2004
3:49 AMTo: Multiple recipients of list
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
We have recently completed a successful upgrade P10 with the
inclusion of the list's own Mogens Norgaard and the semi-retired
Dave Ensor (the past Jonathan Lewis). For a full list of
speakers, exhibitors and events, please visit www.rmoug.org.
--
Please see the official ORACLE-L FAQ:
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 http://www.fatcity.com
San Diego, California--
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
There certainly _was_ a site called http://oraperf.veritas.com
Hemant
At 05:59 AM 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
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
I've been asked to provide value for the Transactions Per Minute
going through our primary OLTP production database.
I believe I can use deltas in SCN values to measure transactions
which do INSERT/UPDATE/DELETE and then COMMIT;
Is there any way to measure/count the number of SELECTs which
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
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
1 - 100 of 84251 matches
Mail list logo