Hello
There are a few considerations:
1) If you import the data using the loader you can use the NULLIF clause
so it will import all zero field as null.
2) Check carefully for usage of the fields in the WHERE part of the SQL.
Putting nulls instead of zero can cause the users to do outer
Hi Yechiel,
I'm aware of the NULLIF clause. However my strategy has been to bring the
entire file in, character based, so I can take a look at the data prior to
modifying it. I'm using NULLIF column_name is equal to spaces.
I made an even better decision - the users decided they didn't
Dear list!
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 .
Thanks a lot .
Andre.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Andrey Bronfin
INET: [EMAIL
Hello all,
Someone posted a link to a page describing what was going on at ioug-a.
This link spoke of a presentation (by Gaja?) that addressed tuning without
ever looking at a ratio.
Are these papers available to the public or only to attendees? I really
really wanted to go to this meeting
Lisa,
(Copy of response sent to your direct e-mail since list servers don't do
well with large attachments).
I will attach the white paper you are looking for. You should know that
this is a quick overview of the content of Gaja's book.
Here is my advise:
1) Join IOUG - There are tons of
Ron,
Can u Also Mail me that Document if it feasible for u.
Thanks.
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 745 6019
Live to learn... forget... and learn again.
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.
Koivu, Lisa wrote:
Hello all,
Someone posted a link to a page describing what was going on at ioug-a.
This
Would u mail it to me tooo , please ...
Also , if there is a possibility to get this (and others) papers somewhere
on the web...
THANKS A LOT !!!
-Original Message-
Sent: Sun, April 21, 2002 3:08 PM
To: Multiple recipients of list ORACLE-L
Ron,
Can u Also Mail me that Document if
I did two statspack snapshots, one hour and forty minutes apart.
Then I generated a report and loaded it into oraperf.com.
In the report I saw that the two SQL statements that where executed the most
times where:
Select .currval from dual;
Select .nextval from dual;.
Each one was
There seems to be a lot of interest in the tuning revolution here, so...
The basics revolve around the views v$system_event, v$session_event, and
v$session_wait, and v$event_name - and the 10046 event. Rather than try to
paraphrase/summarize/expound upon the details, here are some of the best
After reading some notes on the dbms_stats package, I have tried using
alter table nomonitoring to set the monitoring status of some tables
to No, so that these tables would not be analyzed by the
dbms_stats.gather_database_stats procedure which is run daily on our
machines.
But it is
Hi Yechiel,
Any full-table-scan in Oracle 8i (or below) consumes 4
LIOs to the segment header. This number has reduced to
2 in 9i. Given that the 1 row that you are going after
is in 1 data block, there is 1 LIO for the data block
itself, given you a total of 5 LIOs. You can verify
this by
Hi List,
I have a strange problem for ONLY one table in entire database, when run the
following query got ORA - 01722 and when I drop the table and rebuild it
it's running OK,
Any Idea?
this is the query which I run:
select count(*)
from (select osi_srv_code_from, osi_srv_code_to
The 5 buffer gets are 4 CURRENT on the
segment header block and one consistent
on the data block. It's a (relatively minor)
bug in the internal code for scans.
This changes in 9.0.1 to 2 Consistent on
the segment header and one consistent
on the data block in version 9.
The large number of
This is a mixture of bad luck and bad design.
You have a character column pretending to be
a numeric column, and although your query has
some code in it to try and ensure that the numeric
tests are only made against strings that look like
numbers, you have not managed to guarantee that
this
Hello Guys,
Linux 2.4.18
Pentium III
both Oracle 9i and 8i
used netca and netmgr to configure listener
listener is configured and listening off port 1521
init.ora is ready and in under OracleHome/dbs
in sqlplus, the command startup nomount gives me this error:
ORA-03113 end-of-file on
The ultimate Oracle/Open Source resource:
http://www.oreilly.com/catalog/oracleopen/
Jared
On Sunday 21 April 2002 03:53, Andrey Bronfin wrote:
Dear list!
are U aware of any free open source PL/SQL Editors or freeware/open source
tools for database management ?
If so , would u please
Nice post. The 'revolution' is indeed not that new, more
of an underground guerilla movement.
And it wasn't televised. :)
Jared
On Sunday 21 April 2002 10:33, Don Granaman wrote:
There seems to be a lot of interest in the tuning revolution here, so...
The basics revolve around the views
I *hope* you have MetaLink access, cuz your
gonna need it.
You gave the Kernel version, but not the OS.
I'm going to assume you are RedHat 7.1 or 7.2
due to the late version of your kernel.
Oracle is not certified on these. There is a
workaround. You can go technet.oracle.com,
go to the
go to freshmeat.net and do a search.
Also check out Oracletool and Orasnap.
-Joe
--- Andrey Bronfin [EMAIL PROTECTED] wrote:
Dear list!
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 .
On Sun, Apr 21, 2002 at 04:18:27PM -0800, Jared Still wrote:
I *hope* you have MetaLink access, cuz your
gonna need it.
You gave the Kernel version, but not the OS.
I'm going to assume you are RedHat 7.1 or 7.2
due to the late version of your kernel.
Oracle is not certified on
9i is certified on rh 7.1 but not rh 7.2 a/o last week when i checked.
it will work though on either, i've successfully got it running on rh
7.2 and used that for the logminer and data guard presentations last
week at ioug conference.
joe
Jared Still wrote:
I *hope* you have MetaLink
Dear All,
Where I could find the Oracle Pro-Fortran?
Oracle dealer in my country said I could find it in Oracle Enterprise. But
when I'll try to find it from Oracle 8i and Oracle 9i enterprise, I could
find no-pro-fortran on it.
Thanks.
Ahmadsyah Alghozi Nugroho(Oracle Certified DBA)
--
Assuming all your OS, patches, etc.. are certified, this error is very
generic.
Check your ORACLE_HOME again.
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 4/21/02 2:58 PM
Hello Guys,
Linux 2.4.18
Pentium III
both Oracle 9i and 8i
used netca and netmgr to
pro-fortran was stopped being produced back in v7 days if i remember
right, only ones left are pro*c and maybe pro*cobol in v8.
joe
[EMAIL PROTECTED] wrote:
Dear All,
Where I could find the Oracle Pro-Fortran?
Oracle dealer in my country said I could find it in Oracle Enterprise. But
when
[EMAIL PROTECTED] wrote:
Dear All,
Where I could find the Oracle Pro-Fortran?
Oracle dealer in my country said I could find it in Oracle Enterprise. But
when I'll try to find it from Oracle 8i and Oracle 9i enterprise, I could
find no-pro-fortran on it.
Thanks.
Ahmadsyah Alghozi
Hi!,
On windows 2000 when I execute Run Form From Web under Forms 6i group it
gives the following error:
Oralce form web CGI: Error detected.
You request cannot be serviced due to the following error
Error: Error getting least loaded host from Load Balancer Server
What to do?
TIA!
Aleem
--
Our production instance started getting ora-4031 errors around 6pm on Friday 19th.
I was called by our users around 9am on Sunday 21st and problem persisted and I
decided to restart the instance around 11:30am Sunday 21st.
What I would like is some advice on what other information I should
28 matches
Mail list logo