lines produced by 10046 level 8.
/Bjørn.
AK wrote:
when I am trying to execute tkprof
on 10046 output file ( level 8 ) , i am getting core dump .
any idea why ?
thanks,
ak
--
Bjørn Engsig, Miracle A/S
Member of Oak Table Network
[EMAIL PROTECTED] - http://MiracleAS.dk
ACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Bjørn Engsig, Miracle A/S
Member of Oak Table Network
[EMAIL PROTECTED] - http://MiracleAS.dk
tatements in both paragraphs seems ambiguous.
Pls shade some light.
Thanks
Sam
__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
--
Bjørn Engsig, Miracle A/S
Member of Oak Table Network
[EMAIL PROTECTED] - http://MiracleAS.dk
ET file_identity =
file_identity + 1 WHERE file_table = '%s' ", strFile);
pDatabase->ExecuteSQL(strSQL);
--
Bjørn Engsig, Miracle A/S
Member of Oak Table Network
[EMAIL PROTECTED] - http://MiracleAS.dk
Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly
personal.
QOTD: Any clod can have facts, having
an opinion is an art !!
-Original Message-
From: Bjørn Engsig[mailto:[EMAIL
IA
Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tél. (514) 925-7187
[EMAIL PROTECTED]
--
Bjørn Engsig, Miracle A/S
Member of Oak Table Network
[EMAIL PROTECTED] - http://MiracleAS.dk
ecture stuff was silent on the subject.
Ciao
Fuzzy
:-)
--
Bjørn Engsig, Miracle A/S
Member of Oak Table Network
[EMAIL PROTECTED] - http://MiracleAS.dk
improve the execution plan. I want to stuff that execution plan into a
stored outline so that the unhinted query uses that plan plan each time it
executes. Can this be done?
--
Bjørn Engsig, Miracle A/S
Member of Oak Table Network
[EMAIL PROTECTED] - http://MiracleAS.dk
rem
rem This
-------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).? You may
also send the HELP command for other information (like subscribing).
_
The new MSN 8: smart spam protection and 2 months FREE*? http://join.msn.com/?page=features/junkmail
--
Bjørn Engsig, Miracle A/S
Member of Oak Table Network
[EMAIL PROTECTED] - http://MiracleAS.dk
) 9612-6999.
Please advise immediately if you or your employer does not consent to
Internet e-mail for messages of this kind.
Opinions, conclusions and other information in this message
that do not relate to the official business of
Transurban City Link Ltd
shall be understood as neither given nor endorsed by it.
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
--
Bjørn Engsig, Miracle A/S
Member of Oak Table Network
[EMAIL PROTECTED] - http://MiracleAS.dk
e actually using that sorts...
Any ideas would be apreciated...
TIA
Kalle
Gå före i kön och få din sajt värderad på nolltid med Yahoo! Express
--
Bjørn Engsig, Miracle A/S
Member of Oak Table Network
[EMAIL PROTECTED] - http://MiracleAS.dk
to state them to be views of any such entity.
This e-mail message has been scanned for Viruses and Content and cleared
by MailMarshal - For more
information please visit www.marshalsoftware.com
--
Bjørn Engsig, Miracle A/S
Member of Oak Table Network
[EMA
this
mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note
EXACT spelling of 'ListGuru') and in
the message BODY, include
a line containing: UNSUB ORACLE-L
(or the name of mailing list
you want to be removed from). You may
also send the HELP command
for other info
do. Hence,
the verbose reply.)
-Original Message-
Could somebody help me here, this is very critical to be running
production without proper backups .!
--
Bjørn Engsig, Miracle A/S
Member of Oak Table Network
[EMAIL PROTECTED] - http://MiracleAS.dk
___
http://www.webmail.co.za the South-African free email service
NetWiseGurus.Com Portal - Your Own Internet Business Today!
--
Bjørn Engsig, Miracle A/S
Member of Oak Table Network
[EMAIL PROTECTED] - http://MiracleAS.dk
rem before running this, do
rem SQL> create ta
ately.
--
Bjørn Engsig, Miracle A/S
Member of Oak Table Network
[EMAIL PROTECTED] - http://MiracleAS.dk
fo from my statspack snapshots. They work without
modification on 8.1.7 but not on 9.2.
I was just wondering (before I attempt to modify myself) if anyone had
updated these scripts to work against the 9.2 statspack tables.
Thanks,
Chris
--
Bjørn Engsig, Miracle A/S
Member of Oak Tab
ll allow you to clearly distinguish portable from non-portable code.
/Bjørn.
--
Bjørn Engsig, Miracle A/S
Member of Oak Table Network
[EMAIL PROTECTED] - http://MiracleAS.dk
e message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Bjørn Engsig, Miracle A/S
Member of Oak Table Network
[EMAIL PROTECTED] - http://MiracleAS.dk
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing l
than a PK based on a character field?
> >
> > I've seen it mentioned a couple of times today under the "Design
> > Question" topic.
> >
> > It doesn't make any sense to me that one or the other would be faster.
> > After all, we are talking a
NOT NULL VARCHAR2(50)
>
> I'm trying to figure out which is more efficient, STATE_CODE or STATE_ID,
> when doing a PK lookup, dealing with FKs, etc.
>
> Many TIA!!!
>
> Chris
--
Bjørn Engsig, Miracle A/S
http://MiracleAS.dk
--
Please s
38-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> >
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT s
---
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list
t;
> > > > Hi Jared,
> > > >
> > > > > > * You *have* to take a COLD backup of the
> >
> > database after using
> >
> > > > > resetlogs.
> > > > >
> > > > > > (Not required - a Hot backup a
e, but how do you spit
> out multiple rows from PL/SQL?
>
> thx
>
>
> Bill Magaliff
> Framework, Inc.
> 914-631-2322
--
Bjørn Engsig, Miracle A/S
http://MiracleAS.dk
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Bj=F8rn=20Eng
and 23
> > disks. The 24th disk is cheap, but how much does the 25th disk cost? In
> > addition to the disk drive we need a cabinet, controllers, cache, host
> > adapters, cables, floor space, environmental controls, installation,
> > configuration, management, maintenance contract, an
SPACE is not so cheap.
If that were true, how come people buy disk space and end up with enough GB
but too few spindles, in stead of buying enough spindles and realizing they
have lots of spare disk space?
(Couldn't resist that one, I know this is not really what you meant)
Rgds, Bjørn
=FORCE but that degrade the performance of queries.
> We are having 9.0.1.2.1 on Win 2k.
> What can be the other options along with Cursor_sharing to redunce soft and
> hard parse.
>
> Thanks
> --Harvinder
--
Bjørn Engsig, Miracle A/S
http://MiracleAS.dk
--
Please see the official OR
ards,
> > > Ed
> > >
> > > > Hi
> > > > In our database I found SOFT PARSE RATION is 62% which is lower than
> > > > normal.What could be problem and how to correct this problem?Please
> > > > suggest. Thx
> > > > -Seema
e:
> Seema,
>
> I believe you can reduce that ratio by using session_cursors
>
> Regards,
> Ed
>
> > Hi
> > In our database I found SOFT PARSE RATION is 62% which is lower than
> > normal.What could be problem and how to correct this problem?Please
> >
> suggest. Thx
> -Seema
>
>
> _
> MSN Photos is the easiest way to share and print your photos:
> http://photos.msn.com/support/worldwide.aspx
--
Bjørn Engsig, Miracle A/S
http://MiracleAS.dk
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?i
L statements in trace file.
> 64 SQL statements EXPLAINed using schema:
>CSISDBA.prof$plan_table
> Default table was used.
> Table was created.
> Table was dropped.
>19969 lines in trace file.
-
f 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> > --
> > Please see th
be able to see
> this value of PPP.VVV .
>
> Thanks a lot in advance !
--
Bjørn Engsig, Miracle A/S
http://MiracleAS.dk
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Bj=F8rn=20Engsig?=
INET: [EMAIL PROTECTED]
Fat City Network Services-
On Friday 22 February 2002 16:03, "Henrik Ekenberg wrote:
> Who is your configuration ?
Two nodes running in VMWare on an HP laptop
> 2- Which Linux version ?
RH 7.1 + logical volume manager
> 3- Which Oracle version ?
9.0.1.2.0
> 4- Is is fun ?
That depends.
--
Bjørn En
good suggestions. I have already tried all the obvious
> init.ora parameters like make_delete_faster=true but
> they do not seem to work.:-)
>
> Thanks
> Sonia
>
>
> __
> Do You Yahoo!?
> Yahoo! Sports - Coverage of the 2
hink. I can see several reasons to use views and a few reasons
> > not to use them. I was just wondering what the rest of the group
> > thought.
> >
> > Ron Smith
> > DBA
> > Kerr-McGee Corp
--
Bjørn Engsig, Miracle A/S
http://MiracleAS.dk
--
Please see the official OR
eports in Crystal Reports. The
> application administrator is leery of using views and ask the DBA group
> what we think. I can see several reasons to use views and a few reasons
> not to use them. I was just wondering what the rest of the group thought.
>
> Ron Smith
> DBA
&
You Yahoo!?
> > Yahoo! Sports - Coverage of the 2002 Olympic Games
> > http://sports.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Rachel Carmichael
> > INET: [EMAIL PROTECTED]
> >
>
On Tuesday 19 February 2002 20:53, bill thater wrote:
>
> i had to do a bunch with SQL*Calc because damagement understood
> Lotus123. it was less than enjoyable.;-)
I was porting SQL*Calc to Unix - that was even less than enjoyable!
Rgds, Bjørn.
--
Please see the official ORACLE-L FAQ: http:/
Bambi,
HLI and OCI - that reminds me of another nice one from the dark ages. Some
of you around here, who consider yourself "old" in terms of Oracle may
remember, the oci call osql3(), which was later superceeded by oparse()
(version 6/7-ish, I think). Well, the reason for the old call being
There must be somebody beside myself remembering version 3, which did not
have read consistency - the great new feature of version 4. In 3, doing
UFI> insert into emp select * from emp;
would cause anything from having 28 rows in emp till having and endless loop
in the kernel only finishing w
The term "index only tables" was replaced by "index organized table" sometime
during the early stages, so it might have creeped into some documentation
somewhere. It's exactly the same thing and are also known as IOT's.
On Thursday 14 February 2002 22:31, you wrote:
> Greetings all,
>
> Can an
Ramesh,
I still don't know exactly what you mean by 'database sizing'. If what you
really mean is 'disk capacity', the most important factor today is the number
of I/O's available on your most active tablespaces and the redo log files.
Frequently, you end up with a situation, that your disk c
Ramesh,
I presume you are looking for something to tell you how to configure a
database server, and such a thing does not exist. Period.
The real answer is, that this is far too application dependent, and that
only the application developers can provide anything of this kind. And
even in th
It is not completely true what others have said, that RAC is the same as
OPS. RAC obviously builds on OPS, but there are quite a lot of
enhancements to improve the cache coherency issues, and it is also
expected that 9iR2 brings even more.
Thanks, Bjørn.
dist cash wrote:
> ORACLE 9i claim it
Title: White space compression in Oracle
Marc,
There are subtle differences between CHAR and VARCHAR2 when it comes to comparison
semantics as CHAR comparisons are blank padded, which VARCHAR2 are not.
Thanks, Bjørn.
Marc Perkowitz wrote:
Beth,
Actually, varchar2 is char with
seq$ will be soft parsed
for each use of a non-cached sequence number.
I would suggest you run your session with event 10046 traceing turned on.
Thanks, Bjørn.
James Manning wrote:
[Bjørn Engsig]
There are two things worth mentioning: cursor_sharing does NOT remove soft parses
If you're in to perl, you can get an Oracle module for perl. Thanks, Bjørn.
Smith, Ron L. wrote:
>I have a Unix batch script that calls a short (5 line) SQL script. Is there
>any way to include the SQL statements in the Unix script
>instead of calling the SQL?
>
>Ron Smith
>DBA
>Kerr-McGee
Jared Still wrote:
>Re the soft parse: this is essentially hashing the SQL
>and getting a hit in the lib cache. These can't be
>avoided.
>
Well, properly coded applications, that execute the same SQL statement
over and over again are code, such that there are no - hard or soft -
parses. A
You should not expect to see much performance improvement, except in
special cases where you can replace large deletes or loads by simpler
partition operations. Your decision to use partitioning should be based
on the ability to handle (i.e. DBA work) partitions separately, where
you can e.g.
It only cost you memory on the server side - there is practically no
performance hit. However, running out of open_cursors could be a sign
of incorrectly coded applications, that would open and never close a
cursor. You therefore need to keep an eye on this - v$open_cursor may
be of interest
To get resonable results from the reports, your timing interval should
be around 10 to 30 minutes. As running statspack collection every that often
is likely to produce far too much data than you want to have space for, I
always recommend running statspack collection in a system like this
If you are in to doing just moderately interesting performance
investigation and tuning, I would highly recommend learning how to use
the raw trace file. The aggregation that tkprof does has a tendency to
hide information rather than providing much more than the raw file.
Thanks, Bjørn.
[EMA
m each other
Regards
John
-----Original Message-
From: Bjørn Engsig [mailto:[EMAIL PROTECTED]]
Sent: 05 February 20021 2:25
To: Multiple recipients of list ORACLE-L
Subject: Re: OPS DBA work (was dumb question)
With the caveat, that I am a consultant and not actually a
Title: Message
With the caveat, that I am a consultant and not actually a DBA, I would argue
very strongly, that the OPS DBA needs quite some extra understanding, knowledge
and experience compared to one managing a single instance Oracle. In particular:
- Performance problems, primarily due to
You clearly also need to ask these persons about application design.
Together with the database design, poor application design is the
source of countless performance problems. The good application
developer is fully aware of how Oracle handles SQL statemens, how he
should and should not wri
--- Begin Message ---
You may wont to reconsider using Richard Niemiec's book. It's unfortunately
NOT one of the best books on Oracle tuning, you can get. It's actually pretty
full of factual errors and poor advices. There is a quite negative review
on amazon, that you should read.
I too,
The ora-600 12333 occurs in the two task layer, if it receives a function
code or argument, that is unexpected or invalid. Normally,the arguments
after [12333] identify some details about this, and there are a few metalink
notes relevant. The 12333 will always be followed by an ora-3106.
In
60 matches
Mail list logo