LoL
-Original Message-
From: Bellows, Bambi [mailto:[EMAIL PROTECTED]]
Sent: 23 January 2002 19:40
To: Multiple recipients of list ORACLE-L
Subject: RE: SCOTT/TIGER - the rumor mill
I heard that CALVIN/HOBBS was taken. No seriously, the
girlfriend's cat
story is at least 18
The problem is that these kinds of operations can have a timed delayed fuse.
By the time your leg explodes the old leg does not feet (could not resist
:-) )
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From: Bellows, Bambi [SMTP:[EMAIL PROTECTED]]
Sent:
Whats all this about a cat (they hardly make good pets) I definitely
heard from 'reliable sources'
that Tiger was Scott's dog.and a German Shepherd at that !!
Samir
Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email : [EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone :
Can you send me one (NT backup strategy)
Regards,
Ramesh D Papnoi
Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
(BrainBench Brainbuzz Certified Oracle 8/8i DBA Developer)
http://www22.Brinkster.com/rpapnoi
-- Original Text --
To: internet[Multiple recipients
If possible , I want one copy too.
Bunyamin
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 24, 2002 12:30 PM
Can you send me one (NT backup strategy)
Regards,
Ramesh D Papnoi
Oracle DBA @ Chemtex Global Engineers Pvt. Ltd.,
Nope, the MAGIC I want to know is the one developed by some Isroil
Technologies or somesuch The one by magicsoftware is RAD for Linux.
Shreenivasa Rao
e-Zing Technologies, Inc..
41-43 Beekman Street, 3rd Floor
New York, NY 10038.
Tel: (212)233-9861 xt.241
Fax: (212)233-9862
Sorry Jeremiah, I don't have a clue...
got the same error (after the same 2 hours) after purging the
shared pool; there was no activity at all on the database, so
I thought about increasing the size of the shared pool (~10.5MB)
but had a need, and the option, of simply replacing the
Why doesn't somebody get smart and post this to a web site somewhere, post
the link to the list and everybody can have a free for all?
Sounds good to me - as I wouldn't mind a copy of this myself.
Any takers? If not - send it to me and I'll post it (unlinked) on to the
cool-tools site for the
Hi All,
http://www.geocities.com/tbcox23/
Go here and get the paper.
Regards
Venkat
--
On Thu, 24 Jan 2002 03:25:17
Bunyamin K. Karadeniz wrote:
If possible , I want one copy too.
Bunyamin
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
Hallo,
any one who canhelp me?
How can I find out which time a pl/sql procedure starts and which time it ends?(Ends
by any reason at all).
Thanks in advance
Roland
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network
Anyone who can help me with this:
I have a Microsoft routin, whic calls oracle procedure in database servername,
which have a databaselink to other databases(located on computers with Linux
system).That procedure is supposed to pick up data from tables which exist in the
other
databases.
Joe:
I belong to OTN and tried that route. But I only have
a regular speed phone line and it would have taken
about two weeks to download the three zip files. So it
was just easier to pay $39.95 plus shipping. And I
also get other tools and doc. in the CD Pack.
Ken
Yes your PC melts
Create your custom procedure_audit table with the columns to store procedure
name and timestamp, and write into it in the very beginning and very end of
each procedure.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Um Jared dear it's not the admin directory, at least not on my
Solaris/8.1.6 box
$ORACLE_HOME/rdbms/mesg is the correct directory :)
--- [EMAIL PROTECTED] wrote:
If you have access to Oracle on a unix system, take a look at
$ORACLE_HOME/rdbms/admin/oraus.msg.
Events 1 - 10999
Jessica,
It looks like your query has to deal with all 14 partitions, because the
column 'poid_id0', which your table partitioned on, is not in 'where'
clause.
That's why Oracle can not eliminate other (not populated) 13 partitions.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original
I believe you will need to code it into your procedure
i.e.
beginning of proc
get start time (via sql below)
do work
get end time
then either store the elapsed time somewhere, or print it out.
-Joe
--- [EMAIL PROTECTED] wrote:
But which query asks for the start date of the
I was looking at their site today and came across a free product called
WEBDBA. Any opinions on it.
Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional
Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216)
781-4204
Kurt,
If you're on 8.1.6.3, 8.1.7.0.0 or 8.1.7.1.0 this
sounds suspiciouslly like either bug 1640583 or bug
1397603, both of which are fixed in 8.1.7.2+
The workaround for bug 1397603 is to set
_db_handles_cached = 0 in the init.ora.
HTH,
-- Anita
--- Wiegand, Kurt [EMAIL PROTECTED] wrote:
If you run procedure from SQLPlus then you can use option set time (or
timing, didn't remember) on and simply count the difference
If you need this info inside the procedure
then just simply in the fisrt line of procedure remember the start time in
some variable either from sysdate or
Holly,
I subscribe to the [EMAIL PROTECTED] ingres dba list. I can't find
out how you can subscribe though, sorry! (no, It's not in any trailer or
signature) Maybe a search engine will find something.
It's fairly low traffic compared to this list but there are some
peeps who know
Put some extra statements like 'select to_char(sysdate,'mmddyy hh24:mi:ss')
from dual;' in you code at the beginning and end of the procedure.
HTH,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 24, 2002 8:00 AM
Hallo,
Obviously, that was Scott's sYster... And she had to change after installing
Oracle on some dirty boxes...
-Original Message-
Sent: Wednesday, January 23, 2002 10:50 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: SCOTT/TIGER
So who was SYS, and why on earth did
Hey Folks,
The function last_day is there to handle all of that stuff, if you'll RTFM.
Then using that and adding 1 day will always give you the first day of the next
month without all of that substringing stuff.
Sheesh, maybe we need a new 'obfuscated sql' contest again? Like who
I tried it and although it was very neat it was way too slow.
Ron Smith
-Original Message-
Sent: Thursday, January 24, 2002 8:05 AM
To: Multiple recipients of list ORACLE-L
I was looking at their site today and came across a free product called
WEBDBA. Any opinions on it.
Thanks to Jared and others for a quick assistance.
Regards,
Viktor
--- [EMAIL PROTECTED] wrote:
Well, yes the first day of the month is always 1.
Representing it as the first day of the current
month requires
you to use the SYSDATE function.
Returning the first day of the month can
Hello
Nope to your NOPE.
This is the site. Checked it just now with one of our magic developers.
It is a RAD tool and it works also on wintel machines (maybe more, I do not
know).
If you want some more info contact me directly and I will be happy to
assist.
Yechiel Adar, Mehish Computer
Our developers store XML docuements inside CLOBS and
want to search the CLOB contents based on a search
string. I have lot of concern about such queries but
could benefit from someone on the list who has already
solved the performnce issues with such searches.
Typical existing queries I have
Ken,
To Oracle's good and bad, no nothing will happen. For a number of years now
Oracle has allowed us (the user community) to experiment with their software for
nothing as long as that tinkering only results in understanding of how the
software works and it's potential applications. Once
Well, Scott Gossett has certainly been with Oracle a long time, he
definitely teaches the advanced seminars (take them if you can), he's
one of the best instructors with Oracle University (and for the other
instructors I know that haunt this list, please note one of -- you
guys are great as well)
We are experiencing very slow interMedia Text resyncs ( CTX_DDL.Sync_Index )
under 8.1.7.2.5 on Win2k Server.
We upgraded from 8.1.6.0.0 to 8.1.7.2.5 earlier this month (both under Win2k
Server) on essentially the same hardware. We used to see about 700-2000
CLOB documents per second indexed
Just put the select before the activation of each procedure in your program
and after the last one:
BEGIN
SELECT TO_CHAR(sysdate,'MM/DD/ HH:MI:SS') FROM dual;
p1;
SELECT TO_CHAR(sysdate,'MM/DD/ HH:MI:SS') FROM dual;
p2;
http://www.sun.com/storage/white-papers/backup-planning.html
JP
On Thursday 17 January 2002 18:26, you wrote:
Hi List,
I have a white paper for Backup Strategy on Microsoft NT but I am looking
for Backup Strategy for Oracle8i on Solaris, If anybody have any doc or
link I realy appreciate.
http://www.stormgt.org/white.html
JP
On Thursday 17 January 2002 18:26, you wrote:
Hi List,
I have a white paper for Backup Strategy on Microsoft NT but I am looking
for Backup Strategy for Oracle8i on Solaris, If anybody have any doc or
link I realy appreciate.
Hamid Alavi
Office 818
ARE YOU AN IDIOT?
-Original Message-
Sent: Wednesday, January 23, 2002 3:21 PM
To: Multiple recipients of list ORACLE-L
??
ORACLE-L Digest -- Volume 2002, Number 023
--
From: [EMAIL PROTECTED]
Date: Tue, 22 Jan 2002 11:00:47 -0800
Subject:
# Script for analyzing Oracle Trace files with WAIT statistics
# Usage: wait_scan.awk filename
# Written:Henry Poras
# 5/16/00
# Modified: 12/3/01 Initially assumes all wait states for a
cursor are between
#
I am looking under my \network\names folder and I don't see a namesini.sql
file. Do you have to buy Oracle Names Server separate from Oracle?
David Ehresmann
Oracle DBA 8 8i OCP
MCI Worldcom
[EMAIL PROTECTED]
972.656.1015
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
I have a very simple NT backup strategy. Move the database to Unix.
-Original Message-
Karadeniz
Sent: Thursday, January 24, 2002 3:25 AM
To: Multiple recipients of list ORACLE-L
If possible , I want one copy too.
Bunyamin
- Original Message -
To: Multiple recipients of list
Back when I used GUPTA (now I think it's called Centura), those guys claimed
it was Bruce Scott (one of the co founders of Oracle) and the ever popular
cat .
-Original Message-
Sent: Thursday, January 24, 2002 7:51 AM
To: Multiple recipients of list ORACLE-L
Well, Scott Gossett has
Is anyone actually using Oracle's XML parsing features?
I have an application where we will need to input data
which is being sent to us in XML format. (Oracle version
8.1.x). I'm interested to know if Oracle's XML tools
will give us any leverage.
Thanks,
Peter Schauss
Northrop Grumman
Whose ODBC DRIVER are you using? If it is Microsoft's ,go to the workaround options
for the DSN; once there, turn of muti-threaded server support.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, January 24, 2002 4:55 AM
To:
Title: RE: Re: Backup Strategy
here is a pretty good one as well... The paper is on building a 24x7 database.
http://www.quest.com/whitepapers/Building_WP.pdf
-Original Message-
From: Jan Pruner [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 24, 2002 6:10 AM
To: Multiple
Is it natural for relays to hum?
-Original Message-
SO, what did you want?
Dick Goulet
Ancient Electronics Tech tinkerer, Also certified relay NUT
Reply Separator
Author: Adams; Matthew (GEA; 088130) [EMAIL PROTECTED]
Date: 1/23/2002
Read the fine docs on Technet on Intermedia text, as well as the
XML development kit.
-Joe
On Thu, 2002-01-24 at 10:20, sundeep maini wrote:
Our developers store XML docuements inside CLOBS and
want to search the CLOB contents based on a search
string. I have lot of concern about such
I hope your customer is not a member!!!
Kimberly
Another NT-bigot! Let's not get started on THIS again! :)
-Original Message-
Sent: Thursday, January 24, 2002 10:35 AM
To: Multiple recipients of list ORACLE-L
I have a very simple NT backup strategy. Move the database to Unix.
-Original Message-
Karadeniz
Sent: Thursday,
Peter,
Send me your questions, I will forward them onto the developer that was/is
working on a Oracle project(s) parsing XML. If you send me a specific set
of questions, then I'm sure he can find some time to answer them.
Thanks.
Chris
May Oracle be with you...always
-Original
Oracle Names Server is on Oracle CD but has to be explicitly selected on
installation. You have to go with Management Server install (on later
versions).
Are you sure Oracle Names was installed?
I believe there is no extra license fee for Oracle Names.
Have you considered going with Oracle
Allright listers,
I have been experimenting with creating a standby database for our
production server. After moving all the required files files, configuring
the init files, and initiating recovery on the standby instance, I saw the
following error.
01547:warning RECOVER succeeded but OPEN
Hi
When i check alert log the log switching normally between 20 min or 30
minutes.But when I do truncate for big table.The chekcpoint started but not
completed.I chekced the
background checkpoints completed and background checkpoints started
diffrence was high during truncate.
My redo log
On the topic, I once had a tablespace with 300,000+ free extents and 0 used
extents. We executed a drop tablespace command, and looking at fet$ and the
rate at which it was dropping extents from the table, we estimated it would
take us 64 hours. This was on a 7.3.4 db, and we thought it better
_ON_INSTALL was the name of Bruce Scott's mother-in-law's hedgehog... her
guppy, MANAGER, having olfactory powers beyond those of normal guppies,
would always get upset by the smell coming out of _ON_INSTALL's bin, and
would mouth Change _ON_INSTALL's bin litter! But, you know, reading guppy
Only when they don't know the words.
Mohan, Ross
MohanR To: Multiple recipients of
Regular relays do not hum. If it does this means it's switching on and off
at certain frequency on which it's designed. Then it's not a relay it could
be one of these devices that convert DC to AC.
-Original Message-
Sent: Thursday, January 24, 2002 10:15 AM
To: Multiple recipients of
They all suck! Let's go back to using the abacus.
Hahaha!
--JoJo
-Original Message-
Thomas F
Sent: Thursday, January 24, 2002 8:35 AM
To: Multiple recipients of list ORACLE-L
Another NT-bigot! Let's not get started on THIS again! :)
-Original Message-
Sent: Thursday,
Hi List,
I want to know what the routine for upgrading 8.1.6 to 8.1.7 on unix?
Any link or url or document will be grate.
Thanks ALL
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
The information contained in this message and any attachments is intended
only for the use of the
I hit 1397603 (think that was the one) and with it you completely lose
service to the database. By the way, my understanding is that purging the
shared pool when you hit 4031 errors is not always going to solve the
problem because if there was SQL available to age out Oracle would do it. I
run
Thanks a lot.
Regards,
Sergey
-Original Message-
Sent: Thursday, January 24, 2002 11:00 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Session_wait
# Script for analyzing Oracle Trace files with WAIT statistics
# Usage: wait_scan.awk
not everyone here has read the docs, remember? :)
--- Bellows, Bambi [EMAIL PROTECTED] wrote:
_ON_INSTALL was the name of Bruce Scott's mother-in-law's hedgehog...
her
guppy, MANAGER, having olfactory powers beyond those of normal
guppies,
would always get upset by the smell coming out of
Hello,
you can use itrprof (web based, and free) to analyze event10046 raw trace
files. The product is at
http://www.unal-bilisim.com/products/itrprof/itrprof.html.
I'm currently developing a new web based product named iOraDumpReader.
This tool will intreprete many Oracle trace files such as:
Symbian?
http://www.symbian.com/technology/why-diff-os.html
Will Oracle Lite run on this?
Will my relays stop humming?
Will Jeannie ever get back into that snappy little outfit from the Kasbah?
-Original Message-
Sent: Thursday, January 24, 2002 11:35 AM
To: Multiple recipients of
I'll lunch beta version next week.
|| eating your own dog food,eh? Admirable!
-Original Message-
Sent: Thursday, January 24, 2002 1:39 PM
To: Multiple recipients of list ORACLE-L
Hello,
you can use itrprof (web based, and free) to analyze event10046 raw trace
files. The product is
JoJo --
Sure, but be aware that Unix abaci are better than NT abaci.
HTH,
Bambi.
-Original Message-
Sent: Thursday, January 24, 2002 11:56 AM
To: Multiple recipients of list ORACLE-L
They all suck! Let's go back to using the abacus.
Hahaha!
--JoJo
-Original Message-
Thomas
Yes, especially if they don't know the words. :)
Scott Lockhart
Oracle DBA
I-Link
Draper, UT
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California--
Discuss Configuring Tuning Databases on the Solaris[tm]
Platform 22-28 January 2002. Join a special online
discussion forum with Sun engineer, Allan N. Packer, author
of Configuring Tuning Databases on the Solaris[tm]
Platform. Database professionals can take this opportunity
to ask questions
Hi,
I head meant 'launch'.
Mohan, Ross wrote:
I'll lunch beta version next week.
|| eating your own dog food,eh? Admirable!
-Original Message-
Sent: Thursday, January 24, 2002 1:39 PM
To: Multiple recipients of list ORACLE-L
Hello,
you can use itrprof (web based, and
I am not sure how to ask this or if it is even possible. I have a stored
procedure that runs every five minutes and writes the data to a table. I
want to query every thirty minutes and group the rows from the last half
our.
would I used date difference?
Thank you in advance
lance
--
Please
[EMAIL PROTECTED] wrote:
JoJo --
Sure, but be aware that Unix abaci are better than NT abaci.
don't forget the VMS abaci.;-)
--
--
Bill Shrek Thater ORACLE DBA
[EMAIL PROTECTED]
You gotta
Select col_1, col_2
from my_table
where col_timestamp is between sysdate and (sysdate - 30/1440)
group by col_1
Assuming col_timestamp is a column in your table with datatype of DATE.
HTH
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Hello Onder,
I have JRE Installed here is what I
get
$: java -versionjava version
"1.3.0_02"Java(TM) 2 Runtime Environment, Standard Edition (build
1.3.0_02)Java HotSpot(TM) Client VM (build 1.3.0_02, mixed
mode)
There fore Java is
installed.
I think this might have something to
do
Our site is preparing to fail over to our backup server. We need to do
maintenance on our production server, and will be running on the backup for
about 24 hours. One issue I brought up was that our backup server is not
equiped with mirrored drives, thus there was the possibility that a drive
I know. It was a joke. Don't bite my head off! ;-)
eating your own dog food is a compliment...meaning
a company that uses its own products in doing its
business.
I will you and the business good luck!
- Ross
-Original Message-
Sent: Thursday, January 24, 2002 2:13 PM
To: Multiple
Lance,
My performance monitor aggregates frequent samples into smaller tables using
this method. I create a function then write a query using the function and
pass in the date column. The group by averages the values for me.
CREATE OR REPLACE FUNCTION nearest_even_hour (p_date IN DATE) RETURN
That's because compilers can't recognize quality when they C it.
har de har har
-Original Message-
Sent: Thursday, January 24, 2002 2:35 PM
To: Mohan Ross
Cc: '[EMAIL PROTECTED]'
Hi Mohan and others,
Thank you for your compliment.
If a compiler has an option to compile or not to
Steve,
'alter database backup controlfile to trace;'
The values will be in the trace file.
Jared
Steve McClure [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/24/02 11:48 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Ross,
You've got to define hum.
|| It's in my Rotel preamp. Personally, I think it should
shut the hell up. As for the sound...it's kind of a
nyah nyah nyah nyah nayaaah nayh
snip
BTW: Definition of 'VERY faint' is in a closed almost sound
proof room with your
This list pays for itself once again.
Jared is charging the rest of you too, right?
Steve
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, January 24, 2002 10:46 AM
To: Multiple recipients of list ORACLE-L
Discuss Configuring Tuning Databases on the Solaris[tm]
Platform 22-28
That would be a Rectifier. Inverters change AC to DC.
Converters change the frequency of AC to AC.
--
Chris J. Guidry P.Eng. EE
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]
-Original Message-
From: Khedr, Waleed [SMTP:[EMAIL
You can count on it.
Henry
-Original Message-
Sent: Thursday, January 24, 2002 2:13 PM
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED] wrote:
JoJo --
Sure, but be aware that Unix abaci are better than NT abaci.
don't forget the VMS abaci.;-)
--
--
Bill Shrek Thater
easiest way to see the values is to do a backup controlfile to trace...
they will be there
--- Steve McClure [EMAIL PROTECTED] wrote:
Our site is preparing to fail over to our backup server. We need to
do
maintenance on our production server, and will be running on the
backup for
about 24
Hi Mohan and others,
Thank you for your compliment.
If a compiler has an option to compile or not to compile my products, I know I
could never develop a product with my typo errors. Compilers would quit after
the first attempt(joke...).
I'm developing my products
Mohan, Ross wrote:
I
Now you're really stretching it! :D
--JoJo
[EMAIL PROTECTED] wrote:
JoJo --
Sure, but be aware that Unix abaci are better than NT abaci.
don't forget the VMS abaci.;-)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: JoJo Al-Zawawi
INET: [EMAIL PROTECTED]
Fat
Lance,
Does you table load include a date field with the hh:mm:ss. If it does
not than how do you propose to find when a row was inserted. You could
use logminer and check the archivelogs if there was a crutial need to
know. I would add a column to the table that would hold a datetime stamp
and
How about this error message,
You can't modify a constant, float upstream, win an argument with the IRS,
or satisfy this compiler
--- From apple MPW C compiler (an old version)
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra
A Rectifier changes AC to DC, usually handled by a Diode
and an Inverter DC to AC.
-Original Message-
Sent: Thursday, January 24, 2002 16:10
To: Multiple recipients of list ORACLE-L
That would be a Rectifier. Inverters change AC to DC.
Converters change the frequency of AC to AC.
An easier and more accurate method would be to create a column
in the table and populate it with a sequence.
When you run your query, include in the WHERE clause
' and my_sequence_num sequence_last_time_i_checked '
You would just need to record the last sequence number
checked in a single row
Let me try again (using expand -t 3 as suggested by Jared)
# Script for analyzing Oracle Trace files with WAIT statistics
# Usage: wait_scan.awk filename
# Written:Henry Poras
# 5/16/00
# Modified: 12/3/01 Initially assumes all wait states for a cursor are
between
#
And there is documentation that comes with Oracle?
:-)
Greg
-Original Message-
Sent: Thursday, January 24, 2002 1:31 PM
To: Multiple recipients of list ORACLE-L
not everyone here has read the docs, remember? :)
--- Bellows, Bambi [EMAIL PROTECTED] wrote:
_ON_INSTALL was the
Anyone knows how to do it in Oracle8.1.7?
__
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: CC Harvest
INET: [EMAIL
I am using the following Statement: I am getting no records returned. Any
idea what is wrong?
thanks again
Lance
Select count(User_name) users
from cp_license_use
where Time_Stamp between SYSDATE and (sysdate - 30/1440)
group by Time_stamp
To grab data from the following table: SYSDATE =
Yep, so long as there was a timestamp on the records.
-Original Message-
Sent: Thursday, January 24, 2002 12:55 PM
To: Multiple recipients of list ORACLE-L
I am not sure how to ask this or if it is even possible. I have a stored
procedure that runs every five minutes and writes the
Ross,
You've got to define hum. A relay that is run off of an AC current can have
a VERY faint hum. A relay that is running on AC current when designed for DC
current has a distinctive 'hum' sometimes more similar to a high speed clicking.
Also a relay that has a coil nearing the end of
Hmmm...many (most? all?) of the answers given in the forum however, seem to
be pointers to chapters in Mr. Packer's book.
Just an observation.
:)
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
Export doesn't generate any rollback, right, so what is it supposed to
accomplish by doing this incantation?
Sorry to press the point, but could you elaborate on how that COULD
possibly make any difference for 'snapshot too old'?
For the same reason, any other transaction could end up with
Thank you Igor. But only 1 of the 14 partitions contains data during all the tests.
Why should the extra 13 empty partitions slows down the query? I also tried to drop 12
of the empty partitions. Results didn't change. -Jessica
-Original Message-
Sent: Thursday, January 24, 2002 5:37
Ooops ... Rectifiers convert AC to DC, Inverters convert DC to AC (My
wife would be lost when we go car camping without my handy Inverter!).
Guidry,
If you have a field in the data that keeps track of when it was inserted
then you could always add a line in the where to check for a 30 minute
difference. Something like :
where sysdate-time_field = 30/1440
This should get you all data 30 minutes or less old.
-Original Message-
guess I should cut and paste, huh?
Jared
Rachel Carmichael [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/24/02 05:37 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Trace/Event Info
Um Jared
Just
Select count(*) users
from cp_license_use
where Time_Stamp between SYSDATE and (sysdate - 30/1440);
should do it (no 'group by').
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 24,
I'm trying to execute a simple C program from the command prompt window.
The program is suppose to call sqlplus and update a table. The program
works on an gateway e-1400 with win2000 professional and it works on a pc
running win95. The program aborts with the following error on a gateway
I took a quick look at this paper, and found right away, that it's not very
accurate, at least in one issue.
i.e., it states :
quote
The Windows NT command COPY can be used to create a cold backup of a
database. It cannot be used to make a
hot backup. Attempting to perform a hot backup with COPY
1 - 100 of 129 matches
Mail list logo