Jun,
Wolfgang is correct, and it is covered in Jeff's document. It's the third
point (with example) listed at the bottom of page 1.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic 101, Mar 25-27 Oxford
- Hotsos Clinic 101, Apr 8-10 Chicago
I need to buy a new Oracle license for 50 users. I have got two different
quotes for Oracle Enterprise Server and Oracle Standard; it seems the former
is quite expensive. What problems will I get if I buy the cheaper Standard
version. This Oracle will be used for BAAN ERP implementation. The
Paula,
I am currently having problems where we have 32 bit Oracle (8.1.7.4) backing up to
networker successfully via RMAN.
However 64 bit Oracle (9.2) will not work against the same networker installation
ORA-27211: Failed to load Media Management Library
See note 209590.1 on Metalink for more
Hi everybody
Oracle 9.2.0.1.0 on Win2k SP2. Issuing the following statement via JDBC thin
driver connection leads to
ORA-00600: Interner Fehlercode, Argumente: [ttcgcshnd-1], [0], [], [], [],
[], [], []
Statement is:
SELECT
alias0.ENT_ID,
alias0.ENT_OID,
alias0.ENT_CREATE_USER,
Well said Kirti -
Darell, you wil fail every OCP exam you take with 50%. You need a minimum of about
65% and up to 75% on others (don't know why they vary so much)
John
-Original Message-
Sent: 12 March 2003 13:59
To: Multiple recipients of list ORACLE-L
You only need to get 50% of
Stefan ,
hope you don't have the right version of classes12.zip in your classpath.
if it is not so , u r likely to get ORA-600 even on a simple SELECT.
just set that right.
HTH.
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL
Hello Tapiwanashe,
Oracle Standard edition does not support some operations (error
message: this feature is not enabled).
For example:
Fine grained access control, online index rebuild etc.
Thursday, March 13, 2003, 2:43:52 PM, you wrote:
ZT I need to buy a new Oracle license for 50 users. I
Not like this nor should it be the top event always as seems to be the
case here I don't believe. And, I know for certain that the client did
everything as quickly as possible during the trace. Minimal data entry done
and OK buttons clicked without delay...no time out for getting a cup of
coffee
Sergey,
after, you can upgrade from standard to enterprise.
--
Breno A. K. Magnagomailto:[EMAIL PROTECTED]
Mercantil de Alimentos Soares
Thursday, March 13, 2003, 7:19:03 AM, you wrote:
SVD Hello Tapiwanashe,
SVD Oracle Standard edition does not support some
Purely a guess, but looking at the figures
do you think that Oracle is using readv for
values up to 128K, and pread for values
larger than 128K ?
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Now available One-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
I'm not sure if this is the default or standard location, but one file of importance
on HP is /var/adm/syslog/syslog.log.
Darrell
[EMAIL PROTECTED] 03/13/03 12:58AM
I monitor /var/messages on my Sun boxes, does HP-UX have anytype of OS log
files worth monitoring?
Thanks,
Ethan
--
Please see
Hi SQL Developers,
I have a table as follows:
Col1 Col2
AB
CD
EF
GH
BA
EF
CD
HG
With a PK on (Col1, Col2).
How do I write a SQL script to get following result?
Col1Col2
AB
B
Brian,
to avoid the problem, you need to build the database the correct way.
proper planning avoids the issue.
I've always build the database on paper first (getting disk sizings and
assigning tablespace files to them while watching disk usage). Building a
speadsheet helps tremendously. And
John,
Just to clarify, that wasn't me that said you only need to get 50 % correct on the 9i
upgrade exam. This thread looks like it, but my message follows:
From: Darrell Landrum [EMAIL PROTECTED]
Thanks,
Darrell
[EMAIL PROTECTED] 03/13/03 03:23AM
Well said Kirti -
Darell, you wil fail
Ethan,
Check /var/adm/syslog/syslog.log
- Kirti
-Original Message-
Sent: Thursday, March 13, 2003 12:59 AM
To: Multiple recipients of list ORACLE-L
I monitor /var/messages on my Sun boxes, does HP-UX have anytype of OS log
files worth monitoring?
Thanks,
Ethan
--
Please see the
But if one user spawns 10 sessions, then whilst
one session is being 'clicked' the other 9 are idle -
no matter how fast the user is being bounced from
one to the next - so on average every session is
going to be waiting for SQL*Net message from client
90% of the time.
Regards
Jonathan
Kirti,
I think, you have typo (duplicate rows), when describing data inserted into
table, considering PK on (col1, col2).
Shouldn't it be:
SQLWKS create table test(
2 col1 varchar2(10),
3 col2 varchar2(10),
4 constraint PK_TEST primary key (col1, col2));
Statement processed.
This document (which isn't always easy to find) compares the two:
http://otn.oracle.com/products/oracle9i/pdf/o9i_family_features.pdf
Jay Hostetter
Oracle DBA
D. E. Communications
Ephrata, PA USA
[EMAIL PROTECTED] 03/13/03 03:43AM
I need to buy a new Oracle license for 50 users. I have
Looks like I have a need write a Perl program to access a database.
Any suggestions on a good book.
Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional
Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216)
781-4204
Title: RE: POLL: Database to DBA ratio
In our
environment, each DBA supports a certain number of databasesthat are
his/her 'primary' databases (all the way from Test/Dev/Accept/Production). The
same person is 'secondary' or 'tertiary' for others.We follow a
standardizedsetup (somewhat
Zhou - Ask your vendor, BAAN. Do they require Enterprise? If not buy
Standard. You can examine the list of features that Enterprise offers to see
if you feel you will be missing something essential. The following document
has a list of features for each version.
Kirti - I haven't had enough coffee this morning, so it seems to me the
obvious solution is an order by clause. What am I missing here?
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
SQL select * from test;
C C
- -
A B
C D
E F
G H
B A
F E
D C
H G
8 rows selected.
Title: RE: A SQL Question
SELECT table.Col1, table.Col2
FROM table
UNION
SELECT table.Col2, table.Col1
FROM table
ORDER BY table.Col1;
Actually you might not even need the ORDER BY
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
I remember seeing someone mention the event number to tracing a session to
capture fine grained access control activity. Does anyone remember!
Thanks
Murali Vallath
_
Add photos to your messages with MSN 8. Get 2 months
Hi Kirti,
Just a clarification:
PK on col1, col2 but you have duplicates C,D and E,F.
If the dups are removed, is the porblem still valid?
mohammed
--- Deshpande, Kirti [EMAIL PROTECTED]
wrote:
Hi SQL Developers,
I have a table as follows:
Col1 Col2
AB
C
We are study on our next ORACLE servers. Before we
can commit the management that SUN/ORACLE server is
the best choice, I need get some benchmarks info to
compare SUN with other systems (NT, LINUX, ..). Does
anyone have information like that? If you have
Benchmark info. include SUN/ORACLE
Just checked it:
localhost.localdomain:rholman:/home/rholman$ mt
usage: mt [-v] [--version] [-h] [ -f device ] command [ count ]
localhost.localdomain:rholman:/home/rholman$
This is my desktop which is RedHat 7.3. Looks as though mt is still
there.
Rodd
On Wed, 2003-03-12 at 18:53, Chuck
Do you
know if this book covers the Perl basics or does it assume you know Perl
Already. "Larry Hahn" [EMAIL PROTECTED]
3/13/03 9:39:02 AM
Jeffrey,
I am emailing you
direct because my reply to the list is not going through.
I have heard a lot
about the following book:Perl for
Hi SQL Developers,
I have a table as follows:
Col1 Col2
AB
CD
EF
GH
BA
EF
CD
HG
With a PK on (Col1, Col2).
How do I write a SQL script to get following
result?
Col1Col2
AB
B
Title: RE: A SQL Question
Kirti,
It's impossible to have a primary key as you have duplicate values. C-D and E-F both have dupes. If there should be D-C and F-E, a simple Order By Col1 would do the trick.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
Title: Message
Jeffrey,
A pretty good reference is:
Programming the Perl DBI by Descartes
Bunce (O'Reilly Associates)
It has been very helpful to me!
Cheers!
Bill
Bill TantzenUniversity of Minnesota
Libraries[EMAIL PROTECTED]612-626-9949 (office) 612-250-6125
I messed up typing the data for the table. It has no dups.
The second occurrence of C, D and E, F should actually be D, C and F, E.
Sorry about that...
Need more hot tea to wake me up !!
- Kirti
-Original Message-
From: Deshpande, Kirti
Sent: Thursday, March 13, 2003
Hi Kirti,
This isn't possible. The primary key won't allow for the duplicate values.
There are 2 records of C,D and 2 records of E,F.
Darrell
[EMAIL PROTECTED] 03/13/03 07:23AM
Hi SQL Developers,
I have a table as follows:
Col1 Col2
AB
CD
EF
G
Assuming dups can be deleted, here's my humble
attempt:
select col1, col2
from t
order by col1, col2;
Col1 Col2
--
AB
BA
CD
EF
GH
HG
6 rows selected.
select col1, col2
from t
union
select col2, col1
from t
;
Col1 Col2
--
AB
BA
CD
DC
EF
F
Kirti,
I tried to reply to your direct e-mail, but your mail-server is very strict
and considered my message to be Unsolicited Bulk Email.
What I was trying to say is:
Oracle-l list behaves very strangely (sometimes), I'm still waiting to see
corrected
version of your question.
And actually I
Stephen, Dick,
SQL keywords are not localized, they stay English, as they are described
in SQL standard (or Oracle's adaptation of it).
What changes, is Oracle messages (i.e. error messages) - based on the
language you select when installing Oracle software.
Choosing character set (when creating
Depends on what you consider to be 'real' production issues. We get pages
for production and development, for things that really should be planned
change control, for idiot user stuff, as well as the regular db/listener
down, ora-0600 and the other standard stuff.
With most of the applications
Title: RE: Is Anybody Out There - Pink Floyd
Yes the Oracle libs have to be linked to the correct - bit networker lib on the same machine but I was curious about when the catalog is in a different bit using diff. bit networker on a target db.
-Original Message-
From: Hallas, John,
Jeffrey,
Jared is a member (and owner of) this list - why not shoot him a message?
I'm sure he wouldn't mind ;)
[EMAIL PROTECTED]
Mark
-Original Message-
Beckstrom
Sent: 13 March 2003 14:59
To: Multiple recipients of list ORACLE-L
Do you know if this book covers the Perl basics or
Jared Still, the list owner, has one out:
Perl for Oracle DBAs from O'Reilly press
--- Jeffrey Beckstrom [EMAIL PROTECTED] wrote:
Looks like I have a need write a Perl program to access a database.
Any suggestions on a good book.
Jeffrey Beckstrom
Database Administrator
Greater
I use sys.dbms_system.set_ev( v_seid ,v_sernum ,10046,12 ,'') to start
tracing on 8.1.6 db . What should I do to stop tracing without exiting out
of session .
Thanks,
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 9:07
Kirti,
Would not and order by col1,col2 give the resulting set you want?
Is the data shown correct? you have C,D twice. I think you ment C,D and
D,C.
Ron
[EMAIL PROTECTED] 03/13/03 08:23AM
Hi SQL Developers,
I have a table as follows:
Col1 Col2
AB
CD
E
Dear listers,
I'm hunting for top LIO consumers to give a relief to our DB cpu and found
something that looks interesting.
Many plain good queries show up way to high cr when executed in concurrent
environment (50 threads) while perform as predicted when executed from
SQL*PLUS.
The example
Kirti,
is this a trick question, or am I missing something?
select col1, col2
from table
order by col1
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, March 13, 2003 8:24 AM
To: Multiple recipients of list ORACLE-L
Hi SQL Developers,
I have a
Two methods that come to mind are:
1. ps command. See man page for options on your system.
2. If top has been installed on your system and made executable by
non-root users.
If you have root privilege, and some programming skill, and this is Sys
Five-ish (SVR4 ... more or less), you can read
Will 'ORDER BY col1' not do?? ;-) Atleast in this example it does.
What are exact requirements?
Regards
Naveen
-Original Message-
Sent: Thursday, March 13, 2003 6:54 PM
To: Multiple recipients of list ORACLE-L
Hi SQL Developers,
I have a table as follows:
Col1 Col2
Mike
Just ask your Sun salesperson to provide that information ;-)
There are many complex variables involved. Which models, how much memory,
what storage configuration, etc. If your management doesn't realize that . .
. well. How much reliability does this site require?
Dennis Williams
DBA,
'Programming the Perl DBI'. The DBI and DBD::Oracle man pages/perldoc is
probably sufficient for basic (unoptimized) stuff. There's multiple
tutorials on the web, as well. Check dbi.perl.org
The book is not a tutorial for Perl, but the first chapter includes
What is Perl?, so not *too* much is assumed.
The appendices are very good for beginners. containing four
'Essential Guides' to Perl.
Jared
On Thursday 13 March 2003 06:54, Jeffrey Beckstrom wrote:
Do you know if this book
/var/adm/syslog/syslog.log is the hp-ux equivelant.
-Original Message-
Sent: Thursday, March 13, 2003 12:59 AM
To: Multiple recipients of list ORACLE-L
I monitor /var/messages on my Sun boxes, does HP-UX have anytype of OS
log files worth monitoring?
Thanks,
Ethan
--
Please see the
also how can we check if one particular session is being traced (10046 ) or
not . Basically I want to be sure that tracing is stopped for the session
and its not fillling up disk space .
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
Igor (and all):
Yes, our SPAM Cops and their filters are very strict with the wording in the e-mail
footers.
Unfortunately, FatCity.com uses the footer that gets caught by these filters.
When replying to me directly, using list message, you need to remove the old footers
from the e-mail.
Select * from my_table order by col1;
-Original Message-
Sent: Thursday, March 13, 2003 7:24 AM
To: Multiple recipients of list ORACLE-L
Hi SQL Developers,
I have a table as follows:
Col1 Col2
AB
CD
EF
GH
BA
EF
C
Hi JP
With the newest drivers (ojdbc14.jar) for 9.2 it works.
Thanks a lot.
Regards
Stefan
Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298
Fax: +49 201 - 4513-149
mailto: [EMAIL PROTECTED]
Please remove nospam to contact me via email.
visit our website:
Good point, but what if each user only has a single session?
Not that I've noticed this exact same situation here on one of our
Engineering support databases whose clients are Java, and I'm not wondering
if it has something to do with the application or if I can possibly speed it
up with tweaks
Okay, let me do this right this time,... (Now that I have my hot tea going;)
Here is the test data:
SQL select c1,c2 from cp;
C1 C2
--- ---
AUS DAL
AUS HOU
DAL AUS
DAL HOU
DAL LIT
DAL XYZ
HOU AUS
HOU DAL
HOU LIT
HOU XYZ
LIT DAL
C1 C2
--- ---
LIT HOU
XYZ DAL
XYZ HOU
14 rows selected.
SQL
Is there any hint from oracle support on these new offerings:
Raleigh, NC -- March 12, 2003 -- Red Hat, Inc. (Nasdaq:RHAT), the
world's premier open source and Linux provider, announced the
availability of two new enterprise offerings: Red Hat Enterprise Linux
ES and Red Hat Enterprise Linux WS.
Title: Re: A SQL Question
SQL select A.c1, B.c2
2 from (select col1 c1, rownum r from tbl order by col1) A
3 , (select col2 c2, rownum r from tbl order by col2) b
4 where a.r = b.r
5 union all
6 select B.c2, A.c1
7 from (select col1 c1, rownum r from tbl order by col1) A
8 , (select
since we're having fun with SQL today - here's one that's hurting my brain
at the moment. I need to sum columns at 2 different groupings in my
resultset. The first select is perfect; the 2nd is where i have trouble;
but i know i can do stuff like the 3rd example. How do I get the 2nd one to
sys.dbms_system.set_ev( v_seid ,v_sernum ,10046, 0,'')
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 10:49 AM
I use sys.dbms_system.set_ev( v_seid ,v_sernum ,10046,12 ,'') to
How automatic do you need this? One way of doing it is to use ldapsearch to
extract the data you need from LDAP, convert the output into a
single-line-per-user CSV using Perl (not Korn, not Python, not C -- JUST
PERL!), and use SQL*Loader to pipe it into the DB. Something that could be
run daily
Title: RE: OTC: Perl Book
Perl for Oracle DBAs is a good one. I picked one up at RMOUG.
It's so good I've put down the Harry Potter book I was reading.
--Walt Weaver
Bozeman, Montana
-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March
I can think of three reasons:
1) You are binding with the wrong datatype and you are getting a full table
access for the SELECT and then
the rowid is remembered for the FOR UPDATE (results in 1 current get).
2) You are implicitly using array fetch in sqlplus, so the number of cr gets
will be
Okay, let me do this right this time,... (Now that I have my hot tea going;)
Here is the test data:
SQL select c1,c2 from cp;
C1 C2
--- ---
AUS DAL
AUS HOU
DAL AUS
DAL HOU
DAL LIT
DAL XYZ
HOU AUS
HOU DAL
HOU LIT
HOU XYZ
LIT DAL
C1 C2
--- ---
LIT HOU
XYZ DAL
XYZ HOU
14 rows selected.
SQL
I have heard some raving reviews for the
book
Perl for Oracle DBAs
By AndyDuncan,JaredStillAugust
2002 0-596-00210-6, Order Number: 2106
[Jack van
Zanen]
-Original
Message-From: Jeffrey Beckstrom
[mailto:[EMAIL PROTECTED]Sent: donderdag 13 maart 2003
15:04To: Multiple
Title: RE: Excessive SQL*Net message from client waits
This is an idle wait event that just means the server is waiting to be given some work from the client. Looks to me like you won't be needing to do any tuning on this database.
-Original Message-
From: Karen Morton [mailto:[EMAIL
Hi,
Our app is strange. :-( We use pl/sql(9i) package to
create all the html and java script. I have two drop
down boxes on a form, the values for the second box
changes dynamically depends on the value of the first
box. The values for the boxes are from cursors
written in pl/sql. We
/dev does not have an async directory, async IO is turned on in the
database, how do I determine if async IO is activated on the OS side of the
house? Is the missing async directory an indicator?
Also, is the database smart enough to figure out that the OS is not using
async and make correct
Do you know if this book covers the Perl basics or does it assume you know Perl
Already.
Larry Hahn [EMAIL PROTECTED] 3/13/03 9:39:02 AM
st1\:*{behavior:url(#default#ieooui) }Jeffrey, I am emailing you direct because my
reply to the list is not going through. I have heard a lot about the
Sam,
I've never worked in a DCE environment, but here's a
couple of
things toverify:
1. If libdce.a is not installed in the first place, is your
environment
using DCE? I think this is an LPP (a separately licensed
product)
from IBM for AIX. Try the following from a unix prompt:
$ lslpp -L
I think its easier if you do it cross-tab
AUS DAL DAL AUS
Is that acceptable?
Or just select
AUS DAL
If it also has a DAL AUS
Are either of those metods acceptable? If so, pick one and Ill show you how to do it.
From: Deshpande, Kirti [EMAIL PROTECTED]
Date: 2003/03/13 Thu AM 11:19:15
If you can check it in real time, you will probably
find that you have a very large number of CR copies
of the few blocks that are the focus of the concurrent
activity.
The excess time is likely to be down to a mixture
of CPU as Oracle trawls through the chain looking
for the correct copy, and
Title: Re: Corrected SQL Question...
SQL select A.c1, B.c2
2 from (select col1 c1, rownum r from tbl order by col1) A
3 , (select col2 c2, rownum r from tbl order by col2) b
4 where a.r = b.r
5 union
6 select B.c2, A.c1
7 from (select col1 c1, rownum r from tbl order by col1) A
8 ,
Murali:
It is event 10730. You can set that at session level.
=
Have a nice day !!
Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: K Gopalakrishnan
How about truss/strace equivalent on HP-UX on dbwr
to see whether its using AIO or not. If AIO fails
then it will follow by a normal IO call.
Richard
-Original Message-
Sent: Thursday, March 13, 2003 8:44 AM
To: Multiple recipients of list ORACLE-L
/dev does not have an async
sys.dbms_system.set_ev( v_seid, v_sernum, 10046, 0, '' )
^
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic 101, Mar 25-27 Oxford
- Hotsos Clinic 101, Apr 8-10 Chicago
-Original Message-
I think those solutions should be acceptable.
Not sure if they are displaying any more information from the table. I was just given
the test table to get the SQL script working
Thanks a lot.
- Kirti
-Original Message-
Sent: Thursday, March 13, 2003 11:04 AM
To: Multiple
Title: RE: fgac tracing
http://www.oracleadvice.com/Tips/FGAC.htm
Event 10730 (trace row level security policy predicates) can be used to dump the rewritten SQL to a trace file in the user_dump_dest. Be aware that this only happens when the cursor is reparsed. Oracle does not reparse cursors
Repeat but changing the 12 to a zero should work.
You will find, however, that any cursor that has
not closed when you stop tracing will not dump
its 'STAT' lines (including execution plan) to the
trace file.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Now available One-day
I'd start by being doubtful about anybody
being able to work so fast that the can avoid
a high percentage of time in 'sql*net from client' -
in fact, it the percentage was low (when the
client was a person at a terminal) I would
write myself a memo to check whether the
client code was executing
Anyone using BMC's DBXRay? Is it a decent product?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Suzy Vordos
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
There is the website of www.tpc.org
HOWEVER (AHA!!), you should be warned that Microsoft will *ALWAYS* spend the
necessary cash to put together a big enough cluster to get the highest
score. So, I can tell you, without looking at the site for months now, that
Microsoft will have the highest
Kirti,
Can you explain the required result order? It looks random to me - or like
one of the tests we were forced to take in High School.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, March 13, 2003 9:31 AM
To: Multiple recipients of list ORACLE-L
Tom,
They wanted to 'pair up' the contents from c1 and c2.
Those are supposed to be 3 char Airport codes. DAL-AUS followed by AUS-DAL (or
vice-versa).
That's all I was told.
Thanks.
- Kirti
-Original Message-
Sent: Thursday, March 13, 2003 11:55 AM
To: Multiple recipients of list
http://www.oreilly.com/catalog/oracleperl/
Play your cards right and you may even get
an autographed copy. ;o)
Dave
-Original Message-From: Jeffrey Beckstrom
[mailto:[EMAIL PROTECTED]Sent: Thursday, March 13, 2003 8:04
AMTo: Multiple recipients of list ORACLE-LSubject: OTC:
Not quite random. Note that the value is field 1 of the first record is
the value in field 2 in the second. It looks like they want to pair up the
cities if they appear in both columns.
i.e. Since Dallas is in column 1 with Austin in Column 2 in one record,
and Dallas is in Column 2 with
Ethan -
it has been a while and we don't have an HP-UX box here, but if memory
serves the missing /dev/async is a dead giveaway that your not using async
io.
to use async io on HP-UX we had to install something called the asyncdisk
driver in SAM and then use mknod to create /dev/async
Hi...
I would like to receive a bit of your help (I've been
looking at Metalink with no luck).
I'm having a sql*loader problem when I try to insert
records in a table field.
The problem is:
my data file has a column with MORE THAN 255
characters long, and sql*loader rejects the records
that
Janet,
Try the forums at http://java.sun.com or inquire at http://devtrends.oracle.com
Darrell
[EMAIL PROTECTED] 03/13/03 10:59AM
Hi,
Our app is strange. :-( We use pl/sql(9i) package to
create all the html and java script. I have two drop
down boxes on a form, the values for the second
Thanks Wolfgang, Cary for taking the time to answer my first question. After
taking a second look on the hotsos doc, it did in fact address my problem,
specifically the third bullet point. I simply missed to apply the pattern,
shown in the example for the third point, to my situation.
As for
Thank you, Jonathan,
I'll continue looking for my options to cool down the hot spots. Not sure if
I can go for partitioning since Oracle charges $$$.
Is it correct that oracle counts looking through the chain
for the correct copy as many CR? Or the reason for these extra CR is access
to undo
Title: RE: Corrected SQL Question...
(see answer below)
-Original Message-
From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
Here is the test data:
SQL select c1,c2 from cp;
C1 C2
--- ---
AUS DAL
AUS HOU
DAL AUS
DAL HOU
DAL LIT
DAL XYZ
HOU AUS
HOU DAL
HOU LIT
Thank you, Anjo.
I want to provide more information about this case:
- In both cases binding is inside PL/SQL block, bind variable type is
correct.
this must eliminate reasons 1 and 2
- different bind variables - yes, almost for sure they are different, but
this is PK, must make no
Do mean something like this? It would be interesting to see if this could
be done with some kind of tree walk.
1* select a.c1, a.c2, b.c1, b.c2 from crap a, crap b where a.c2 = b.c1 and
b.c2 = a.c1
SQL /
C1C2C1C2
- - - -
DAL AUS AUS DAL
HOU AUS AUS HOU
Title: RE: Corrected SQL Question...
Jacques,
Thanks a bunch.
Elegance was not one of the requirements ;)
Cheers!
-
Kirti
-Original Message-From: Jacques Kilchoer
[mailto:[EMAIL PROTECTED]Sent: Thursday, March 13, 2003
12:53 PMTo: '[EMAIL PROTECTED]'Cc: Deshpande,
Murali,
Perusing the oraus.msg file it appears that the 10730 event will do what
you want.
There are a lot of interesting events in there. :)
Jared
Murali Vallath [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
03/13/2003 06:39 AM
Please respond to ORACLE-L
To: Multiple
ok - i came up with a solution. but in real life i have a lot of amount1's
in t1 so it becomes an ugly brute force looking query. anybody have a more
elegant solution?
1 select a.category
2 , (select sum(s.amount1) from t1 s where a.category = s.category)
as amount1sum
3 ,
I would expect the pread64() calls to map to db file sequential read and
the readv() calls to map to db file scattered read. Jeff's Why are
Oracle's Read Events 'Named Backwards'? explains (www.hotsos.com/catalog).
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
-
The HP-UX syscall tracing tool is called 'tusc', and it's supposed to be
available by visiting ftp://ftp.cup.hp.com/dist/networking/misc/.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic 101, Mar 25-27 Oxford
- Hotsos Clinic 101, Apr 8-10 Chicago
Questions I would have for those who wrote the requirements:
Of possible combinations of the form ABC XYZ XYZ ABC, which do they want?
As can be seen from the answers sent to the list, there is more than one set
of responses that give this pattern. If they only want half of the
possible
1 - 100 of 148 matches
Mail list logo