This is from grandpa's memory:
The wait interface (v$system_event, v$session_event, v$session_wait) were
introduced in 7.0.12. So if my memory works correctly at this early hour, that
was 1992. In 1995, I wrote the Oracle7 wait events and enqueue paper, after Jeff
Needham explained a couple of
Hi
TOra ist one of the best tools available.
It's kind of a mixture of toad and navigator.
Offers PL/SQL editor / debugger and a lot of server info stuff.
URL: www.globecom.net/tora
regards,
Stefan
-Ursprüngliche Nachricht-
Von: Joe Raube [mailto:[EMAIL PROTECTED]]
Gesendet: Montag,
2001 - a lot of books are published with wait
interface / YAPP methodology
Tuning 101 gets a lot of play here, and they devote a chapter to it. Other
than that, what books cover waits in a significant way? Thanks.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
Hi
I've got a question regarding your migration host - oracle, since I'll have
the same
problem in the near future.
How do you deal with the EBCDIC to ASCII problem ?
Do you migrate from VSAM or DB2 ? Which version of Oracle are you on ?
Regards,
Stefan
-Ursprüngliche Nachricht-
Von:
- Original Message -
From: Reardon, Bruce (CALBBAY)
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Sun, 21 Apr 2002 22:23:18
Our production instance started getting ora-4031
errors around 6pm on Frida=
y 19th.=0D
I was called by our users around 9am
The old hack is via definers rights procedures
(as SYS etc)
create or replace
procedure THE_OWNER.do_sql(m varchar2) is
begin
execute immediate m;
end;
exec THE_OWNER.do_sql('grant ...');
drop procedure THE_OWNER.do_sql
hth
connor
--- Jared Still [EMAIL PROTECTED] wrote:
That won't
Yes,
I forgot to mention Gaja's book, and there is a book out there Oracle DBA 101,
that has a complete section (2nd or 3rd) about tuning by wait interface/YAPP.
Anjo.
Greg Moore wrote:
2001 - a lot of books are published with wait
interface / YAPP methodology
Tuning 101 gets a lot
3113 is a tough beast to resolve. We have some java processes that feed out
spores to our clients. Recently at about 5:30pm and 6pm they all started
throwing 3113 errors (with corresponding Exception 11 dump files on the
server bdumps and cores too). Mind it well, the server trace file just tells
Hi All that recently attended IOUG.
If you don't already know - I sell tools for Oracle. (delete this now if
you want to DG! ;P)
I was just wondering if anybody at IOUG had any feedback on any new tools
that were launched, or any tools that made a significant impact at IOUG?
This is purely for
Title: executing a stored procedure at a certain time
I do it in this way ..
Firstly ,
dbms_job.submit giving the interval
..
then
dbms_job.next_date...
Bunyamin K.
Karadeniz Oracle
DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu
7.km Ankara TurkeyPhone: +90 312
-Madhu
How about the following:
create or replace PROCEDURE Get_Emp_Rows (EmpCur IN OUT GenPack.GenCurTyp,
Nstr Varchar2) IS
cname Emp.Name%type;
rec_count number; -- == I added this
BEGIN
select count(*) into rec_count -- == I added these
FROM Emp where name = Nstr;
Title: White papers on industry trends
Are there any white papers on industry trends for architecture including programming languages. I'm working on a project that is in the early stages of a redesign. The current application uses C code entirely including user interface. The client is sold
8.1.6 on NT
The product that I support is still Rule based. I am planning to bring it
over to Cost based in the near future. What I wanted to do was to set the
init parameter to 'RULE' and then run statistics on the database. My boss
says we can't do this because the execution plan was different
Step 1 - Migration id Database from Oracle 7.3.4.5 to Oracle 8.1.7.2 .
Step 2 - After Completion of Migration used
execute dbms_space_admin.tablespace_migrate_to_local('Tablespace name'); to Convert
the Dictionary Managed Tablespace to LOCALLY Managed Tablespace
Step 3 Added a Datafile of
[EMAIL PROTECTED] wrote:
The paper is a condensed version of the book
Oracle Performance Tuning 101 published by
Osborne (ISBN 0-07-213145-4). This is an
EXCELLENT book and worth every penny that it
costs.
actually i think it's worth more than it costs, but that's just because
it made me look
Hi Stefan,
The EBCDIC-ASCII conversion is handled on the mainframe for me. I am sorry
I don't know much about the mainframe environment here, I want to say it's
VSAM, there definately is no database. It is so old, it's the type of
mainframe where everything is on TAPE.
Oracle version:
are you sure that you set ORACLE_SID appropriately?
sqlplus /nolog
connect sys/change_on_install@XXX as sysdba
startup (nomount)
replace XXX with your SID, typically ORCL.
if this doesn't help, try:
use O9i on RH7.2 twice, SunOS 5.8 twice, W2k twice- they all run fine.
you need a workaround to
Hi All,
Before we go through the tests I thought I might save myself some time:
We are about to install Oracle 8.1.7 into a seperate Oracle Home on a
machine already running 8.0.5
We will not be upgrading our databases yet, just creating new ones from
scratch.
Our thinking is that apart from
Valerie,
C is still a very heavily used language, although for a complete application
I'd probably want to use a C++ variant since they come with screen painter
tools. Migrating from C to Forms/Reports would not be unthinkable, but don't
underestimate the learning curve. As far as
If you set optimizer_mode to rule, it will be rule
independent of stats unless sql's explicitly do
something to invoke the cbo (eg with a hint etc).
Your greatest risk would be any SQL's that have a
CHOOSE hint in them. But its worth the risk - rule
based is a dead end street.
hth
connor
---
In general, if you set init.ora to RULE and gather statistics, unless
you have hints in your SQL, the statistics will be ignored.
This may or may not be different than setting to CHOOSE and having no
statistics - it depends on your SQL.
-Joe
--- Shaw John-P55297 [EMAIL PROTECTED] wrote:
8.1.6
Hi
are U aware of any free open source PL/SQL Editors or freeware/open source
tools for database management ?
If so , would u please post an URL of a such .
Depends on what you want for Database management - if you need to document
schemas or re-create them elsewhere the Free DBATool might
If you are using PL/sql then try to reference the sequence next value in
the update/insert statement itself. Aso the update/insert can return the
value of the sequence to a PL/SQL memory variable.
regards,
Waleed
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent:
There is always Steve Adams' Oracle8i Internal Services - for Waits,
Latches, Locks and Memory from O'Reilly (undoubtably the all-time record
holder for information density). It is best considered as Foundations for
Advanced Tuning - as described on the cover. Chapter 2 is devoted to
waits, but
Rather than a genus, how about a species ?
Thank you,
Paul Sherman
DBA
voice - 781-501-4143 (office)
fax- 781-278-8341 (office)
email - [EMAIL PROTECTED]
-Original Message-
Sent: Monday, April 22, 2002 10:08 AM
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED] wrote:
According to migration doc, JOB_QUEUE_INTERVAL is obsolete in 9i.
So, does anyone know, how often each of SNP background processes wakes up
(without this parameter being specified)?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Hi all!
I need a solution about calling sql*loader from pl/sql. I have a version
now with external dlls, but actually I don't know the platform so it not
seems a good choice. I would like something native oracle solution with
oracle's packages or something like that.
--
Please see the
Greetings,
Here is the scenario.
We are trying to insert records into a remote table via database link after selecting
the data locally.
This query hangs for ever:
--
INSERT INTO [EMAIL PROTECTED]
SELECT * FROM FW.FWLOT_PN2M WHERE FW.FWLOT_PN2M.fromid =
(select
upgrade to Oracle 9i and use external tables.
-Original Message-
Sent: Monday, April 22, 2002 11:38 AM
To: Multiple recipients of list ORACLE-L
Hi all!
I need a solution about calling sql*loader from pl/sql. I have a version
now with external dlls, but actually I don't know the
THANKS a lot to all who replied !
DBAndrey
* 03-9254520
* 058-548133
* mailto:[EMAIL PROTECTED]
-Original Message-
Sent: Mon, April 22, 2002 5:33 PM
To: Multiple recipients of list ORACLE-L
Hi
are U aware of any free open source PL/SQL Editors or freeware/open source
tools
Lisa,
I'll assume the mainframe application is Cobol or some derivative.
Are the original file descriptors available to you? If so they should
hold some real clues whether it is a good idea to null out the fields
that are all zeroes. If the field is really a number and meant to be
used in a
Tom,
Thanks for taking time off to reply.
I had wanted two things - To check rowcount (to enable returning a code for
no-rows-found) and secondly, to avoid hitting the database more than once
for the same kind of query.
I hope you agree that your method also hits db twice. (I open the cursor
Ashoke - Sympathy, but no firm answers here. I have seen this type of
behavior before. Someone mentioned that the underlying problem is that the
Oracle optimizer doesn't have enough information to make an intelligent
decision in some database link situations. Sometimes I've given up in
I've done this on Solaris without any problems, including creating a new
8.1.7 database instance with an 8.0.6 instance running. The key is
separate ORACLE_HOME's and being certain you're environment is set for
the correct version.
Jack van Zanen wrote:
Hi All,
Before we go through the
There are a few conditions which make Oracle
use cost based optimisation on a statement even
when your system is set to RULE based, or even
when you have a RULE hint.
To date the list is (I think) limited to statements
containing at least one of the following:
An IOT
A partitioned table
The
Thank all of you for the replies.
Unfortunately the program is in c++.
Gaja, I will forward your suggestion to the development team.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, April 21, 2002 8:28 PM
Hi Yechiel,
I don't think anyone who reads the original YAPP
paper will miss this. If I recall correctly, one of
it's opening statements is the classic formula:
response time = service time plus wait time.
My own mantra puts in rather less scientific terms:
If you have a performance problem,
SAP official history is at http://www.sapdb.org/history.htm
Amusingly, they have blanked out what SAPDB was originally called. Of
personal interest to me is the Cincom connection in that I worked with their
software for much of the 80's...
Kip Bryant
|Um, no, not really.
|SAPDB is Sybase,
Ashoke,
Can you try using an in-line view like this:
INSERT INTO [EMAIL PROTECTED]
SELECT * FROM FW.FWLOT_PN2M,(
select fw.fwlot.sysid sysid from fw.fwlot where fw.fwlot.appid =
'205956')
WHERE FW.FWLOT_PN2M.fromid = sysid;
Havn't tried this, but it is worth a shot.
good luck!
Tom
Madhu,
I agree that the suggestion I proposed performs two queries. And I'm glad
you have found a work-around (having your application do what it should do).
I am guessing that my proposal would not cost very much to run. If you
think about, the first query (select count(*)) would certainly
Title: RE: White papers on industry trends
Dick,
Thanks for the information. You make a good point about learning curve (which is a concern the client has too) and about breaking up the C code. Yes, I am a contractor with the IRS but this project was always written in C. Never in Ada..
Hi,
I am attempting to install oracle 8.1.7 on a pentium IV machine using
red hat 7.2. I cannot get the oracle universal installer to start. I
have discovered problems noted on metalink about pentium IV machines
using windows. Does this problem also occur with linux? I have also
found that red
How about this ...
INSERT INTO [EMAIL PROTECTED]
SELECT a.*
FROM FW.FWLOT_PN2M a, fw.fwlot b
WHERE a.fromid = b.sysid
AND b.appid = '205956';
HTH
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at
One needs to keep in mind that Waits are the symptoms, and not a problem.
- Kirti
-Original Message-
Sent: Monday, April 22, 2002 12:13 PM
To: Multiple recipients of list ORACLE-L
I don't think anyone who reads the original YAPP
paper will miss this. If I recall correctly, one of
Hello Gaja
I could not find x$dual. Did select on all_objects got zip.
Oracle 8.1.6.3.4 on NT.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, April 21, 2002 8:28 PM
Hi Yechiel,
Any full-table-scan in Oracle 8i
- Original Message -
SAP official history is at http://www.sapdb.org/history.htm
Amusingly, they have blanked out what SAPDB was originally called. Of
personal interest to me is the Cincom connection in that I worked with
their
software for much of the 80's...
this is from the
Well absolutely true, but then everything the database does is a symptom of
the fact that we throw workload at it ;-)
Deshpande, Kirti wrote:
One needs to keep in mind that Waits are the symptoms, and not a problem.
- Kirti
-Original Message-
Sent: Monday, April 22, 2002 12:13 PM
returning_clause is supported in most languages.
Also you might need to encapsulate some of your logic using stored
procedures.
Good luck.
Waleed
-Original Message-
Sent: Monday, April 22, 2002 1:06 PM
To: Multiple recipients of list ORACLE-L
Thank all of you for the replies.
Knowing what I do about SAP support I'd not want to get into a project with
SAPDB! Those good German engineers would chew your head off when calling tech
support. Whatever caused the error MUST be your fault!
Dick Goulet
Reply Separator
Author: [EMAIL
Then it depends on the workload and its quality quantity ;=) because, the
database does what it is asked to do ;)
- Kirti
-Original Message-
Sent: Monday, April 22, 2002 1:04 PM
To: Multiple recipients of list ORACLE-L
Well absolutely true, but then everything the database does is
Hello Yechiel,
X$DUAL is an Oracle-internal table in the SGA and
will not be shown in an ALL_OBJECTS listing.
Obviously, you need to be SYS to see this. You can do
a describe as SYS and you will see it. Which is the
reason why I recommended creating a view and a public
synonym on the view, so
Jack,
I asked this question last week. I got one reply saying that it was okay
to install and build new databases with another version running in
a different Oracle home (from Rachel I think). I assume she had tried
it out but I don't know for sure.
Ben
--
Please see the official ORACLE-L
Does your event by any chance produce a tracefile that could be used for
anything?
Mogens
Stephane Faroult wrote:
- Original Message -From: "Reardon, Bruce (CALBBAY)"[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L[EMAIL PROTECTED]Sent: Sun, 21 Apr 2002
I will check this out, it sounds like it could work for me. However, if
anyone has used DBArtisan extensively, do send me some details (send it
directly to me please), so I dont have to go through the entire exercise of
downloading, configuring,
Simply put, I am looking for something
Hello everyone,
I asked our sysadmin to keep me updated on all OS patches he plans to
apply
to our test and production servers, to allow ample testing and research
prior to implementation in production. (Testing patches is a new idea to
him.)
Below is a list of all the patches he
All,
What are the recommended Kernal Parameters (Semaphore
and Shared memory) for HP-UX 11.0 (Oracle 8.1.7).
I could not find any good document from metalink site.
Also, I could not find any thing from Oracle 8.1.7
documentation CD.
Thanks,
Bob
Plus, I had some experience with a Supra-ized Cincom database. It was a
nightmare. We wound up reverting to their more primitive (but stable)
database - Total. There was a newer pass at Supra in the early '90s that
was supposed to turn a Total database into a relational database and this
It's on page 3, line 38. That includes the front page. Never figured out
why you waste a lot of words before getting to the point, Anjo?
Mogens
Jonathan Lewis wrote:
I don't think anyone who reads the original YAPP
paper will miss this. If I recall correctly, one of
it's opening statements is
Humm, Can you say 'AW Sht!!!'
Dick Goulet
Reply Separator
Author: Witold Iwaniec [EMAIL PROTECTED]
Date: 4/19/2002 8:08 AM
Hi
There have been some postings related to Oracle licensing.
An interesting article:
Blake - There is a known problem with the Pentium IV, at least for the
Windows install. See Note 131299.9 on Metalink.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, April 22, 2002 12:31 PM
To: Multiple recipients of list ORACLE-L
Hi,
I am
Indeed. When looking at R = S + W I truly get scared when I see stuff like
400 = 399 + 1. Doesn't leave much room for database work, does it?
Anjo Kolk wrote:
Well absolutely true, but then everything the database does is a symptom ofthe fact that we throw workload at it ;-)"Deshpande,
Is that the one where they just copied your whole YAPP paper in without mentioning
you at all? I seem to recall seing it at IOUG-A last year, but my memory
has always been and will always be bad.
Mogens
Anjo Kolk wrote:
Yes,I forgot to mention Gaja's book, and there is a book out there
Tom,
With this I get the following errors
INSERT INTO [EMAIL PROTECTED]
*
ERROR at line 1:
ORA-00913: too many values
Any more suggestions.
Thanks,
Ashoke
-Original Message-
Sent: Monday, April 22, 2002 12:31 PM
To: Multiple recipients of list ORACLE-L
Hi Raj,
I tried this and still it hangs.
Thanks,
Ashoke
-Original Message-
Sent: Monday, April 22, 2002 12:31 PM
To: Multiple recipients of list ORACLE-L
How about this ...
INSERT INTO [EMAIL PROTECTED]
SELECT a.*
FROM FW.FWLOT_PN2M a, fw.fwlot b
WHERE a.fromid = b.sysid
Ah, good point about Jeff Needham who's now partner with James Morle (ScaleAbilities).
I hear rumors that Jeff might also be going to the Database Forum in Sydney.
We should have a historical gathering there where we wait in line while everybody
else get serviced.
Mogens
Anjo Kolk wrote:
It's even worse if British style humor is involved. Only Australians, Danes
and crazy people will understand it, then. I still like the Grant Any Dictionary
command, Connor. Let's try it at Oracle World in Copenhagen...
Mogens
[EMAIL PROTECTED] wrote:
Khe, khe I would like to oppose a
Title: DB_BLOCK_CHECKING and DB_BLOCK_CHECKSUM
Hi everybody,
I'm soliciting opinions on whether or not its a good practice to enable DB_BLOCK_CHECKING and DB_BLOCK_CHECKSUM. How much overhead is associated?
TIA,
Beth
Well Mogens,
I clearly remember the point you about 1500 word a day people and 5000 word
a day people at my kitchen table. Well I am typing now and my wife is on
the phone ;-)
Anjo.
Mogens Nørgaard wrote:
It's on page 3, line 38. That includes the front page. Never figured out
why you waste
How many rows does it return ... ??
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but
Jack - I normally install the new Oracle version to a separate ORACLE_HOME
on the production system. I have not encountered any problems. I would
caution you to do the install first on a test system, preferably with Oracle
configured as closely as possible to the production system. There is
It is supposed to return 15 rows.
Thanks,
Ashoke
-Original Message-
Sent: Monday, April 22, 2002 2:34 PM
To: Multiple recipients of list ORACLE-L
How many rows does it return ... ??
Raj
__
Rajendra Jamadagni MIS, ESPN
Beth - Are you asking because you are experiencing a corruption problem, or
because you're having a paranoid Monday? ;-) I believe the overhead is
enough that you wouldn't turn them on just because. But if you are
experiencing occasional corruption, you could tolerate quite a bit of
overhead.
Title: RE:
There is a solution in Tom Kyte's Expert One on One book. It implements as SQL Loader in PL/SQL with UTL_FILE.
Tony Aponte
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 22, 2002 11:38 AM
To: Multiple recipients of list
Dennis,
Are you saying, that I have to take care of turning it off, since in 9i
the default value for DB_BLOCK_CHECKSUM is true?
Is it that much of overhead? Then, why did Oracle change the default?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients
I have created a function based index on one column
, but query is still noy using it . What should be the reason ?
oracle 8.1.7
cost based optimizer
table and index analyzed recently
Rajendra,
The coredumping is ofcourse a bug in Oracle. However, not producing a stack
trace and error stack also sounds like an bug to me. What is the response
from Oracle Support on this ? You are using AIX and what version of Oracle ?
Thanks,
Anjo.
- Original Message -
To: Multiple
Thanks Dennis. Its a paranoid Monday question. Actually I came across
an Oracle document which suggested that they always be enabled. I was
skeptical so decided to ask the real experts instead :-)
-Original Message-
Sent: Monday, April 22, 2002 4:03 PM
To: Multiple recipients of
Hi,
I have a question with regard to the best scheduling for Statspack. I am
running Oracle 8.1.6.2 on Hp UX11. I see that the oraperf site recommends
no more than intervals of (5 to 15 minutes) to tune performance problems.
Does setting up a schedule with 96 or 288 snaps at level
the
query_rewrite_enabled init.ora parameter has to be set
properly.
-Original Message-From: Big Planet
[mailto:[EMAIL PROTECTED]]Sent: Monday, April 22, 2002 4:15
PMTo: Multiple recipients of list ORACLE-LSubject:
function based index
I have created a function based
Title: Message
You
should make sure the QUERY_REWRITE_ENABLED init.ora parameter is set to
true.
-Original Message-From: Big Planet
[mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 4:15
PMTo: Multiple recipients of list ORACLE-LSubject:
function based index
I
I am trying to install the 8.1.7.3 upgrade patch. Unfortunately, somewhere down the
road I have lost my oraInventory directory. The installer says 'There are no patches
to be applied. Metalink says that the only way to get your oraInventory back is to
reinstall the current version of
Adabas eh?
Oh well, I knew it was a clone of something I didn't
care to work with.
( OK all you Adabas lovers, all mail with Adabas
in it is now going to /dev/null ;)
Jared
Marin Dimitrov [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/22/2002 11:03 AM
Please respond to ORACLE-L
Ashoke,
sorry, try this:
INSERT INTO [EMAIL PROTECTED]
SELECT FW.FWLOT_PN2M.* FROM FW.FWLOT_PN2M,(
select fw.fwlot.sysid sysid from fw.fwlot where fw.fwlot.appid =
'205956')
WHERE FW.FWLOT_PN2M.fromid = sysid;
Tom Mercadante
Oracle Certified Professional
-Original Message-
Anjo,
me think it is something related to bind values and we use
cursor_sharing=force. There is a bug already logged in and colleague of mine
is working on it.
In the mean time, I noted it here, because a shared_pool flush worked. I am
on 9012 on AIX 4.3 64 bit. I think this is where I was told
My boss (one of those scarey-smart people) was taking some
certification test, when someone mused, I wonder how many questions he
will answer 'incorrectly' in order to get a higher score? This is
because he knows how it really works unlike those that made up the
test.
Made me wonder how many
Beth - Well, you can get ahead of the curve and report back to the rest of
us. Since you mentioned both parameters, I'm assuming that you are
considering turning DB_BLOCK_CHECKSUM=true and leaving
DB_BLOCK_CHECKING=false.
Igor - Thanks for pointing out that the DB_BLOCK_CHECKSUM parameter is
Hi.
We are loading tables using Ab Initio and SQL*Loader
in paralel in direct path mode. Now today the process
failed. I thought that no records would be added to
the table, but we seem to found about 64000 of them in
the table. How/why would this happen? Thanks for any
insight
Gene
This is completely right!
-Original Message-
Sent: Monday, April 22, 2002 5:38 PM
To: Multiple recipients of list ORACLE-L
My boss (one of those scarey-smart people) was taking some
certification test, when someone mused, I wonder how many questions he
will answer 'incorrectly' in
If you've got a sql statement that expects more than one row back across a
database link it is very likely to issue a ' select column,column,etc...
from table_name' statement across the link resolve things locally via a
temporary table, which is not indexed of course.
Dick Goulet
James Morle's Scaling Oracle8i is my favourite book on Oracle performance,
and covers the wait interface excellently. Highly recommended.
Paul
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, April 22, 2002 6:48 AM
Yes,
I forgot to mention
Stefan,
I've got a question regarding your migration host - oracle,
since I'll have
the same
problem in the near future.
How do you deal with the EBCDIC to ASCII problem ?
Do you migrate from VSAM or DB2 ? Which version of Oracle are you on ?
Can't reply to the second one, but take a
Do these qualify?
* Far too much emphasis on Oracle's GUI tools (OEM, DBCA, etc.)
* Too little emphasis on understanding too much on knowledge (i.e. rote
memorization)
* Treating ratios as the holy grail of tuning
* etc...
Don Granaman
[certifiable OraSaurus]
- Original Message -
To:
Is there any overhead (ie. internal conversion) in comparing a char to a
varchar2? We found an instance where a primary key in one table is defined
as char(2) and the foreign key referencing it from another table is
varchar2(2). We are going to change it, but I'm curious what, if anything,
Yes, performance tuning using hit ratios. In preparation for that test
I studied hard on learning wrong answers to questions like:
Q) Hit-ratio is 45%, what to you do?
Ray Stell wrote:
My boss (one of those scarey-smart people) was taking some
certification test, when someone mused, I
Mark,
This is from a first-timer at IOUG, so I may be way off here.
A lot of marketing blurb was thrown out at IOUG (probably a lot less than
usual, and *much* less than Oracle OpenWorld in any case!). As for tools,
many vendors were flogging the same ones, improved versions maybe. One which
Val,
For a real dinosaur, try Jovial. Created by Teledyne for the USAF to
improve the performance of ECM equipment. Last used in the late 70's after a
fitful 10 year lifespan. If I remember correctly there were about 50 people in
the world who knew it.
As for your C code, take a
Title: DB_BLOCK_CHECKING and DB_BLOCK_CHECKSUM
DB_BLOCK_CHECKSUM = no overhead worth
mentioning
DB_BLOCK_CHECKING = equivalent to 10210 (check data
block integrity), 10211 (check index block integrity), and 10212 (check cluster
integrity) events
The former (DB_BLOCK_CHECKSUM) is useful if
QUERY_REWRITE must be enabled. Either for the
instance (i.e. init.ora or alter system set), for the session (alter session
set) orfor a single SQL statement(i.e. SQL hint
"rewrite")...
You'll also need to analyze the index with either
ANALYZE or DBMS_STATS...
- Original Message
sqlldr has rows option: rows -- Number of rows in conventional path bind
array or between direct path data saves
(Default: Conventional path 64, Direct path all)
Waleed
-Original Message-
Sent: Monday, April 22, 2002 6:07 PM
To: Multiple recipients of list ORACLE-L
Hi.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
1 - 100 of 125 matches
Mail list logo
