 | | | Oracle List | | There is no configuration file this is stored in the registry. There will
be a key
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ < <DSN Name > >
Where configuration information is stored. I wouldn 'passed this on to an associate and this was his comment...
"They may be using Jboss Container Managed Persistence we use Toplink so
for us we are ok. They are being bit by using the CMP. "
----Hi Syed
What is your basis for tuning?
These numbers really don 't tell you anything useful for tuning.
52 seconds of waits for direct path read sounds pretty good for a busy
database that hHi Jared
On Tue 21 Sep 2004 09 03 24 -0700 Jared Still <jkstill@(protected) > wrote
> On Tue 21 Sep 2004 09 58 03 -0400 rjamya <rjamya@(protected) > wrote
...
> > someone was telling me a week Please ignore.
--
http //www.freelists.org/webpage/oracle-l
Hi Paula
Can you point us to a doc link for that?
Jared
On Tue 21 Sep 2004 07 41 09 -0400 paula_stankus@(protected)
<paula_stankus@(protected) > wrote
> Rman gurus
>
> I I prefer the prebuild & export via ODBC. Doing otherwise can create
problems from case sensitive objects.
-----Original Message-----
From Mitchell Baldwin [mailto Mitchell.Baldwin@(protected)May I recommend you subscribe to Gmail and use it for your oracle-l?
Gmail automatically arranges the threads for you. HTH.
On Tue 21 Sep 2004 11 27 01 +0200 Jose Manuel Quesada
<jmquesada@(protected)hi can someone provide some insights how I can rewrite my boolean search query more efficiently?
I would like to do a search for something like "(a AND b) or (c AND d) or (e AND f)... "
The queTry rebuilding the refresh group(s).
That usually does the trick.
If you start digging into the internals of the beast you may
find that the last refresh date on the master side is always
gORA-00001 unique constraint (PERFSTAT.STATS$SQL_SUMMARY_PK) violated
In case you come across this issue - its covered in the Metalink forums
http //metalink.oracle.com/metalink/plsql/ml2_documOn Win32 you do need to quit/stop any application/service
using an Oracle file.
Jared
On Thu 23 Sep 2004 15 18 10 +0200 Yechiel Adar <adar76@(protected) > wrote
> I installed the patchThis can be dealt by Implementing SSH port forwarding with 9i Data Guard.
Check out Metalink Doc ID Note 225633.1 which details about sane and clarifies
the issue....
LGWR ASYNC --------Can somebody explain as what is Direct Path stream
format and how it is improved in 10g
Thanks
Sanjay
>
> FYI select SYSDATE from DUAL /* ping */ is the method by which the
> DBD Oracle perl module checks to make sure it has a connection to the
> database. It 's not in our code -- it 's in the perNice feature for DW applications and HISTORICAL Partitioned Tables where in U
can compress individual partition.
Oracle technet has a good article on this from Sanjay Mishra
http //www.oracle.cWhat leads you to believe the problem is in the 8.1.7 database?
note Rewrite your updates in Perl with DBI compile the DBD Oracle
with Oracle 8.1.7 and use it for your Oracle home.
Via DBI [leprod > ls -la /dbdumps/backups/df*
-rw-r----- 1 oracle dba 5256142848 Sep 18 07 12
/dbdumps/backups/df_t51
When I use
[leprod > find /dbdumps/backups -name "df* " -mtime +0 -print
HI
I am having 9.0.2 version of oracle running on windows 2000 professional.
The Problem I am facing when I am trying create net8 config.
the error as follows
"
Connecting...ORA-03113 end-oHi Friends
I am having a very fundamental doubt
what is the order of retrival of the clauses when all are inclueded in the select stament like.
Where
Group by
having
order by.
eg seleAre you connecting to the host machine via RDP (MS Terminal Services
Client)?
If so you cannot connect via the method you described (unless you are on
MS Server 2003 and you specify connection Are the sql and all parameters the same? Can you post/send the full 10053
traces.
I worked with version 8.1.6 only very briefly and many many years ago.
At 02 33 PM 9/19/2004 jaromir nemec wrotSyed
The dropping of the tablespace itself (be it Locally Managed or Dictionary
Managed extents) should be very quick. What will slow down a drop
tablespace (cascade) is the dropping of all segmHi All
Version 8.1.7.3
Could someone help me to find out where the transaction related
information asscoiated with deftran? I would like to see all the SQL
statements associated with deftraWhich do you think backs up and restores faster one 1-Tb volume or eight
128-Gb volumes?
on 9/18/04 11 41 AM Hitchman Peter at Peter.Hitchman@(protected) wrote
> Hi
> I am certainly Thanks Carel-Jan
That was what I was thinking. I will double-check the SIG from OTN.
-----Original Message-----
From Carel-Jan Engel [mailto cjpengel.dbalert@(protected)]
Sent SaturdHi Georgette
What issues did you have with this patch. I 've attempted installing it on my lab box and executed commands as specified in the readme file but perl -opatch apply returned an error I 'm doing the "read the fine manual " bit and will be searching
Metalink OTN and Googling for info on this product. That I don 't need
help with. But all that does is tell me what Oracle says the proMark
thanks for your info. We were not aware of this problem as we are using
only sql*net (forms 6i and mod_plsql) and we did not hit into this bug.
But it is good to know about it for futur
Fuad Arshad <fuadar@(protected) > wrote Hi
Steve
Just wanted your permisison before i post this to the List.
|
|
|
