In order to find all your clients with wild cards you would have to use a
function like upper(lastname) like 'MCD%' - but you really don't want to be
doing full table scans. You could create a function based to look at your data
based upon the function ie:
CREATE INDEX emp_name_index ON emp
TOAD puts a hint in.
[EMAIL PROTECTED] 10/28/2003 1:29:25 PM
does toad or the oracle instance itself slip in rule hints? We got an
ora-600 error off of a data dictionary read. i think it has to do with explain
plan. ORA-00600: internal error code, arguments: [17182], [2325084336],
[], [],
rule by support? any idea why toad would
bother slipping it in? From: "John Shaw"
[EMAIL PROTECTED] Date: 2003/10/28 Tue PM 02:59:25
EST To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED] Subject: Re: ora-600 question
TOAD puts a hint in.[EMAIL PROTECTED]
10/28/2003
You can try and see ifthe old oneisin your
oiddas.conf.
and if you haven't deleted your inventory yet it's in
$ORACLE_HOME/inventory/Components21/oracle.iappserver.iappcore/9.0.2.0.1/installlog.xml
[EMAIL PROTECTED] 10/9/2003 5:19:27 PM
Running Infrastructure database from 9iv2 release on
Just 2 minor ones on the
upgrade so far - it had to have the compatible init parameter set - otherwise it
tried to default to Ora 8 and I am using LMT's so it complained. Also I had a
problem with the listener not being able to connect, so I deleted and recreated
a new one - everything
Just a guess - but you
might need to create / configure a provider for forms - also you might check
your display setting in the conf file.
[EMAIL PROTECTED] 9/10/2003 4:49:29 PM
Hi
NT
2000
Oracle
9.0.2.0.1
Oracle 9ias
9.0.2.0.1
Installed infrastructure and tested
are you using the full host
name? webbox.mycompany.com? Is iasdb or whatever you named your infrastructure
instance up and running? [EMAIL PROTECTED] 9/9/2003
8:59:26 AM
Hi All,I am trying to install Oracle 9iAS on Win
2000I installed Infra structure successfully. While trying to install
I'd love to see what you
come up with on this one. [EMAIL PROTECTED] 9/4/2003
11:59:31 AM
During my free time(ha, between developing pages for kid's soccer
association, redcross instructor and board member, family, work), are
you all interested in my discoveries when i start trudging thru
I filed a tar to get all the steps needed to do a new install of 9ias and
bring up to the current patch release 9.0.2.3.
This is their detailed list of instructions:
"
After applying 9iAS 9.0.2.0.1, you can/should apply 9.0.2.3
directly..There are some things you need to do
Title: Message
I have set
up 9ias on both one box (two oracle homes) and on 2 separate boxes. Forms,
reports and java code run from the mid tier, OID runson theinfra
structure. It does seem easier to keep it all straight if they are on separate
boxes. [EMAIL PROTECTED] 9/2/2003 12:59:29 PM
Have you run statistics and
changed your optimizer_index_caching and optimizer_cost_adj
parameters? [EMAIL PROTECTED] 8/11/2003 2:14:28 PM
We recently upgraded an application (Extempore) database from
Oracle7.3.4 to 8.1.7. The clients say the test database, still on
Oracle7.3.4 is much
It maynot be a good
idea from a security perpective - but I know my bosses are looking into purely
for the cost. The idea seems to be keep a core set of people here and outsource
everything else. This is happening at several companies I know of in the
southeast (US). Eventually we will end
Is it possible for a 32 bit database and a 64 bit database (in different
homes) to peacefully coexist on the same server? we currently have that setup
and it seems like random bits of strangeness occur. In this scenario would it
matter which listener the 64 bit or 32 bit that you would use?
It's been awhile since I
worked on this - but I think you can trick it if you make a copy of your net8
directory and name it network. [EMAIL PROTECTED] 7/25/2003
2:39:24 PM
ORACLE Developer 6i come with ORACLE 8.0.6 clientsql*net. Does
their has way to make Developer 6i useORACLE 8i (8.1.7)
There is or at least was a
problem if you had a autonomous transaction across a dblink with a
commit. [EMAIL PROTECTED] 7/24/2003 10:59:27 AM
One of or developers is work on a routine that will trigger a
procedurethat will use a dblink to update a table on another database.
It seemslike I
what are your
optimizer_index_caching
optimizer_index_cost_adj
optimizer_max_permutations
set to?
[EMAIL PROTECTED] 7/9/2003 3:39:31 PM
Few sql queries run fast (less than a second) when I use RULE hint and
without RULE hint it takes 30 seconds. The queries are not that
complicated, but
Refer to Note:139775.1 - see if this helps out - basically it says to
configure the jdbc driver so that it has to use dedicated server - using MTS is
the problem.
[EMAIL PROTECTED] 6/17/2003 7:24:50 AM
OK. Let me get some things straight:a) I'm not a developer. I'm one of
those vile
We have created a monster. I started with a small datamart for the finance
group. Now everyone wants their own - and of course bigger, better, faster, and
linked with all the other data to drill to anywhere. So now I get to pick out
some data warehouse tool to roll all this data together.
do you have any urls with details/dates?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Shaw
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
I've got
installed - my boss likes BMC so we bought it. I really don't use it too much.
It doesn't seem to have much different from OEM - a little better graphics, but
since I have my set of scripts that I've come to rely on I really don't use the
gui stuff a lot except for my freeware
This wouldn't
happen to be Discoverer would it? [EMAIL PROTECTED]
02/27/03 03:24PM Barbara,Don't worry about the explain
plan... What's the BHR looking like?I guess in all seriousness
this query is most likely missing some joinsgiven the CARD result and the
CARTESIAN's in the plan. Have
I normally wouldn't post this kind of thing on this forum - but since the
job market stinks ya'all might know someone who's looking.
Mycompany has an opening for a experienced Solaris admin. We are
installing a F 12k (32processor) and they want somebody with experience on it
and haven't
What version
are you running - I have a similar problem on 9.2.0.2 on Solaris 9 that I've had
an open tar on since November - Support has finally called up and said other
people are having the same kind of problem - especially in regards to parallel
processes. I am supposedly getting a test
I get the error on solaris 9 and 9.2.0.2 except it's 103
Connected.ERROR:ORA-00600: internal error code, arguments:
[ktfthcf-1], [103], [], [], [], [], [], []
[EMAIL PROTECTED] 01/23/03 04:16PM BUT, I don't get the error on
9.0.1.0.0 on Solaris 5.8!-Original Message-Sent: Thursday,
or a
subordinate user?
Check in the USER / DBA_POLICIES view where
the OBJECT_NAME='FACILITY'
-Original Message-From: John Shaw
[mailto:[EMAIL PROTECTED]]Sent: 20 January 2003
15:31To: Multiple recipients of list ORACLE-LSubject:
SQLplus question unusual behavior
I am trying
I bounced the
databases and just like rebooting a pc (even though this db is on solaris) it
started working - one of the mysteries of Oracle - Maybe it was really windy and
it was having sympathy pains with the yacht.
[EMAIL PROTECTED] 01/20/03 08:44PM John Shaw
wrote: I am trying to update
I am trying to update a small table from a remote table with sqlplus
9.2.0.2 .
It seems to indicate that it has inserted 233 row into my local table -
howeverthat doesn't really happen.
Am I suffering from a severe lack of caffine oris this really
odd?
SQL select count(*) from facility;
It's a
table. [EMAIL PROTECTED] 01/20/03 11:04AM
Just a thought - is facility a table or is it some
synonym/view pointingsomewhere
else..Babu|-+---|
| John
Shaw
||
|
John.Shaw@correctio||
|
nscorp.com
||
| Sent
by:
||
|
[EMAIL PROTECTED
defined the table
in lowercase using quotes.CREATE TABLE FACILITY is not the same as
CREATE TABLE "facility".HTH.ArupFrom: "John Shaw"
[EMAIL PROTECTED]Reply-To:
[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]Subject: SQLplus question unusual
b
I had a 9.2/solaris database that I could set compatible 8.1.7 on - but
since I have done the 9.2.0.2. upgrade I can't set compatible below 9 either -
never really needed it so I haven't bothered with metalink/tar.
[EMAIL PROTECTED] 01/13/03 11:16AM I
am trying to apply a "fix" for some
system is data
dictionary - the rest lmt's with uniform extents
[EMAIL PROTECTED] 01/13/03 12:35PM
Were you using any of the new tablespace
features or using dictionary managed tablespaces?
David Ehresmann
-Original Message-From: John Shaw
[mailto:[EMAIL PROTECTED]]Sent: Monday
9.2.0.2, solaris 9 ,
Hitachi san
BeforeIgot herethe company
had a consultant come in and configure the data warehouse instance. One of the
init parameters he set was filesystemio_options=none. The jr. dba that is here
recalled the reason he set it to none because it was using the san - is
It's probably in the fine manual somewhere - but I haven't found it
yet
From my pc:
I can ping the IP address of the server and response time is 10 ms
ping the name of the server and response time is 10 ms
tnsping of IP is 10 ms
but tnsping of the name is 1000 ms
any reason why this would be?
If you ever
findout the problemplease post your findings - I'm going thru a
similar issue (9.2.0.2) [EMAIL PROTECTED] 12/20/02
01:50PM Lindon,We have had a controller card go
intermittently hay-wire and corruptedthe database. It even caused corruption
to read-only tablespaces. It isquite
on instance2. If you specify "as sysdba" it basically
ignores the password if you are authorized as an OS user (belong to group
oracle, for example).
Adam
-Original
Message-From: John Shaw
[mailto:[EMAIL PROTECTED]]Sent: Thursday, December 05,
2002 4:05 PMTo: Multiple
I have 2 instances on a sun box.
instance abc I can connectby just --sys/not_default@abcbut on instance def
I can't connect by
sys/not_default2@def it
gives a
ERROR:ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
I have to use
Nope - they
are both 9.2.0.2 solaris 9 [EMAIL PROTECTED]
12/05/02 02:08PM
Any chance that instance 2 is 9i, and instance 1 isn't?
-Original Message- From: John
Shaw [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 05, 2002 11:34 AM To: Multiple recipients of list ORACLE-L
I'm not having a problem withSolaris 9 and init 6 - in fact I
have to use init 6 to get my scripts to work.
[EMAIL PROTECTED] 12/02/02 07:58AM Has anyone
encountered a problem rebooting a Solaris box using INIT 6 withthe Oracle
dbstart/dbshut scripts enabled?My sysadmin seems to feel the
I
should have said spread across local drives.
[EMAIL PROTECTED] 11/26/02 05:35PM H. I got to thinking
about a previous reply which was while doingsomething else:I
don't think changing the logmembers will do much goodI agree. 4
groups, they are on the local drive.BOOM!!Then got to
you can use the copy command for the longs - but I don't think it
works for long raws - write a pl/sql that pulls it in in 32k chunks or create
temp tables with the pk and long raw and do the insert/update
routine. [EMAIL PROTECTED] 11/25/02 09:59AM
OK, so
you can't CTAS on tables with
I don't think changing the logmembers will do much good - I
have a v880 with 16 GB and a Hitachi san. I have only 3 logmembers - 4
groups, they are on the local drive. I have some kind of performance issue with
periodic slowdowns (47 minutes lgwr cpu in one day on a very low transaction
how about select table_name from user_tables where table_name not
in (select table_name from user_constraints where constraint_type =
'P'); [EMAIL PROTECTED] 11/26/02 01:25PM
Is there an easy query to get a list of tables that don't have
any primarykey? I've tried a couple of different ones,
We had IBM
come in and try to tune the depth queue - apparently there is some bug between
their aix box and the hitachi san - they could only get a depth queue of 1 -
whereas the sun box could go to a depth queue of 32.
[EMAIL PROTECTED] 11/17/02 08:18AM
John,
You should be able to
tune
I am in the middle of this fight myself. We
had an Oracle consultant come in to look at our performance problems. He spent a
3 days examing the sql and coming up with various reasons that our code was
slow. Then the "BUG" cropped up - one of his reports that had been running great
all of a
Foxpro has a upsizewizard to move data into an oracle database.
[EMAIL PROTECTED] 11/15/02 06:03AM
Hi ALL,
Can WE IMPORT DATA from DBF files of Fox Pro into Oracle
8.1.7. If yes how.
TIA
Hussain
I am also having a weird performance issue with a sun box - mine
is a new v880 4 cpu (900mz) with 16g of ram and a 2 T hitachi san. For example -
I do an import of a table (partitioned 3 m rows ) and it takes almost 8 minutes
vs 3 minutes on my laptop. both running 9.2.0 . many reports take
We had an aix
box and ended sending it back and going with sun - only because we had a hitachi
san and there seems to be a bug between ibm and hitachi - something about depth
queue. [EMAIL PROTECTED] 11/13/02 12:48PM
Hello,What are the major differences between AIX and
Solaris
from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Shaw
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Shaw
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
49 matches
Mail list logo