My guess would be that company is not a number but because you do compare
it to a number company=2000 Oracle does an implicit conversion
to_number(company)=2000 and that fails when it hits a row where company
is not numeric.
If my guess is right try company='2000'
At 07:59 PM 1/30/2004, you
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
last post
Wolfgang Breitling wrote:
| My guess would be that company is not a number but because you do
| compare it to a number company=2000 Oracle does an implicit
| conversion to_number(company)=2000 and that fails when it hits a
| row where
When required I did it through a logon trigger ... wait I still do it.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having
Murali,
Have you checked the OS event logs like the system log? Sounds like you
have hit an OS limit. Please post the rest of the error stack that followed
the ORA-12450 as this gives more information on what is the root cause of
this failure? You can find this in the listener.log at the time
:
|
| Subject: Re: ORA-12540: TNS: internal limit restriction exceeded
|
| ||
|-+
---
---|
|
|
| To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED] |
| cc:
|
| Subject: Re: ORA-12540: TNS: internal limit restriction
exceeded
|
| ||
|-+
---
---|
|
|
| To: Multiple recipients of list
ORACLE-L
[EMAIL PROTECTED]
|
| cc:
|
| Subject: Re: ORA-12540: TNS: internal
limit restriction
exceeded
Oradebug is the right way to go because, for some reason,
alter system set events='904 trace name errorstack forever, level 10';
doesn't do anything. The only way to activate trace is to go to
oradebug,
attach the session (of course, one needs to do gymnastics with V$SESSION
and V$PROCESS to find
Hi!
Note that when you set an event with alter system, it will only apply for
new sessions created, not for any existing ones.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 4:19 PM
Oradebug is the right way to
On 01/20/2004 02:59:35 PM, Tanel Poder wrote:
Hi!
Note that when you set an event with alter system, it will only apply
for
new sessions created, not for any existing ones.
And that, exactly is the problem. First, when you set event using
alter system, the setting is system wide. Second, if you
You can also use DBMS_SYSTEM.SET_INT_PARAM_IN_SESSION and
DBMS_SYSTEM.SET_BOOL_PARAM_IN_SESSION, in lieu of oradebug.
-Mark
Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
Imagination was given to man to compensate him for what he is not, and
a sense of humor was provided to console him
But you can't set events with it :(
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 10:39 PM
You can also use DBMS_SYSTEM.SET_INT_PARAM_IN_SESSION and
DBMS_SYSTEM.SET_BOOL_PARAM_IN_SESSION, in lieu of oradebug.
For that, there is DBMS_SYSTEM.SET_EV. ;-)
-Mark
Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
Imagination was given to man to compensate him for what he is not, and
a sense of humor was provided to console him for what he is. --Unknown
-Original Message-
Sent: Tuesday,
One thing I've been looking for is a way to set a string parameter in
another session, The two you mention handle INTEGER and BOOLEAN. I want
a way to set TRACEFILE_IDENTIFIER to a string in another session to make
it easier to identify trace files.
Any ideas?
Stephen
[EMAIL PROTECTED]
Ok, yeap I confused this with READ_EV, which can't read event from other
sessions...
Great job ;)
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 11:19 PM
For that, there is DBMS_SYSTEM.SET_EV. ;-)
-Mark
Mark
On 01/20/2004 03:39:25 PM, Bobak, Mark wrote:
You can also use DBMS_SYSTEM.SET_INT_PARAM_IN_SESSION and
DBMS_SYSTEM.SET_BOOL_PARAM_IN_SESSION, in lieu of oradebug.
Thanks, Mark! I've learned something from you today! Who says
that one cannot teach an old bear new tricks.
--
Please see the official
It turns out that the user had configured TOAD to use a table filter, which causes it
to create and store a query. As you've probably guessed, the query was referencing a
column which no longer exists.
On a related note, I initially tried to capture the failing query using alter system
set
I went through a similar problem with the 904 error. I had to use oradebug
to get a trace file to be produced.
Good luck,
Chris
-Original Message-
Sent: Monday, January 19, 2004 8:14 AM
To: Multiple recipients of list ORACLE-L
It turns out that the user had configured TOAD to use a
Dear Friends,
(B
(BThank you so much. Yes i was able to solve this issue..
(B
(BFYI ... I used CONVERT function
(B
(B
I'm having an ora-1555 under Oracle9 database and not
sure what I can do to get rid of it. I had some
recollecions from Oracle8 days , but the things like
adding a new rollback segment or shrinking the
segments I don't think are applicable under the auto
undo management. Besides separating
Does his version of TOAD support your Oracle server version ? We tried to
run our (outdated) version of SQL Navigator against a 9i DB and would get
weirdness like this from time to time when accessing the Oracle data
dictionary.
mvg/regards
Jo
Norris, Gregory T [ITS] [EMAIL PROTECTED]
Success! I've now learnt, from our network security admin guy, that the
Firewall Manager on the new network is configured by default to timeout
inactive connections after 60 minutes. Even though all the user clients
are inside the firewall, the server is specially ringfenced because the
Have you considered enabling DCD? This causes oracle to send pseudo-keepalive packets
periodically, which should keep your sessions active from the firewall's perspective.
You enable this by adding
sqlnet.expire_time = ??
to sqlnet.ora on the DB server, where ?? is the frequency (in
--- Norris, Gregory T [ITS]
[EMAIL PROTECTED] wrote:
Have you considered enabling DCD?
Greg,
short of migrating to *nix, dead connection detection
does not work on win32. not in 8.1.7.4, not in
9.2.0.4.
possibly in 10g? ;)
Pd
This causes
oracle to send pseudo-keepalive packets
Paul
Sounds suspiciously like an issue we had when se set up our latest system -
something in the firewall or network set-up has a TCP time-out in it. TCP
(or the network or something I'm no network expert) drops the connection
after 60 minutes resulting in client and Oracle server no longer
Hi Paul,
I'd start with reading Anita Bardeen's paper,
available on the NYOUG site:
http://www.nyoug.org/presentations.htm
ORA-3113's, 600's and 7445's Oh My!
Are these connections local, like on the same subnet,
or is there a firewall or router in between that could
be performing network
If the restore/recovery thing from backup doesn't work (it usually
does), it's time to panic in a controlled fashion...
Dump the block to see if it's a hard or soft corruption.
A hard corruption is when some kind of stray write has hit the block,
causing one of many checks against eg the rows
Yup, there are some nice ways for restoring even parts of a datablock using
contents from corresponding indexes... or if it's an index block (just a
plain count(*) can use indexes as well if all rows are quaranteed to be
indexed), then you can just rebuild the index. So, nothing is lost, until
Title: Message
1.)
Restore datafile from backup.
2.)
recover datafile;
3.)voila!
Of
course, you mileage may vary. Do you have a valid backup? Is it hot
or cold? RMAN/conventional? etc,etc
Mark J.
Bobak Oracle DBA ProQuest Company
Ann Arbor,
MI "Imagination
was given to man to
Title: ORA-01578 data block corrupted
Run dbv on the datafile.
Also there is a document on Metalink which describes how to handle data
block corruption.
Use the folliwng query to get segment name
SELECT TABLESPACE_NAME, SEGMENT_TYPE, OWNER, SEGMENT_NAMEFROM
DBA_EXTENTSWHERE FILE_ID =
If you have access to Metalink:
Check Note:28814.1
Haven't had to use it, hopefully never will.
HTH,
Mike
Nguyen, David M
if you got rman backup and 9i, you can do block level recovery.
joe
Bobak, Mark wrote:
1.) Restore datafile from backup.
2.) recover datafile;
3.) voila!
Of course, you mileage may vary. Do you have a valid backup? Is it
hot or cold? RMAN/conventional? etc,etc
Mark J. Bobak
Title: ORA-00600 signalled while mounting the database from the second instance of Oracle9i RAC
Have you looked up on Metalink? there is ton of information out
there.
Raj
Rajendra dot Jamadagni at nospamespn dot
This is scary,
I'm planning to upgrade 9.2.0.4 from 9.2.0.2.
I don't know how
removing pga_aggegrate_target will help reducing
memory!!
Does the program
have any memory tables, etc?
Did you monitor
the PGA size from the Oracle side using v$sesstat?
A sql by itself
can't consume this
Sorry. I read your email twice and
still have not seen a question. Are you wondering if this is normal?
:)
Tom Mercadante Oracle Certified
Professional
-Original Message-From: Jeffrey Beckstrom
[mailto:[EMAIL PROTECTED]Sent: Tuesday, December 23, 2003 10:39
AMTo: Multiple
I'm using auto pga allocation on 9.2.0.3 without any problem.
You don't mention which version.
You can turn it off with 'alter system set workarea_size_policy=manual;
Jared
On Tue, 2003-12-23 at 07:24, Jeroen van Sluisdam wrote:
Hi,
I have an ora-4030 problem related to pga memory
PROTECTED]
Verzonden: dinsdag 23 december 2003 18:34
Aan: Multiple recipients of list ORACLE-L
Onderwerp: Re: ora-4030 pga memory allocation running wild
I'm using auto pga allocation on 9.2.0.3 without any problem.
You don't mention which version.
You can turn it off with 'alter system set
Are you sure they are not loading blobs into SYSTEM tablespace?
Guang
-Original Message-
Sands, Robyn
Sent: Thursday, December 18, 2003 11:29 AM
To: Multiple recipients of list ORACLE-L
This message is in MIME format. Since your mail reader does not understand
this format, some or all
, December 18, 2003 12:34 PM/FONT
BRFONT SIZE=3D2To: Multiple recipients of list ORACLE-L/FONT
BRFONT SIZE=3D2Subject: RE: ORA-1652: temp segment in tablespace SYSTEM=
?!?/FONT
/P
BR
BR
PFONT SIZE=3D2Are you sure they are not loading blobs into SYSTEM table=
space?/FONT
/P
PFONT SIZE=3D2Guang/FONT
do you have temporary tablespace set for that user?
-Original Message-
Guang Mei
Sent: Thursday, December 18, 2003 12:34 PM
To: Multiple recipients of list ORACLE-L
Are you sure they are not loading blobs into SYSTEM tablespace?
Guang
-Original Message-
Sands, Robyn
Sent:
I think you may hitting a bug as per following details from metalink...You
may open a tar for a workaround...
Doc ID: 49397.1
As per above another oracle note you are setting any duration for this
sesion which may be avoided...meaning have you assigned any profile to that
user running export
Thanks Rafiq.
BTW I am not setting any duration limit directly or thru profile.
-Original Message-
Rafiq
Sent: Sunday, December 14, 2003 5:19 PM
To: Multiple recipients of list ORACLE-L
I think you may hitting a bug as per following details from metalink...You
may open a tar for a
Sami,
I think it is better to open an itar to resolve this issue...
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Sun, 14 Dec 2003 14:34:25 -0800
Thanks Rafiq.
BTW I am not setting any duration limit directly or thru profile.
You may check the distributed_transaction parameter on your databases.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, December 05, 2003 1:54 PM
Hello @all,
maybe this is a newbie question (at least I am)
I've
Subject: RE: ORA-1000 and pl/sql cursor cache
Try playing with alternately setting session_cached_cursors
to 0 and some non-zero value and run the following script.
Try setting _close_cached_open_cursors to both true and
false, changing which 'commit' is used, and omitting the
'commit
To: Multiple recipients of list ORACLE-L
Subject: Re: ORA-1000 and pl/sql cursor cache
David:
I don't really know if this will help you, but it
might be worth a try. You could try setting session_cached_cursors.
Bjørn Engsig's white paper Efficient use of bind
variables
.
--
David Lord
-Original Message-
From: Barbara Baker [mailto:[EMAIL PROTECTED]
Sent: 26 November 2003 16:49
To: Multiple recipients of list ORACLE-L
Subject: Re: ORA-1000 and pl/sql cursor cache
David:
I don't really know if this will help you, but it
might be worth a try
David:
I don't really know if this will help you, but it
might be worth a try. You could try setting
session_cached_cursors.
Bjørn Engsig's white paper Efficient use of bind
variables, cursor_sharing and related cursor
parameters describes this parameter a bit. It can be
found at
are you looking for the init.ora max_open_cursors(dont think i typed it exactly right).
even if the cursors are cached, they should not be counted as open. they doesnt make
sense from an oracle design standpoint.
From: Lord David [EMAIL PROTECTED]
Date: 2003/11/26 Wed AM 10:34:34 EST
To:
Igor,
I can't remember exactly where I read it, but under Oracle
9i the DLL or SO file(unix) needs to be in either $ORACLE_HOME/bin or
$ORACLE_HOME/lib only.
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Igor Neyman
[mailto:[EMAIL
Actually, it doesn't. The lib needs to be in the LD_LIBRARY_PATH
with which oracle was started. So, you could do a thing like this:
mkdir /home/mgogala/lib;
cp usrslib.so /home/mgogala/lib
chmod -R 755 /home/mgogala/lib
Title: Message
This
is new features of 9.2. The same on LINUX.
oerr ORA 2859528595, 0,
"Extproc agent : Invalid DLL Path"// *Cause: The path of DLL supplied
for the extproc execution is invalid.// *Action: Check if the DLL path is
set properly using the
EXTPROC_DLLS//
environment
: Monday,
November 24, 2003 12:35 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: ORA-28595 when
calling external proc
Igor,
I can't remember exactly where I read it, but under Oracle 9i the
DLL or SO file(unix) needs to be in either $ORACLE_HOME/bin or $ORACLE_HOME/lib
only
To: Multiple recipients of list
ORACLE-L
Subject: RE: ORA-28595 when
calling external proc
This is new features of
9.2. The same on LINUX.
oerr ORA 28595
28595, 0, Extproc agent : Invalid DLL Path
// *Cause: The path of DLL supplied for the extproc execution is invalid.
// *Action
Well!! You didn't say itthat eXtreme Perversion was the
OS.
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Igor Neyman
[mailto:[EMAIL PROTECTED]Sent: Monday, November 24, 2003 1:20
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
ORA
recipients of list
ORACLE-L
Subject: RE: ORA-28595 when
calling external proc
$ORACLE_HOME/bin is where
I put my dll.
Whats puzzling is
that it works under 8.1.5/NT or 9.2/Win2000, but not under 9.2/XP.
Igor Neyman, OCP
DBA
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL
DBAOracle Certified 8i
DBA
-Original Message-From: Igor Neyman
[mailto:[EMAIL PROTECTED]Sent: Monday, November 24, 2003 3:24
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
ORA-28595 when calling external proc
My
bad.
Thanks to everyone
who replied
Problem solved thanks to ots
Event 1399 solved it, necessary during migrate
Regards,
Jeroen
-Oorspronkelijk bericht-
Van: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]
Verzonden: Thursday, November 20, 2003 21:46
Aan: 'Jeroen van Sluisdam'
Onderwerp: RE: ora-600 / ora-00604 during migrate
Jeroen - What priority did Oracle assign the TAR? Given the seriousness of
your situation, you should get it rated a priority 1. Is there any
possibility you can export/import your data instead of performing a
migration?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original
-Oorspronkelijk bericht-
Van: Jeroen van Sluisdam
Verzonden: donderdag 20 november 2003 21:41
Aan: 'DENNIS WILLIAMS'; '[EMAIL PROTECTED]'
Onderwerp: RE: ora-600 / ora-00604 during migrate
Dennnis,
Priority 2. I have tried export but after 3 days of experimenting
And not getting
: donderdag 20 november 2003 21:41
Aan: 'DENNIS WILLIAMS'; '[EMAIL PROTECTED]'
Onderwerp: RE: ora-600 / ora-00604 during migrate
Dennnis,
Priority 2. I have tried export but after 3 days of experimenting
And not getting results I switched to this scenario
How could I persuade them to go to priority
, November 06, 2003 4:44 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: ORA-911 during DBD::Oracle prepare
It works! It works, it works!
On 11/06/2003 05:14:24 PM, Alan Gano wrote:
DBI is able to use named binds
e.g.,
my $cursor=$$self{conn}-prepare(q{
select
. The difference between me and other idiots is
that I know I'm an idiot.
-Original Message-
From: Mladen Gogala [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 06, 2003 4:44 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: ORA-911 during DBD::Oracle prepare
It works
recipients of list ORACLE-L
Subject: Re: ORA-911 during DBD::Oracle prepare
It works! It works, it works!
On 11/06/2003 05:14:24 PM, Alan Gano wrote:
DBI is able to use named binds
e.g.,
my $cursor=$$self{conn}-prepare(q{
select column_name from
Disclaimer: I'm an idiot. The difference between me and other idiots is
that I know I'm an idiot.
-Original Message-
From: Mladen Gogala [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 06, 2003 4:44 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: ORA-911
Don't you want SELECT machine, program, SYS_CONTEXT(?, ?),
SYS_CONTEXT(?, ?)...
DBI uses positional binds as opposed to named binds.
On Thu, 2003-11-06 at 16:29, Jesse, Rich wrote:
Hey all,
I'm trying to get a simple query running in Perl 5.6.1, DBI 1.30,
DBD::Oracle 1.14, Oracle 8.1.7 on
Rich!
Take the ending semi-colon off. It's not SQL, but a end-of-statment flag to
Sqlplus, which you are not using.
Alan.
-Original Message-
Sent: Thursday, November 06, 2003 1:29 PM
To: Multiple recipients of list ORACLE-L
Hey all,
I'm trying to get a simple query running in Perl
DBI is able to use named binds
e.g.,
my $cursor=$$self{conn}-prepare(q{
select column_name from
dba_cons_columns
where
(owner,constraint_name) = (
select owner, constraint_name
from dba_constraints
where
owner =
:[EMAIL PROTECTED]
Sent: Thursday, November 06, 2003 3:49 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ORA-911 during DBD::Oracle prepare
Rich!
Take the ending semi-colon off. It's not SQL, but a
end-of-statment flag to
Sqlplus, which you are not using.
Alan
Now, this something I've never used. I will try it.
Thanks for teaching an old dog the new trick.
On 11/06/2003 05:14:24 PM, Alan Gano wrote:
DBI is able to use named binds
e.g.,
my $cursor=$$self{conn}-prepare(q{
select column_name from
dba_cons_columns
where
I tested named binds and they work. I should have read the #$%^! manual.
Oh, well.
On 11/06/2003 05:29:31 PM, Mladen Gogala wrote:
The problem are bind parameters. With DBI, you don't specify bind variables
by name, you have to use positional binds. Your statement should read
something like
It works! It works, it works!
On 11/06/2003 05:14:24 PM, Alan Gano wrote:
DBI is able to use named binds
e.g.,
my $cursor=$$self{conn}-prepare(q{
select column_name from
dba_cons_columns
where
(owner,constraint_name) = (
select owner,
The problem are bind parameters. With DBI, you don't specify bind variables
by name, you have to use positional binds. Your statement should read
something like this:
my ($usrenv,$ip,$osuser,$mach,$prog,$c1,$c2);
$sth = $dbh-prepare(q{
DECLARE
usrenv vachar2(32) :=?;
ip
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
:-Behalf Of
:-DENNIS WILLIAMS
:-Sent: 04 November 2003 19:19
:-To: Multiple recipients of list ORACLE-L
:-Subject: RE: ORA-24314
:-
:-
:-Nuala
:- This was discussed recently on this list, but not to a definite
:-conclusion. The speculation
Hi Shibu
(Still going to GOA at new year then ??)
I would get your shm-max upped.
Regards
Lee
-Original Message-
Sent: 04 November 2003 13:39
To: Multiple recipients of list ORACLE-L
Hi friends ,
I am getting the following error when trying to take the database to nomount
state .
Nuala
This was discussed recently on this list, but not to a definite
conclusion. The speculation is that is probably a firewall issue. Your VPN
probably has to go through a firewall, which is probably open for normal
telnet type activities like a terminal connection. But connecting to
Oracle
Hi Branimir,
Two Suggestions:
1. This looks like having an issue with foreign key indexes. You can check for foreign
keys and
their indexes for tables having objects-id 17786 (457a)and 17775 (4571). If any
of the columns
of these two tables have foreign key relationship with other
Avnish
Glad to see you are getting some excellent suggestions. We run Lawson
here. Lawson itself uses the database in a pretty simple manner, so that
rules out a lot of stuff, except if you've added customizations of your own.
Lawson uses bind variables, so that rules out some suggestions. I
Well, you neet to check the full error, because otherwise there's no
way to tell if you are running low on shared or large pool.
The view that shows space usage in both places in v$sgastat. I
suggest you start looking there. Maybe your third-party application
doesn't use bind variables and is
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 29, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: ORA-4031 error help.
Well, you neet to check the full error, because otherwise there's no
way to tell if you are running low on shared or large pool.
The view that shows
Full error message is
ORA-04031: unable to allocate 4032 bytes of shared memory (large pool,unknown
object,session heap,frame segment))
I am already monitoing both shared pool and large pool free memory every 30 minutes
and there is no issue with that. As I mentioned below Oracle is not
Make sure you are pinning your large and often executed packages,
triggers, procedures, etc in the shared pool (should be done at
startup). That will help eliminate fragmentation.
select 'execute dbms_shared_pool.keep('||chr(39)||
owner||'.'||name||chr(39)||','||chr(39)||
How often does the error occur? How many sessions are connected when
the error occurs? What is the status of the shared pool reserved? If
you flush the SGA does the error clear for a period?
Also, in 8i there used to be a bug that required setting
_db_handles_cached=0
Regards,
-Daniel
--
The standard question would be Have you made any recent changes to code,
patches, parameters, etc?
But I saw cursor_space_for_time = true in your init.ora and you've increased
open_cursors from 500 to 750 few days ago, these can cause excessive memory
usage for example.
Also, you might want to
Do you have cursor_sharing set?
Long term : Have the developers use bind variables. Short term identify the sql doing the most damage by looking at sql being reparsed etc. Fix them to use bind variables if possible.
About alert.log some errors go to alert.log some errors do not.
Do you have
It may have to do with an object not being able to load into SGA because of
not enough contiguous memory in the SGA. It happens in MTS environments. Try
pinning your larger objects.
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 29, 2003 12:39 PM
To: Multiple
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],
[], [],
What version of TOAD, Oracle server and Oracle client? See Metalink article
34779.1 for details on your bug, which may be fixed in releases 8.1.7.3,
9.0.1.2 and 9.2.0.1.
BTW, TOAD can put in hints, but more importantly, it can do some
conversion/translation of your SQL before sending it. You
ORACLE-L
does the data dictionary still use 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
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
does the data dictionary still use 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
/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 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
If there're already hints like ordered and use_nl that tell Oracle how to join,
lack of statistics is less of a problem. In fact, you may need to use those two
hints in some queries against data dictionary even in pre-9i Oracle.
Yong Huang
--- Tanel Poder [EMAIL PROTECTED] wrote:
Hi!
Just
Depending on the query, in dba_extents example there are hints only in one
part of multi-part union all SQL, but nevertheless, good point :)
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 29, 2003 1:04 AM
If there're
There is/(are)
known bug/(s) in 9.2.0.3 where the shared pool becomes fragmented and will
refuse to un-fragment itself. Attempts to flush the shared pool
fail. So far, based own our experience here, this seems to be fixed in
9.2.0.4.
Things like shared
pool details tend to leak out of my
Title: Re: ORA-4031 errors no a high Load Database
Vivek,
You are using MTS/SS; have you configured the Large Pool to accommodate all of the UGA structures? If you do not have the Large Pool configured from its default of 0, then all of the UGA (i.e. session global areas, shared amongst
Well, it's easy. You're doing shutdown immediate during the procedure
execution. do shutdown abort and you'll get rid of the error message.
On 2003.10.26 16:14, [EMAIL PROTECTED] wrote:
Hi List
I am in the process of setting up Oracle Streams and getting the following
error
*** 2003-10-26
No. I did not shutdown the oracle DB. It is an oracle bug.
Problem:-
BEGIN
DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(
privilege = DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ,
grantee = 'STRMADMIN',
grant_option = TRUE);
DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(
privilege
This is the error message:
ORA-01089: immediate shutdown in progress - no operations are permitted.
Either you shut the database down or somebody else did. You didn't buy a
Halloween edition of oracle, did you? If you think it's a bug, you'll have to
show the trace file of the failed
David,
Take a look at Note 19332.1, which explains the error and what to do next.
In short, the essence of the note is: The error comes if the time waited is
mor than the value of the distributed_lock_timeout parameter. Even if you do
a select from the remote database, it acquires a TX lock and
1 - 100 of 1077 matches
Mail list logo