 | | | Oracle List | | Marc
Have you tried embedding the query in procedure(s) on B and then executing B
remotely from A? Depending on what you have to return you may have to set
up a reference cursor(s) but this techJeffrey
I have used cut/paste from v$sql and had that work you can also have Oracle
automatically generate outlines for all eligible SQL statements executed
during a particular session or all eliMarc
Create a view on the "b " database joining all of the tables in your query
and call that view from the "a " machine. This will force the join to be
performed on the "b " machine.
My experiLog on to metalink and look for deinstalling oracle. There are papers with
detailed instructions for really cleaning up an Oracle installation. The CD
uninstall doesn 't really take care of everythOk I 've searched around a bunch. Found a bunch of threads on
metalink with no real answer other than hacks such as creating a view
on the remote server and selecting from that which are an inane
I have a problem where I can not increase the number of concurrent SQL
statements running through our system. I believe this is caused by contention
on the SESSION ALLOCATION latch while internal Oracle sends good news to procratinators. -)
Mike
---------- Forwarded message ----------
From Oracle Global Product Support <st-gspuser_us@(protected) >
Date Wed 09 Feb 2005 11 26 45 -0800I will forward it to my AIX SA and he should have some suggestions by
tomorrow.
Ruth
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)]On BeOn Wed 09 Feb 2005 16 05 32 -0600 Jerome Roa <jroa@(protected) > wrote
> Anybody doing a medium sized warehouse in Oracle(more than 300G worth of data)?
yes
--
--
Bill "Shrek " Thater A friend of mine has writes "My data center is a Windows shop. It has
600 HP rack mounted dual processor servers. But now we are embarking
down a road to acquire a 16 way IBM AIX platform and
Forget all that! Come to the UK! We 've got rain tea and Tony Blair!
-----Original Message-----
From Ruth Gramolini [mailto rgramolini@(protected)]
Sent 10 Feb 2005 15 50
To davewendeHi
I only have 10g here to test on but I believe MERGE will work in 9i.
Don 't know if this is any more efficient than other solutions already
offered but it DOES get rid of the cursor looping foI do rman backups to disk and copy them to tape using the OS backup facility
(sysback on AIX). rman backup to disk is much faster than rman backup to
tape. The copy to tape can be done in the bacIt 's a problem when any given construct serves multiple purposes in one
context. Probably some complex parsing alorithm would work but I 'm not too
skilled there.
For SQLLDR you should be able Hm...
"...&afilid 2846078857 " - "someone " is making money here. At least I
would expect to mention it when posting in this list!
On Wed 9 Feb 2005 13 47 03 -0400 Juan Carlos Reyes Pacheco
<Michael
You 've got it right someone did an update/delete somewhere
along the way committed & left. Suggestion try speeding up the queries
that these programs use. Sometimes a specialized inHi there all
As usual I/We am arguing with a developer guess it is a normal thing
for us all.
Does anyone know of a document stating/mentioning the implied
dbms_job.RUN that is called by orSami
Great job on the platform information but you 're asking for physical
IOs here without supplying any info as to the storage subsystem.
A good upper bound would assume a buffer cache hit raDatabase links remain open until the client session closes them or until
the client session exits.
You can use
Alter session close database link 'link_name '
You must commit or rollback before On Tue 08 Feb 2005 13 07 56 -0800 Lyndon Tiu <ltiu@(protected) > wrote
> Hello
>
> I just need to confirm something.
>
> Oracle XSQL is an add-on product to Oracle databases. It runs insidHello
The University of Vermont has an immediate need for an experienced
Oracle DBA to join an implementation team deploying the PeopleSoft
Enterprise ERP system. Please visit our jobs websHi folks
One of our developers has just reported this error after a simple select
select COUNT(*) FROM tracking.tracked_lacosa_request
*
ERROR at line 1
ORA-015 I can second Tom 's comment that "bad things happen " when joining across
links. Especially if the remote tables have much size. Other strategies
are create a function on the remote DB to return jOn Tue 8 Feb 2005 18 56 06 +0200 Nicolai Tufar <ntufar@(protected) > wrote
> But now... I don 't know what we can do now.
>
How important/unique are the supplier? Unless it 's like they 're
numIt is not just a matter of following asktom advices it is also about
understanding what you cause in production systems with your actions.
Usually I am constrained to reducing downtime/locking riskIf you 've grown tired of seeing messages in the system event log due
to client-side mapping of printers with the Oracle server 's print
spooler service disabled every time someone connects to the seHi all
I have to monitor some session statistics (amount of redo log for
example) and I setup a logofftrigger to do this. Inside the trigger I
use sys_context( 'USERENV ' 'SESSIONID ') to identifRon - We don 't want to lose you. Have you contacted your salesperson
yet? I 'll bet you can work something out with them. The product has been
updated with significant new features for tuning both cuHi
The OEM packs will run on SE depending on how its configured on 10g
web-based EM. Legal configuration can be done by clicking on 'Setup '
(e.g. on the top-right of the <host >/em/console/aboutDoes Index work on Encrypted column?
Muru Data Architect
--
http //www.freelists.org/webpage/oracle-l
|
|
|
