Yes. Check your limit settings. On 4.3 we were running with defaults and no
issues, then we upgraded to 5L and had to set the limits since the defaults
were too low.
Mark...
-Original Message-
Sai Selvaganesan
Sent: Saturday, June 07, 2003 9:39 PM
To: Multiple recipients of list ORACLE-L
Hi All,
How to achieve Repeatable Read isolation level in oracle?
I mean the application should allow Phantom Read but NOT Dirty Read,Lost
Update Non-Repeatable Read
Note:-
If i choose SERIALIZABLE isolation level Phantom read is NOT allowed
if i choose Read Committed isolation
Hello All,
Can anyone help me to get details information to understand what is mean of
cost/card/bytes information out of the Explain Plan?
Regards,
Waleed Haggagy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Waleed Haggagy
INET: [EMAIL PROTECTED]
Fat City
Check out the documentation on this. Another thing you might want to
study afterwards is Martin Berg's method of Throw-away of rows that he
invented while working for me in Premium Services in Oracle.
Mogens
Waleed Haggagy wrote:
Hello All,
Can anyone help me to get details information to
--NextPartbf015f676fdbdf85872906f35cec485d
Content-Type: text/plain;
charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Mogens N=F8rgaar wrote:
Martin Berg's method of Throw-away of rows
Where can this be found?
Gudmundur
=DEessi p=F3stur var sendur me=F0 vefp=F3sti mi,
I was on a project a few years ago where we used a soundex algorithm to determine and
eliminte duplicate data.
For example we would have:
301 Fairfield Lane
301 Faerfield Lane
Notice the typo? The soundex algorithm caught it. Unfortunately I forgot to grab a
copy before I left. Everytime I do
There is a SOUNDEX sql function. Check tahiti.oracle.com for info.
HTH.
-Original Message-
Sent: Monday, June 09, 2003 8:49 AM
To: Multiple recipients of list ORACLE-L
I was on a project a few years ago where we used a soundex algorithm to
determine and eliminte duplicate data.
For
Have you checked out the Oracle SOUNDEX() function?
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, June 09, 2003 7:49 AM
To: Multiple recipients of list ORACLE-L
I was on a project a few years ago where we used a soundex
-Original Message-
THEN you should buy:
Tom Kyte's first book (one-on-one).
Jonathan's only book
James Morle's only book
Gaja's only book.
... and of course Cary's coming book.
-
AND THEN, you get that device, from the old Star Trek series, that you
yes, Im familiar with that function. but you have to write a soundex algorithm in
order to get advanced functionality. I wouldnt even know where to start with something
like that.
Im hoping there is one on the web some where.
From: Seefelt, Beth [EMAIL PROTECTED]
Date: 2003/06/09 Mon AM
Exp/imp of a 200GB database is possible, but I'd think the time required would be the
long pole in the tent. I'd say your looking at at least a 4 day weekend at best and
only if you used direct mode. Someone has hinted that you can simply move the
datafiles from one box to the other. Well
Well,
If Oracle simply adds their methods of releasing patches to PeopleSoft it will
be a win for all of those PeopleSoft administrators out there.
PeopleSoft's patch release and implementation methods are really a pain in the
___.
Dick GouletSenior Oracle DBAOracle Certified 8i DBA
You may want to review an article, Cross Platform Migration of a Large Production
Database, in
the latest issue(2nd Qtr 2003) of SELECT journal (by IOUG).
The author details the procedure he followed to migrtate a 300GB production database
from HP-UX to
IBM AIX.
- Kirti
--- Goulet, Dick
Aah !Hint, hint that some certain RDBMS vendor will offer cross-platform
compatibility of database files soon.
Hemant
At 04:14 AM 07-06-03 -0800, you wrote:
Sashidar:
In THEORY HP datafiles and Sun data files are compaible. That is you
can just move the HP data files to the Sun server and
What advanced functionality are you looking for?
-Original Message-
Sent: Monday, June 09, 2003 10:29 AM
To: Multiple recipients of list ORACLE-L
yes, Im familiar with that function. but you have to write a soundex
algorithm in order to get advanced functionality. I wouldnt even know
Maybe you can read up this...
http://tinyurl.com/du9v
Best Regards,
Ganesh R
DID : +65-6215-8413
HP : +65-9067-8474
===
Live to learn... forget... and learn again.
===
-Original Message-
[EMAIL PROTECTED]
1. Join the 10i beta program
2. Convert your 9.2 datafiles using the cross-platform transportable
tablespaces feature of a dummy 10i instance.
;-)
Or...
Back when one of our system swas at around 200M, we had a C program
that dumped table data in parallel by rowid ranges, wrote the streams
in
Direct mode doesn't work across platforms [or, at least, I haven't tried
it]. It isn't supported.
SQLLDR, Parallel Export-Import, Parallel Index Build are options -- these
can be done
in parallel. Run at least two rounds of testing to see how you can migrate
the data.
Hemant
At 06:29 AM
Nice one, John!
And quite portable. Runs on Solaris and Linux alike.
On HP-UX 11.0 I had to modify it slightly, but it
looks good too:
if [ $# -eq 1 ] ;then
UNIX95= ps -eo pid,pcpu,ruser,time,etime,args | grep
$1 | sort -nr +1 | awk '{if (NR = 20) print
substr($0,1,80)}'
else
same as above
Wondering out aloud here. Could you export/imp using
pipes. I remember doing this on a 200gb database
going from 7.3 to 8 on Solaris, granted on the same
server. Took about 4-6 hours if I remember correctly.
Anyway to create a remote pipe on another server to
listen for inputs from another
Soundex essentially takes a single word and produces a value which can be
compared to a similar value, to determine if the words are logically
equivalent, mostly by paying attention to consonants.
PROD select soundex('Fairfield') from dual
2 /
F614
1* select soundex('Faerfield') from dual
Title: International User Community
While not trying to sound like this is coming off like a shameless plug, because it isn't...
I have an Apps book going to publisher in a couple weeks and they want to do PR. To that end, they have asked me to fill out a fairly extensive paper on who might
Title: DB Link in forms6
Hi all,
Does anyone know of any bug of Oracle, which doesn't allow Database link to work properly in side a Developer 6 form?
The problem is that we have a form in which we are connected with one database and on pressing a button, want to insert data in another
Forrest,
Apologies for not getting back to u sooner.
Cloning on Nt (adv. Server) works very well when u have a SINGLE instance on each box. Also, O/S does not support multi to single clones (per the Feb 12 white paper).
Our env is1157, nt Adv srvr)runningautoconfig for cloning, via Feb 12white
one that is already written to find duplicates.
like I stated earlier. you have to write quite a bit of logic into the SOUNDEX
function to make it tell the difference between
301 Fof Lane
301 Faf Lane
From: Seefelt, Beth [EMAIL PROTECTED]
Date: 2003/06/09 Mon AM 11:04:53 EDT
To: Multiple
Mogens, Dennis,
I know I am going to catch flames for this, but here
goes:
It seems to be quite fashionable to bash statspack,
but help me out in understanding the alternatives to
the StatsPack in the following cases:
Case1:
-
At the client I am currently with, they have some 50+
Title: International User Community
IOUG?
Is that an "Iraqi Oracle User Group"? Boy, thing are developing
fast!
Mladen Gogala Oracle DBA Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-From: April Wells
[mailto:[EMAIL PROTECTED]Sent: Monday, June 09, 2003 12:04
rgaffuri,
Ok let get down to the algorithm of SOUNDEX.
As I reminisce, this is what SOUNDEX does:
A. It keeps the FIRST letter in the chain of characters and REMOVES all
vocals that follows: a, e, h, i, o, u, w and y.
B. It assigns the numbers to remaining letters as follow:
1 = b, f, p, v
I have a cust
pounding a Sun E450 I believe they
said it was with a
large RAID with fiber channels.
They pound this
thing at 2,037 I/O per seconds and
end up having about
3,868 I/O per data block wait.
This is averaged
over 3-5 days, 24 hr/day, so there
are times it's way
over that.
We have created a monster. I started with a small datamart for the finance
group. Now everyone wants their own - and of course bigger, better, faster, and
linked with all the other data to drill to anywhere. So now I get to pick out
some data warehouse tool to roll all this data together.
Forrest,
Apologies for not getting back to u sooner.
Cloning on Nt (adv. Server) works very well when u have a SINGLE instance on each box. Also, O/S does not support multi to single clones (per the Feb 12 white paper).
Our env is1157, nt Adv srvr)runningautoconfig for cloning, via Feb 12white
FWIW, we use 2048m here.
--Walt (who feels obligated to make some posts since Steve's off today) Weaver
Bozeman, Montana
-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 08, 2003 11:00 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: ???
From: "Forrest Payne" <[EMAIL PROTECTED]> Date: Fri, 6 Jun 2003 09:32:26 -0700 Subject: Re: How to Uninstall apps1Forrest,
I had a 'few' emails on this so I'll list the steps here. Please note these are for our env (1157, NT Adv Srvr).We usea DR drive (operating system with ALL needed 3rd party
bell ;
Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extension 8487
-Original Message-
Sent: Saturday, June 07, 2003 11:44 PM
To: Multiple recipients of list ORACLE-L
Good morning,
This a question for Oracle form and report
I want to add a beep or sound to a form when a
Hi April,
There is TOUG - Toronto Oracle Users Group.
Thanks,
Shamita "Gogala, Mladen" [EMAIL PROTECTED] wrote:
IOUG? Is that an "Iraqi Oracle User Group"? Boy, thing are developing fast!
Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED]
-Original Message-From:
You can specify the name of a macro for msaccess to run on startup w/the /x
parameter of the msaccess executable. That macro can do a RunCode action to
run a VBA procedure that you specify (which is where you can do your data
loading) followed by an Exit action to shut down msaccess. IIRC, you
I know it is late but:
Since nobody mention it - upload the report to http://www.oraperf.com/ and you will get a report with explanation
and recommendations.
Yechiel AdarMehish
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
I thought the .Prepared property of the command object was what you needed
to use bind vars from ADO.
Have a look at the following code, adapted from the ADO help entry for
.Prepared. It purports to compare response times for prepared unprepared
versions of the same SQL command. In the
Oracle doesn't support repeatable read isolation level. Only
read committed and serializable.
-Original Message-
Sent: Monday, June 09, 2003 3:55 AM
To: Multiple recipients of list ORACLE-L
Hi All,
How to achieve Repeatable Read isolation level in oracle?
I mean the application
April,
I know IEEE has been trying to increase their influence in the computer
world. They've been trying to get me to join for the past few years and
have added computer publications to their list.
Worth a shot.
Good luck
Stephen
[EMAIL PROTECTED] 06/09/03 09:04AM
While not trying to
If you price the Dell servers, I think you will find there is little price
advantage over a comparable (sort of) Sun 8-CPU box -- for example, Sun Fire
V880. If the Sun 450 of which you speak is a few years old, then changing
to almost any platform will get you CPU's that are a heck of a lot
Title: International User Community
I
thought Iran registered it first.
-Original Message-From: Gogala, Mladen
[mailto:[EMAIL PROTECTED]Sent: Monday, June 09, 2003 12:35
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
International User Community
IOUG? Is that an
Hi listers...
I have a question related to triggers. One of the developers here has created two triggers as follows :
Trigger #1 is an AFTER UPDATE trigger on TABLE-A
- the trigger has PL/SQL code including an UPDATE dml statement on TABLE-B.COL-2
Trigger #2 is an AFTER UPDATE trigger on
Store the soundex version of the word you are interested in, then create a
unique index on that column. Consider a function-based index based on the
soundex function. If each row potentially contains a variable number of
words of interest, you could create a child table. The possibilities are
Title: Message
I would start by checking out Oracle
Warehouse Builder (OWB) which is supposed to be bundled with Oracle 9iDS. So the
price is right (ie, "free") if you already use 9iDS. Plus, its architecture is
built around Oracle's (PL/SQL procedures; use of AQ; etc)
If that doesn't work,
Title: International User Community
When I worked for Oracle back in 1998-99
Oracle had an office in the capitol of Iraq as I recall.
Ken Janusz, CPIM
- Original Message -
From:
Richard
Ji
To: Multiple recipients of list ORACLE-L
Sent: Monday, June 09, 2003 12:50
Title: Message
Were'nt US companies
forbidden to do business with Iraq in 98-99?
-Original Message-From: KENNETH JANUSZ
[mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 3:10
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
International User Community
When I worked for
Try the Levenshtein Distance algorithm. If you scroll to the bottom of the
page you will see a PL/SQL implementation.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
yes, Im familiar with that function. but you have to write a
soundex algorithm in order to get
There's just not enough performance info here to go on. If the service
times for the storage are high, simply improving the back-end storage
(faster drives, more spindles, more cache, etc.) could solve the
problem.
As far as Solaris vs. Linux cost, its definitely true that a Linux
server
Oops, I meant an 'instead of' trigger on a view.
Jared
Jared Still [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/07/2003 07:14 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Oracle's use of
Carol,
I see
two possible issues here:
1). Is the COL-2 value changing either from/to a
null value? if so, then the WHEN clause is incorrect and the Table B
trigger will not fire at all. In other words, if COL-2's before or after
value is a NULL, then the trigger will not fire. You should
You might consider an interMedia Text index on the column(s) of interest.
The interMedia Fuzzy Search and scoring functionality (and others) may
prove more flexible than Soundex.
Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715 (wk)
This is *exactly* what I would like to do on our
SAP systems when we upgrade, since this is the
best way to move to LMT's.
Unfortunately for me and a lot of other folks, Windoze
don't do that. :(
You can't imagine just how much I wish we were on Solaris.
Jared
Kirtikumar Deshpande
I guess a link would help.
http://www.merriampark.com/ld.htm
-Original Message-
From: Jacques Kilchoer
Try the Levenshtein Distance algorithm. If you scroll to the
bottom of the page you will see a PL/SQL implementation.
-Original Message-
From: [EMAIL PROTECTED]
Los Angeles (California, USA) Oracle user's group: http://www.laoug.org/
Orange County (California, USA) Oracle user's group: http://www.ocoug.org/
I would think that the IOUG would be able to send you a list of all the
Oracle user groups.
-Original Message-
While not trying to sound
Carol,
As long as the triggers aren't declared as autonomous transactions, they'll
see all the previous changes that the session made.
Are the two columns in the where condition maybe two date columns loaded
with different times?, or is one a varchar and the other a char so that the
comparison
Okay ... unless old.table2.col_1 = new.table2.col_2 the trigger won't
fire.
I don't see anything wrong here
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly
I would agree there is not much to go on, and I admit I am leary to jump on
the migrate to Linux bandwagon. True you can get dirt cheap hardware to run
your Linux install, but then you are running a very solid OS on dirt cheap
hardware. Performance will suffer unless you purchase really top
You have to watch out for those who think RAC is a synonymous with RAIB
(Redundant Array of Inexpensive Boxes). It ain't.
-Original Message-
I feel like I should have started this response Hello my
name is Steve
McClure and I am a RAC on Linux doubter Really I have felt
this way
Thanks for the responses so far...
The transactions weren't declaraed as autonomous, so I, too, expect what you suggest.
The two columns in question are of the same datatype -- numeric.
This is a strange one.
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/09/2003 04:14 PM
Please
And of course the world-famous Oracle User Group Denmark (OUGDK) :-))).
Shamita Singh wrote:
Hi April,
There is TOUG - Toronto Oracle Users Group.
Thanks,
Shamita
"Gogala, Mladen" [EMAIL PROTECTED] wrote:
IOUG? Is that an "Iraqi Oracle User
Steve,
You hit the nail on the head with RAC licensing. Oracle is currently
offering discounts on RAC, likely due to that reason.
Look for an article on this subject by Mogens Norgaard in the
upcoming issue of SELECT.
Interestingly enough, RAC for Oracle Collaboration Server is a
mere $60 per
Good one. The I in RAID started out as Inexpensive, but is now
Independend - for obvious reasons :-).
Just had a DML-heavy customer in an exotic country who saw 45% scaling
on the third Linux node, and 0% when adding the fourth. 50% of time
spent enqueue'ing. Yes, it's probably an application
Who knows? I know for at fact that Oracle UK sold Oracle 5 to Ghadaffi
(or however his name is spelled) back in the 80's. They also had a lively
trade with South Africa - known back then as "South England"... rumor has
it, though, that - due to stuff happening high over Lockerbie - Oracle UK
Fyi,
Note I was referring to the other day.
04:11 PM PST
Please respond to [EMAIL PROTECTED]
Sent by:[EMAIL PROTECTED]
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
At 02:16 PM 5/19/2003 -0800, you wrote:
Adding the initial clause appears to work fine.
Good points, Boris. Thanks for that.
If all users are doing the same things, then I guess system-wide data could
indicate what's wrong for the average user. You can also use system-wide
data to see if something changes overall on the system, then try to dig deeper
- but only if you are very
Interestingly enough, RAC for Oracle Collaboration Server is a
mere $60 per user, significantly less than normal RAC licensing.
$60 per user...lets see Oracle claims we have 80,000 users...(not including
the infinite internet users)...So that may not apply to us CPU licensers, I
am guessing most
Very
interesting. I will start a virtual campfire.
-Original Message-From: Mogens Nørgaard
[mailto:[EMAIL PROTECTED]Sent: Monday, June 09, 2003 5:15
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
International User CommunityWho knows? I know for at fact
that
I just got this question put to me and I didn't know the answer. For the
most part I have always supported applications running commercial software
such as ERP systems. In these cases it is clear that a license is required
for Production and Development servers. But let's say the following
Oracle Collaboration Server (Suite?) is licensed per-mailbox user, not
by logged-in user, like the database. So, you can run the database
powering OCS on as big a machine as you want, as long as you're paying
your $60/mailbox.
Thanks,
Matt
--
Matthew Zito
GridApp Systems
Email: [EMAIL
I used the following program to learn bind variables and ref cursor
long time ago. This might help. Put this code into a file called
getstaff.sql and then run it. Bottom lines show how to declare a cursor
and pass it to a procedure using SQL.
HTH
Mohammed Shakir
--
rem filename
This is what the book (page 196 Oracle SQL High-Performance Tuning -
Second Edition, Guy Harrison.) says about your situation.
INLIST ITERATOR step indicates that each subsequent step was executed
once for each value in an IN list.
A large number of elements in the IN list can be time consuming,
It is nice to have good tools to find what and how want quickly.
I simply use statspack to find out my most time consuming SQL. To me
SQL is SQL. Whether I execute it using SQL prompt, or it comes from one
of my PL/SQL procedures.
What I look for it is, how many time I am executing each sql, how
What you need is detailed information over time. Start with SQL
statements, into sessions, into the instance level. The problem is that
this means that tons of data will be collected. So one has to be clever
and reduce the amount of data collected. If you have data over time
(SQL, session,
Ah much more reasonable. I can't believe I typed the word licensers -- I
am guessing licensees was what I was going for
Steve McClure
Oracle Collaboration Server (Suite?) is licensed per-mailbox user
$60 per user...lets see Oracle claims we have 80,000
users...(not including the infinite
Also look at Association of Information Technology Professionals (AITP) formerly
DPMA.
April Wells wrote:
International User Community
While not trying to sound like this is coming off like
a shameless plug, because it isn't...
I have an Apps book going to publisher
Last year in May I had a chance to develop back-end software using
ASP.NET with SQL Server and Oracle. Microsoft did an excellent job
integrating SQL Server with ASP.NET. However, not such a good job with
Oracle. I had to create stored procedure manually if I wanted to use
Oracle.
My main problem
A 4WD will get you much
further into the swamp before you're stuck. But stuck you will be sooner
or later.
I thought that Anette had a GPS systems in her car ;-)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Anjo Kolk
INET: [EMAIL PROTECTED]
Fat City Network
Hi!!
I was working with SQL Server 2000, and now the company decided to change
to Oracle. So I don't know much about Oracle, I am just reading a book and try
to find information on the net.
I am trying to do the next query, but I guess Oracle did not have the
function TOP. How can I do a TOP
You are right, Oracle does not have the functionality built in. You can use
an inline view to accomplish the same thing.
select ictrans1.item, ictrans1.trans_date
from (select rownum i_rownum,
ITEM,
TRANS_DATE
from ICTRANS
where(COMPANY = 2000)
AND (TRANS_DATE
Your english is fine, lets see if I understand the query...
Does it return the Item and Trans_Date of the record with the smallest
quantity (ie: first row returned given that query is ordered by quantity)?
Oracle (at least version 8 - not sure about 9) doesn't really support this
SQL but there
OOPS! Mea Culpa!
I improperly used rownum in the query. The previous reply from Mark is
correct. However, the info on my website is correct.
Daniel W. Fink
http://www.optimaldba.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Daniel W. Fink
INET: [EMAIL
Yes, and it allows her to find her way home - but only after someone has
dragged her car out of the swamp.
Anjo Kolk wrote:
A 4WD will get you much
further into the swamp before you're stuck. But stuck you will be sooner
or later.
I thought that Anette had a GPS systems in
83 matches
Mail list logo