PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 01, 2002 12:42 PM
To: [EMAIL PROTECTED]
Cc: Adams, Matthew (GEA, MABG, 088130)
Subject: RE: extremely long parse time
Importance: High
Matt,
Have you done a 10053 trace on this query?
Jared
Adams, Matthew (GEA, MABG, 088130
(GEA, MABG,
088130) [mailto:[EMAIL PROTECTED]]Sent: Thursday, September
26, 2002 10:30 AMTo: Multiple recipients of list
ORACLE-LSubject: extremely long parse time
why would a query take 148 seconds to parse? It is a two way union where the
first half is going against all_tables
International, Sussex, WI USA
-Original Message-
From: Adams, Matthew (GEA, MABG, 088130) [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 10:04 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: extremely long parse time
Nope, Oracle 8.1.7.2 on HP-UX 11. 148 seconds
]
Their fundamental design flaws are completely
hidden by their superficial design flaws.
- Douglas Adams
-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 1:27 PM
To: '[EMAIL PROTECTED]'
Cc: Adams, Matthew (GEA, MABG, 088130)
Subject: RE: extremely long parse
I got the first bid in!!!
Matt Adams - GE Appliances - [EMAIL PROTECTED]Their
fundamental design flaws are completelyhidden by their superficial design
flaws. - Douglas Adams
-Original Message-From: JOE
TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, September 26,
2002
Title: extremely long parse time
why would a query take 148 seconds to
parse? It is a two way union
where the first half is going against all_tables
and the second half is a join
between all_indexes and all_ind_columns.
The shared pool has 50M large parts of it are
free. I generated a
Title: RE: connect to the databases without using tnsnames.ora?
No it does not.
try the following from the command line
(with no tnsnames.ora file)
(substitute valid values for machine, port, sid, etc)
sqlplus
Title: RE: utl_file_dir vs create directory
I believe that the 'create directory' command is only
appropriate when dealing with BFILEs.
It's not exactly a substitute for the UTL_FILE package
and UTL_FILE_DIR parameter.
Matt Adams - GE Appliances - [EMAIL PROTECTED]
My computer beat
Title: process size limitation on HP-UX
When 32 bit Oracle (8.0.5) is running
under hp-ux 11 (64 bit), is the shadow process
size limited by the 'maxdsiz' kernal parameter
(defaults to 64 Meg) or the 'maxdsiz_64'
kernel parameter, which default to 1 Gig?
Matt Adams - GE Appliances -
Title: using stored procedures from pro*c
When calling a stored procedure (to do a select)
from a pro*c program, does the sqlca.sqlerrd[2]
row counter get set? Or does that
happen only if you are putting the selects into
the Pro*C program?
It seems to act differently for different
Title: RE: Myers-Briggs
I have been subjected to this rubbish repeatedly for
the last 20 years or so, including being forced
to do my senior project in college on non-sense related
to this test and the results.
My personal opinion: it's a bunch of crapola.
One of the major precepts of this
,
Matthew (GEA, MABG, 088130) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 11, 2002 2:15 PM To: Multiple recipients of list ORACLE-L Subject:
listener configuration on HP serviceguard clusters
If anybody out there is using HP ServiceGuard for
non-OPS/RAC, I would be interested to know how you
Title: larry want to take over your e-mai
Ok, I just used the subject line to get your attention.
From today's copy of InformationWeek's daily e-mail.
--
** Oracle Takes On Microsoft's E-Mail
Oracle CEO Larry Ellison says he wants to exploit the security
vulnerabilities and
Title: listener configuration on HP serviceguard clusters
If anybody out there is using HP ServiceGuard for
non-OPS/RAC, I would be interested to know how you
configure the listeners. Do you use the machine IP address
or the package address in the listener.ora (or do you not
have a
Title: privileges and synonyms and dblinks
All of a sudden this is not making sense to me.
Oracle 8.1.7.3 on HP-UX 11i
I have a public db link (link1)
I have a user (user1) who creates a PRIVATE synonym.
(user1.syn1) that points to a table on the other database
using the dblink.
Title: RE: the ora certified masters cert, yet again
unfortunately, I've seen this to be true at
many conferences, including the IOUG
and SEOUC.
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Doing linear scans over an associative array is like
trying to club someone to death with a
recipients of list ORACLE-LSubject:
RE: privileges and synonyms and dblinks
Matt,
We have run in to this issue.
There are some bugs related to this.
Pl review docs on Metalink # 159051.1, #
144114.1.
-
Kirti
-Original Message-From: Adams, Matthew (GEA, MABG,
088130) [mailto:[EMAIL
-Original
Message-From: Adams,
Matthew (GEA, MABG, 088130) [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 26, 2002 12:39
PMTo: Multiple recipients of
list ORACLE-LSubject: RE: the
ora certified masters cert, yet again
unfortunately, I've seen this
to be true at
many conferences, including
one of my favorite shows:
he has much knowledge. we must build an altar and worship him
:)
--- Adams, Matthew (GEA, MABG, 088130) [EMAIL PROTECTED]
wrote:
Actually, I had to miss this years (even though I was orginally
schedule
to give two presentations) due to a medical situation. I
, Matthew (GEA, MABG, 088130) [EMAIL PROTECTED]
wrote:
Actually, I had to miss this years (even though I was orginally
schedule
to give two presentations) due to a medical situation. I gave
four
the
year
before that.
Matt Adams - GE Appliances - [EMAIL PROTECTED]
We
Title: RE: SunOS 5.8 I/O buffer size?
Yeah, I've been using this device for backups for
years. Always get very good performance.
(This is a joke folks!)
Matt Adams - GE Appliances - [EMAIL PROTECTED]
When someone says I want a programming language in which I
only need say what I
Title: duplexing the archive redo log directory
Anybody encountered any bugs relating to
the
LOG_ARCHIVE_DUPLEX_DEST and
LOG_ARCHIVE_MIN_SUCCEED_DEST parameters
in 8.1.6 or 8.1.7?
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Contrary to popular opinion, Unix is user
Title: RE: duplexing the archive redo log directory
I had already done it online, but had to bounce
the database 30 minutes later for another
unrelated reason, so we should be OK.
Any other 'gotchas'?
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Contrary to popular opinion, Unix is
Title: RE: Archiver process in 7.3.4
how about examining v$parameter for the value of
the log_archive_start parameter?
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Contrary to popular opinion, Unix is user friendly.
It's just particular about who it makes friends with.
Title: rebuilding indexes
Under what conditions would an 'alter index .. rebuild'
actually case the size of the index to increase
by about 12 percent?
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Contrary to popular opinion, Unix is user friendly.
It's just particular about who
(GEA, MABG, 088130) [EMAIL PROTECTED]
wrote:
Under what conditions would an 'alter index .. rebuild'
actually case the size of the index to increase
by about 12 percent?
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Contrary to popular opinion, Unix is user friendly.
It's just
Title: RE: Covert tnsnames.ora to OID
Oracle
Internet Directory, which is Oracle's
LDAP
product.
Matt Adams - GE Appliances -
[EMAIL PROTECTED]Chaos! Panic! Disaster! (My work here is done)
-Original Message-From: Nirmal Kumar Muthu Kumaran
[mailto:[EMAIL PROTECTED]]Sent:
Title: RE: Patch: 1951929
This pretty much boilerplate text I've seen
on LOTS of patches from Oracle.
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Chaos! Panic! Disaster! (My work here is done)
-Original Message-
From: Ray Stell [mailto:[EMAIL PROTECTED]]
Sent: Monday, May
Title: RE: SHARED POOL SIZE
The value of IMMEDIATE in the ISSYS_MODIFIABLE column
means that it IS modifiable and takes effect
immediately.
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Chaos! Panic! Disaster! (My work here is done)
-Original Message-
From: [EMAIL PROTECTED]
Title: oracle 8.0.5.1 on hpux 11.11
Has anyone got this combination working?
I'm aware of the fact that it is not certified
or supported, but 7.3.4.4 is working on 11.11,
and at least temporarily, I need 8.0.5.1 too.
But I get a ora-3113 (and a ORA-7445 [10] in the
trace file) every time I
Title: RE: SIMPLE QUESTION
Actually it can be done without restarting the listener
lsnrctl set log_file new_log_file_name
[re]move the old log file
lsnrctl set log_file old_log_file_name
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Reason is 6/7ths of treason. - The Xtals
31 matches
Mail list logo