 | | | Oracle List | | >From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On Behalf Of Jesse Rich
>For us it was either recode all of our programs to use bind variables
(when we started with OraclNo need to be rude. You can create custom procedure to concatenate and
stream output from "select * from table(dbms_xplan.display) " into a single
blob value.
If you don 't need a single value use
cr
Morning 'Y '
> > "Jurijs Velikanovs " <j.velikanovs@(protected) > 06/22/06 08 56pm > > >
> >Just in case you would like to find who is really consuming space
TEMP tbs
<snip >
if you don 't mind a small corrAccording to this looks like it was supported in 9.2 but I 'm not sure
about 10.1
http //download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmb
ackp.htm#445993
Privileged/ConfidenAny ideas why "GROUP BY " query is faster that
"DISTINCT " in this query?
SELECT OWNER FROM DBA_OBJECTS GROUP BY OWNER
Good Timing (GROUP BY) Plan (runs in 9 secs)
A few weeks ago I posted a 10.2.0.2 query example that produced the
wrong results.
This turned out to be a bug 5228983 and is related to partitioned tables
so I thought I might as well post a warn Hi List
If there is any way for an Oracle Package to make an Asynchronous call from
within Procedure A to another Procedure B where Procedure A can finish and
return regardless of Procedure B 's sJust curious - why would you suspect it to be a DDL operation? Seems to
me that DML would be more likely. Also you say "another DDL " as if
SELECT FOR UPDATE WAIT is also a DDL statement. Maybe itI want to move a db from one server to another. I basically have to do it
this way. No upgrade in place etc...
The first server is Solaris 8 sparc with oracle 9.2.0.5.0 the second or
new servRenee
The root cause of this error is likely misconfigured backups (at the OS
level).
a rogue process locked the file.
too bad it wasn 't the system tablespace 's datafile.
The larger the datafile thI 've been hoping that m$ would invent man -k for years.
This will do
http //www.ss64.com/index.html
--
http //www.freelists.org/webpage/oracle-l
On 6/21/06 rjamya <rjamya@(protected) > wrote
>
> http //thedailywtf.com/forums/thread/78254.aspx
>
> Vendor supplied script was
>
> start oracle
> sleep 1000000000
> stop oracle
>
> You have to read tHi List
Barely related to initial subject - does anybody have clean/correct/tried
document/note on how to configure logical standby ?
Regards Ranko.
On 6/21/06 tristan.van.essen@(protected) <tFriends
I am want to install 10g Agent (10.2.0.1) on a 2 node veritas active/passive
cluster. I found no document on metalink for doing this.
The most confusing part is
Normally a cluster node ha > I want to export a 10gR2 schema onto my laptop but it has one huge
> table with data I don 't need.
10gR2? Just use expdp and EXCLUDE keyword.
--
Egor
http //www.oracledba.ru
--
http //www.freeliASM and all Oracle Guru
I would like to know if you can shared your experience of the prefer/best
practice of creating ASM diskgroups with storage subsystem like RAID.
Oracle recommends create two dI have the following SQL
select ptd.MPID ptd.FIRST_NAME ptd.LAST_NAME ptd.DOB
ptd.SSN ptd.ADMIT_STATUS_DESCR
FD.FACILITYNO FD.FACILITYNAME
pdl.MD_FIRST_NAME pdl.MD_LAST_NAME pdl.MD_UPIN mHi
We are on Oracle 9.2.0.7 (32 BIT) Windows 2003 adv server using
OFS.(Oracle Fail Safe).
We are looking into adding shared server support to our Production
database due to resource limitation ofI am wondering how *exactly* Oracle defines system statistics for
A) single block read time
B) multi block read time.
On my system (9206) I see values 1.3ms for multi block and 2.7ms for
single blocIn some 9.2.0.5 on AIX (single instance dedicated server) trace files I am seeing incorrect elapsed times for database calls (not wait events). Diagnosis becomes difficult when tkprof reports the quIs the query perhaps running in a wrapped package ?
That would be a reason
Stefan
On 6/20/06 Schultz Charles <sac@(protected) > wrote
>
> Good day all
>
> We are trying to isolate a query thIs anybody out there using async CDC from oracle? I heard the it is brand
new ( async CDC is production from 10gR2 ? ) I am totally new to this
feature of oracle and i am researching this before we thI am using it on AIX not mainframe but a good resource is
http //www.idugdb2-l.org/archives/db2-l.html
and
http //www.redbooks.ibm.com - very good resource
Also IBMs own website is good fWe ran into the same issue (10.2.0.1) and support referred us to this
note (284602.1). The note documents two solutions. We implemented
solution one (rename ons.config) but the problem re-occurred Hi Cindy ASM and ASMLib currently have no multipathing capability.
So to remove the Single Point of Failure storage connectivity per
server you need to provide at least two paths to that storage Amonte
Are you asking how do you convert the tables to use a surrogate key? A
bit of coding will accomplish this. But your application also needs to
be changed so that when it inserts new recorIs it possible to modify the result set returned by a SELECT statement
that is trapped by Fine Grained Auditing? I am using this process to
detect when an accessed column is actually archived outside Logging to OS has been supported for quite a while now
http //download-west.oracle.com/docs/cd/B14117_01/server.101/b10755/initparams015.htm#sthref88
On windows entries will pop up in the event loSRDF doesn 't care what 's on the devices being replicated.
Make sure you upgrade Oracle on the servers at the DR site if you
installed the binaries on local drives.
On Jun 19 2006 at 06 59 PM As mentioned today on another thread - you can consider "skip
procedure " feature of logical standby. I don 't know about 10.1 but
it 's there in 10.2 at least.
2006/6/20 Mark Strickland <strickland.ma |
|
|
