How does dba_jobs decide what it's nls_env values are?.
They seem to vary according to whether I queue the job from a windows client
or from unix.
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services
the query, it is NOT using the correct explain
plan.
If I 'alter system
set use_stored_outlines = false;' then the query uses the correct
plan.
I also noticed that
outline_category in v$sql is NULL. Does this mean that they outline
is not being used? I assume not.
Thanks
all,
John
John
Title: String manipulation
I
wrote a PL/SQL package with functions you can use for this. Find it
athttp://www.smdi.com/employee/johnf/list.pks
andhttp://www.smdi.com/employee/johnf/list.pkb.
I wrote it so that only the first call parses the string. Subsequent
calls use the already parsed
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 the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Flack
INET: [EMAIL PROTECTED]
Fat City Network
: http://www.orafaq.net
--
Author: John Flack
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself
Title: Message
Mauricio:
Is
job_queue_processes set to a value higher than 0?
Did
you commit after submitting the job?
John R. Johnson Anheuser-Busch Companies Server Technology and DBA Services Oracle Database
Administration
-Original Message-From:
Michael Fontana [mailto:[EMAIL
Do you
have 4 jobs currently running? Maybe you need more
processes.
John
-Original Message-From: Mauricio "VĂ©lez
[mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004
11:04 AMTo: Multiple recipients of list ORACLE-LSubject:
Re: Jobs are not working
I issued c
,
this assumes that there is adeqauet Shared pool space and the Db is not
restarted in-between :)
YMMV!
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)
Grace - Getting something we do NOT deserve
Mercy - NOT getting something we DO deserve
Click on 'http://www.needhim.org' for Grace and Mercy
, 2004 11:09 PM
To: Multiple recipients of list ORACLE-L
Perhaps I got it wrong, but, John - are you saying that the entries are part
of the rollback, i.e. if the transaction that caused the audit trail entries
to be created is rolled back, the audit trail enries are rolled back as
well?
The auditing
Title: Metalink on the blink
Painfully slow, but it works.
-Original Message-
From: Adams, Matthew (GECP, MABG,
088130) [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 22, 2004
9:59 AM
To: Multiple recipients of list
ORACLE-L
Subject: Metalink on the blink
Is anyone else
Does anyone have examples of how to use bind variables in VB when using
OO4O?
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John
, 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 the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Flack
INET: [EMAIL PROTECTED]
Fat City
encoded content removed -- binaries not allowed by ListGuru
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists. If you want a copy of the attachment which was
removed, contact the sender
problems though at the time of split...
YMMV!
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)
Disappointment is inevitable, but Discouragement is optional!
** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **
-Original
11i
recommendations? DO you see the explain plan for this particular SQL? Is
this slowdown new or has existed previously? Can you process a smaller set
(with Start/End invoice numbers)? These are some things to try, rather than
wait on Oracle Support...
John Kanagaraj
DB Soft Inc
Phone: 408-970
A bit off the wall this one...
Anyone ever tried to monitor other devices on the network from a pl/sql or
java package using snmp?
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
a 4031 ...
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)
Listen to great, commercial-free christian music 24x7x365 at
http://www.klove.com
** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **
08:35:00 SQL
Rick,
I forgot about shared_pool_reserved_size and the min_alloc parameter (hidden
since 8i). See Note 146599.1 Diagnosing and Resolving Error ORA-04031.
John
-Original Message-
From: John Kanagaraj [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 13, 2004 2:59 PM
To: Multiple
/ShadowImage. And placing an RMAN backed-up DB in SUSPEND mode will only
aggravate users :)
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)
Listen to great, commercial-free christian music 24x7x365 at
http://www.klove.com
** The opinions and facts contained in this message are entirely mine and do
cache of a SAN and delay the split.
I found ML Note:91059.1 useful in understanding the SUSPEND command...
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)
Grace - Getting something we do NOT deserve
Mercy - NOT getting something we DO deserve
Click on 'http://www.needhim.org' for Grace
Dick/John
Thanks for all your input. I conclude from this discussion that it is not
possible to have different, seperate external procedure listeners for
different SIDs in the same instance at least not in 8.1.7.
Incidentially, I have been having an issue with running an rsh command via
8.1.6.0.0 and 9i on server HP proliant ML 350, with os
of windows 2000. I need to get this working by 2 days. So I really need
help on this, thanks.
Regards
Wendry.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Flack
INET: [EMAIL PROTECTED]
Fat City Network Services
processors are verboten.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Friday, January 09, 2004 5:29 AM
To: Multiple recipients of list ORACLE-L
Dick/John
Thanks for all your input. I conclude from this discussion that it is not
possible to have different
for sure that he has
worked on many RAC installations so you *might* get something from there...
As ever, this is my $0.02 (which is not worth much against the Euro!), and
carries my standard disclaimer.
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)
Grace - Getting something we do NOT deserve
Dear All,
I have found this Perl script that makes an analysis
of 10046 SQL trace
http://brainshed.com/software/
Kind Regards,
Hatzistavrou Yannis
the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
to fight all
those fires. Oh, and if you have no activity on the database, that sucker
just flies. Combine the two, and you don't have to work 45 hours a week.
HTH,
Bambi.
-
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Flack
INET: [EMAIL PROTECTED]
Fat City
= /u03/app/oracle/product/9.2.0.1.0)
(PROGRAM = extproc)
(ENV = EXTPROC_DLLS=ANY)
)
)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
)
(ORACLE_HOME = /u03/app/oracle/product/9.2.0.1.0)
(PROGRAM = extproc)
(ENV = EXTPROC_DLLS=ANY)
)
)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
, (because, for example I wanted them to run as 2 different application
users rather than oracle or use 2 different sets of .so files), I could not
do it?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Flack
INET: [EMAIL PROTECTED]
Fat City Network Services
and external procedures, each with its own LISTENER.ORA and TNSNAMES.ORA under its own
Oracle Home. Just be careful about how the TNS administration directory is set.
-Original Message-
Sent: Thursday, January 08, 2004 9:54 AM
To: Multiple recipients of list ORACLE-L
John
is bad'!) - this will invalidate SQLs resulting in
parsing (and thus latching).
Hth,
John KanagarajDB Soft IncPhone: 408-970-7002
(W)Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com** The opinions and
facts contained in this message are entirely mine and do
Daniel
How can i use the v$undostat.maxquerylen value to configuure the undo
tablespace?
Also, how can I tell what the longest transaction is actually doing?, i.e
what sql is being run?
John
-Original Message-
Sent: 05 January 2004 17:54
To: Multiple recipients of list ORACLE-L
we have a standard desktop or laptop image
whichwe install the client and create a package containing the
change, we then push to the pc's that require the oracle client.
We use onames with a primary and secondary
name server.
-Original
Message-From: [EMAIL PROTECTED]
for 1652 (among
others) and record all the details into either alert.log (via
dbms_system.ksdwrt call), database table, utl_file etc.
Hth,
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)
Disappointment is inevitable, but Discouragement is optional!
** The opinions and facts contained
Steve,
I have an awk script which does something similar - see code and example below
However I can put your file on my site where I have already stored your Perl script
for getting the DDL out of an export file ( www.hcresources.co.uk) if you wish.
Cheers
John
Service :Host :User
Sorry - meant to send just to Steve
Please ignore
-Original Message-
Hallas, John, Tech Dev
Sent: 05 January 2004 11:19
To: Multiple recipients of list ORACLE-L
Steve,
I have an awk script which does something similar - see code and example below
However I can put your file on my
a paper on
this last IOUG, but couldn't go and present it :(
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)
Grace - Getting something we do NOT deserve
Mercy - NOT getting something we DO deserve
Click on 'http://www.needhim.org' for Grace and Mercy that is freely
available!
** The opinions
Dear All,
I am faced with the following situation.
Oracle 8.1.7.4. 64 bit , Solaris 8
There is a loader java process that when is executed
against a test database(dwdsa)the response time is as expected to be. However
when it is executed against the production instance (dwods) it is
Thanks Jared
You should probably investigate why it continues to grow so large
Whats the best way to go about identifying any large transactions?
John
-Original Message-
Sent: 31 December 2003 04:34
To: Multiple recipients of list ORACLE-L
The data file(s) for your undo tablespace
get one.
Alternately, you may ask Mogens for a copy.
John KanagarajDB Soft IncPhone: 408-970-7002
(W)Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com** The opinions and
facts contained in this message are entirely mine and do not reflect those of my
employer
I have recently installed Standard Engine 9.2 on AIX 5.2 and notice that the
undotbs01.dbf file just keeps on growing. It is now over 1 GB.
What could be the reason for this? Can I limit it's size and would this
cause a problem too?
John
--
Please see the official ORACLE-L FAQ: http
due to incorrect or stale statistics. Projects in the new year
include revisting the Stats gathering schedules of all our 90+ databases,
some of which are analyzed daily :(
Have a happy, blessed new year all!
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)
Listen to great, commercial-free
and Change
Control
Happy New Year all!
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)
Grace - Getting something we do NOT deserve
Mercy - NOT getting something we DO deserve
Click on 'http://www.needhim.org' for Grace and Mercy that is freely
available!
** The opinions and facts contained
if this
indeed does use a Dblink or it is from somewhere else... [See the problem
with Statspack?!]
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)
Grace - Getting something we do NOT deserve
Mercy - NOT getting something we DO deserve
Click on 'http://www.needhim.org' for Grace and Mercy
/*Os_proc*.trc in the case of a UNIX based
11i DB server). Although this would have been just a SQL_TRACE (10046 Level
1), you can *still* run a tkprof on it to determine which SQL consumed the
most time
Hth,
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)
Disappointment is inevitable
Dear All,
Seasons Greetings.
I have the following problem:
My system is a Oracle EE 8.1.7.4 64bit on Solaris 8 .
The last days the datawarehouse people complain that
their load process which inserts data into tables is half time as fast as it
was two days ago.
From
to be able to create the tablespaces with multiple data
files but it seems whenever I add a datafile the
performance of the load degrades.
Any ideas??
Thanks in advance
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Blake
INET: [EMAIL PROTECTED]
Fat City Network
Would this help?
CREATE OR REPLACE TRIGGER [schema].[trigger_name]
BEFORE [CONDITIONS] ON [table_name]
FOR EACH ROW WHEN ( ( USER != '[USERNAME]' )
AND ...
John P Weatherman
Oracle Database Administrator
Replacements, Ltd.
-Original Message-
Sent: Friday, December 19, 2003 2:49
-dead now and can not seem to find if it can be done and/or how it can be
done.
TIA.
Guang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Flack
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
import.
Is there a tried and true way to just refresh the table data without
losing anything else and without having all the problems with triggers
and constraints?
Thanks!
Ron
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Flack
INET: [EMAIL PROTECTED]
Fat
Any reference concerning the rman?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, December 12, 2003 10:19 PM
Yes. It's called RMAN.
On 12/12/2003 02:04:46 PM, John wrote:
Do you know any script for doing export and backup of Oracle 9i
precisely targeted promotions. Many retail banks also made errors
in sequencing. They invested in popular customer relationship management
systems before they had built repositories of consistent and reliable
customer data. Not surprisingly, the CRM investments fell well short of
expectations.
John
Do you know any script for doing export and backup of Oracle 9i R2
server?My oracle is on a SuSE linux.
no of changes) - or ETL as it is called these days, using PERL as the
mechanism.
I host the zip file on my site at http://www.hcresources.co.uk/perlscript.shtml
I hope someone finds it useful. If they do thank Steve.
HTH
John
-Original Message-
Sent: 11 December 2003 12:55
principle: Ask for 10% of the $$
allocated for the h/w that would have otherwise been spent on *trying* to
solve the problem by throwing h/w at it! (Cary - correct me if I erred
here!)
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)
Grace - Getting something we do NOT deserve
Mercy - NOT getting
defences against (potential) performance problems.
Anyone been-there-done-that ?
Regards,
PdV
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Flack
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego
: http://www.orafaq.net
--
Author: John Flack
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself
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 the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hatzistavrou John
INET: [EMAIL PROTECTED]
Fat City Network
and assembler (IBM mainframe) in the early 70's.
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Flack
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list
--- Yechiel Adar [EMAIL PROTECTED] wrote:
Are you sure that Crystal does not do any local
processing on the data?
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Flack
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Thanks for all the replies...I'm wading through them!
One more question...Do I always need to specify the full path of a Unix
command e.g /usr/bin/mv rather then just mv
That is something I don't currently need to do when using an external
procedure.
John
-Original Message-
Sent: 04
]
1916 General theory of relativity. Gravity is a warping of space-time. -
Albert Einstein
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Flack
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
9i imp handles 8i dmp files. 9i exp does not like to connect to 8i databases though.
At least that has been my experience migrating one of our 3rd party DBs.
John P Weatherman
Oracle Database Administrator
Replacements, Ltd.
-Original Message-
Sent: Friday, December 05, 2003 1:34 PM
I need a java package that will allow me to run OS commands(Unix) from a
stored procedure.
Anyone got one?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San
04, 2003 10:09 AM
To: Multiple recipients of list ORACLE-L
John, it is available on asktom as well, but read the caution Tom explains. Restrict
it to only executables you want. Asktom has example.
Raj
Rajendra dot
Which book is that?
-Original Message-
Sent: 04 December 2003 14:35
To: Multiple recipients of list ORACLE-L
its in tom kytes first book. might be on his webpage.
From: John Dunn [EMAIL PROTECTED]
Date: 2003/12/04 Thu AM 08:49:25 EST
To: Multiple recipients of list ORACLE-L
ORACLE-L
John, it is available on asktom as well, but read the caution Tom explains.
Restrict it to only executables you want. Asktom has example.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed
Dick, harsh words, hmmm? Powerful tools can also be powerful weapons in the wrong
hands. But don't blame the toolmaker.
John, the reason that running an OS command is such a hassle is that it can be
horribly destructive to your server. An OS command that runs from a Java Stored
Procedure
an opinion is an art !
-Original Message-
Sent: Thursday, December 04, 2003 1:29 PM
To: Multiple recipients of list ORACLE-L
Dick, harsh words, hmmm? Powerful tools can also be powerful weapons in the wrong
hands. But don't blame the toolmaker.
John, the reason that running an OS
Paul,
How about an ON DDL system trigger on the source (and possibly target)
databases? This trigger can log any and every detail of the who/what/when
whenever *any* DDL is performed by whoever...
Let me know if you need more details.
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)
Listen
of list ORACLE-L
Sent: Sunday, November 30, 2003 1:04
PM
Subject: Re: FRM-41072
Hello John
From you description of the problem I suspect that you
use 7.3 client.
See note172179.1 on metalink about which client connect
to which server.
Yechiel AdarMehish
something missed to migrate to
the new DB Server.
Could you help me a little?
John
How to set SQL_TRACE on on my server? I am quite novice.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, November 29, 2003 9:54 PM
John,
This sounds like an application specific error.
Was there an 'ORA-' error?
If not, you
the Developers and UA testers loose on that Db
* Use Cary's method to identity the top set of business processes and
determine if the performance is Ok
* If not Ok, then tune it...
All the best!
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)
Disappointment is inevitable, but Discouragement
default connection.
You can do this via ONAMES too (and I know you use one!) - see
Note:1036577.6. Btw, I am currently in the UK helping with a Name Server
rollout..
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)
Grace - Getting something we do NOT deserve
Mercy - NOT getting something we DO
Shareplex for
months and we have tested the reverse replication and that works equally well. That is
not to say that we have not had problems though !!
John
-Original Message-
elain he
Sent: 05 November 2003 12:04
To: Multiple recipients of list ORACLE-L
Hi,
We are evaluating using
*
miss uncached sequences under certain conditions when the Db restarts or a
short burst of SQL causes pressure on the DD cache... Had this occur once in
an Apps database and had to apply patches to undo and put back the
sequence...
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)
Listen to great
working with Financials (AR, AP, GL) and OE, with a little
Manufacturing thrown in.
Just my $0.02.
John P Weatherman
Oracle Database Administrator
Replacements, Ltd.
-Original Message-
Sent: Friday, October 31, 2003 12:24 AM
To: Multiple recipients of list ORACLE-L
Hi,
We
Vikas,
Are you asking if deallocated extent space can be reused by the current partition or
wether new dates will suddenly go into a partition that explicitly excludes them?
John P Weatherman
Oracle Database Administrator
Replacements, Ltd.
-Original Message-
Sent: Friday, October
Dear All,
Oracle licensing has been a subject that often is risen by somebody.
I though I shall share this with you.
Regards,
Hatzistavrou Yannis
Oracle_SW_License_Guide.pdf
Description: Binary data
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
you Yahoo!?
Exclusive Video Premiere - Britney Spears
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Kanagaraj
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
into a framework for IT
processes that define what an IT organization needs to get things done
properly. However, in my limited understanding, the IT scene and
organizations changes direction and in leadership so rapidly that one needs
an evolving plan (to say the least).
John Kanagaraj
DB Soft Inc
publishing of a List of databases and versions, Sizes
allocated and used, and other good stuff such as 'Average BCHR in the last
month' :-) These tools have the capability to reference such standalone
repositories and update themselves, so you haven't lost anything
Hope this helps!
John Kanagaraj
usage
(outside of that explained above)...
John Kanagaraj
Oracle Applications DBA
DB Soft Inc
Work : (408) 970 7002
Listen to great, commercial-free christian music 24x7x365 at
http://www.klove.com
** The opinions and facts contained in this message are entirely mine
and do not reflect those of my
it is
switched on.
Let us know if you need more info.
John Kanagaraj
Oracle Applications DBA
DB Soft Inc
Work : (408) 970 7002
Listen to great, commercial-free christian music 24x7x365 at
http://www.klove.com
** The opinions and facts contained in this message are entirely mine
and do not reflect those
it. If
executed and maintained well, it can relieve a lot of pressure and work and
add value to the 'business' [Hope I don't sound like damagement :) ]
John Kanagaraj
Oracle Applications DBA
DB Soft Inc
Work : (408) 970 7002
Listen to great, commercial-free christian music 24x7x365 at
http
and let Apps gurus such as Andy R, Tanel and Tim G
comment.
John Kanagaraj
Oracle Applications DBA
DB Soft Inc
Work : (408) 970 7002
Listen to great, commercial-free christian music 24x7x365 at
http://www.klove.com
** The opinions and facts contained in this message are entirely mine
and do
Thankyou all who have responded to this...
as it turns out the parameters for
shared_pool /large_pool were to large for the receiving machine after I
decreased the values to a minimal size I was able to recreate the instance.
Thanks again
John
-Original Message-
Joan Hsieh
Sent: Wednesday
Title: RE: RE: Perm job opening in MA
Ryan,
Thank you for that accurate explanation as to what excellent phone skills are. I just got to my email and have not had a chance to respond. I appreciate your assistance.
Regards,
John
-Original Message-
From: [EMAIL PROTECTED] [mailto
...
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)
God's word wrapped in great music - 24x7x365 at http://www.klove.com
** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **
-Original Message-
From: Jeremiah Wilton
the error? During startup?
Adam
John Blake [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/27/2003 03:04 PM
Please respond to
[EMAIL PROTECTED]
To
Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc
Subject
RE: Clone db 9.2 on AIX 5L
Sorry,
AIX 5L to AIX 5L
cold backup copies
create
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],
[], [],
etc..
-Original Message-
Sent: Tuesday, October 28, 2003 12:33 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
John,
Did you see any messages in the alert log? And what is in the cr_spap
script? the startup nomount is failing immediately, so everything else is
worthless.
Review
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
,
John Spencer
Sr. Staffing Consultant
ProStart Inc.
603-893-7772 ext 45
603-893-7704 fax
mailto:[EMAIL PROTECTED]
Title: Message
Sorry,
It is
not readable.
Kind
Regards,
Hatzistavrou
Yannis
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, October 24, 2003 6:40 PMTo: Multiple
recipients of list ORACLE-LSubject: RE: Do not connect Oracle DB to
the Internet.
Title: RE: Query Tuning Help
Just
checking to see if anyone has been able to clone a 9.2 DB from one machine to
another. I have never had a problem doing this prior to 9.2, and am just
wondering if I have overlooked something peculiar to 9i.
Thanks
in adavance
John
1 - 100 of 1399 matches
Mail list logo