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 PROT
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...
-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 co
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
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
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 web
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
614-791-900
-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 Moz
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 ACTIVE 2 CURRENT 3 ACTIVE
Now i
Yes, I'm sure.
If in the services control panel you change OracleService starup
properties, it does not affect "ORA__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 valu
Igor,
What you have mentioned is right i.e. if I set "ORA__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 nee
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
per
> -Original Message-
> Igor Neyman
>
> OracleServiceSID starts the database automatically, because by default
> the registry key "ORA__AUTOSTART" IN
> "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0" is set to "TRUE".
> If you don't want your OracleServiceSID to start the database
> automaticall
Mladen,
Thanks for info. So all the dirty blocks need to be written to disk after each checkpoint. After that is done the status becomes 'INACTIVE'. Just that sometimes this is very unpredictable.
My question : If a log switch always causes a implicit checkpoint then what is the need for this ex
Dharminder,
OracleServiceSID starts the database automatically, because by default
the registry key "ORA__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 se
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
There is a pretty good explanation in this usenet thread:
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=OoSWa.122%246d2.89%40newssvr22.news.prodigy.com&rnum=1&prev=/groups%3Fq%3Dv%2524log.status%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3DOoSWa.122%25246d2.89%2540new
Dharminder
Softhome"To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: Starting Database from OEM
9.2 gives ORA-12500 Failed to star
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 boot
, 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.
so change the server mode from dedicated to shared, (you can do it change
some
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 f
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
[mailto:
There is not enough memory to start a dedicated connection. so change 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 database on the same machine,
/30/2004 07:44 AM
Please respond to ORACLE-L
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 th
Subject: Re: [Fwd: ! READ THIS - [EMAIL PROTECTED] is shutting down as
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 M
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 m
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,
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
San
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
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..." -- Gil
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.
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 S
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 se
Sent by: cc:
[EMAIL PROTECTED]Subject: Re: SV: Date Format: Mystery
Go to the SERVICES and start the service.
"Dharminder
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. Or
MAIL PROTECTED]>
Sent: Friday, January 30, 2004 2:49 PM
> > 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 d
27;mostly' LOBs?
>
> 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.
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
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
http://www.j
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 R
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: Thursda
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 ;)
: Friday, January 30, 2004 1:04
AM
Subject: Re: [Q] wait time /lob def
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
P
, January 29, 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
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
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
>> 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 N
TECTED]>
cc:
Subject: Re: [Q] wait time /lob def
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
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$
Marc
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 li
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
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
~~
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
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 l
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 sho
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
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 U
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 tabl
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 e
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 ORACLE
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.
Yech
> > perhaps we should list addresses every 6 months ;-)
> >
> > Babette Turner-Underwood
> > work: [EMAIL PROTECTED]
> > home: [EMAIL PROTECTED]
> > 954-3752 (Mon - Fri 7am - 3pm)
> >
> > -Original Message-
> > From: [EMAIL
> > work: [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: !!Please Read - Oracle-L is moving!!
>
>
> may i just say - this resource is worth the minimal effort it took
>
> -Original Message-
>
004-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-
>
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
Ra
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
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: http://www.orafaq.
> -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 cr
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 2
"Defaulty Windows installation..." Hehehe;-)
-Original Message-
From: Mladen Gogala [mailto:[EMAIL PROTECTED]
Sent: Wed 1/28/2004 8:54 PM
To: Multiple recipients of list ORACLE-L
Cc:
Subject:Re: [Q] wait time on stat
Defaulty Windows installation usual
Defaulty Windows installation usually creates log files of 20M. The
person who posted the problem explicitely mentioned Windows platform.
Size of 20M is so small that the database will start to checkpoint
like crazy when you start using it for real. The number that I gave
is my rule of thumb. It'
How did you determine the size of the logs?
Or are you just guessing that they are significantly
less than 250m?
Could just be a very busy database that needs redo
and controlfile on faster disk.
Jared
On Wed, 2004-01-28 at 12:24, Mladen Gogala wrote:
> Increase redo logs to 250M each. You're c
gt; Sent: Tuesday, January 27, 2004 2:29 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: UNION ALL Query: Riddle
>
>
> Q: What does "different results" mean?
>
> Different row count?
&g
I would say that it depends on the system. If we are talking about a stock
trading system, then TPM is very important as is
transaction-time-to-completion. For a data warehouse, this may be absolutely
meaningless. Of course, does TPM describe the width of the database pipe or
it's depth? In the fir
Janet,
How about something like:
Insert into caption c3
(c3.CAPTION_ID,
c3.CAPTION_NAME,
c3.VISIBILITY_ID,
c3.MOD_DATE,
c3.MOD_USER)
Select
c1.CAPTION_ID,
c1.CAPTION_NAME,
c1.VISIBILITY_ID,
c1.MOD_DATE,
c1.MOD_USER
>From [EMA
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
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
> > perhaps we should list addresses every 6 months ;-)
> >
> > Babette Turner-Underwood
> > work: [EMAIL PROTECTED]
> > home: [EMAIL PROTECTED]
> > 954-3752 (Mon - Fri 7am - 3pm)
> >
> > -Original Message-
> > From: [EMAIL
> > work: [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
I now have a cronjob which runs hourly which contains:
#!/usr/bin/ksh
SID=MWH
HOST=`uname -n`
. /u01/home/oracle/oracle.${HOST}.${SID}.env
ACCESS=`cat /home/oramwh/sql/ctrl/${SID}/bcm`
sqlplus << EOF
${ACCESS}
set pause off echo on term on verify on serveroutput on
insert into sysstats select sy
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 abou
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-
>
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 commits','us
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 infor
004-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-
>
(Mon - 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 is
,
2004 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
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
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...).
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
that painful
anyway.
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
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 d
Please 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 logic
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.
-Or
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 Mes
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
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
1 - 100 of 71998 matches
Mail list logo
