 | | | Oracle List | | Years ago when I was helping a group move from an OPS database to a Sequent we ran into issues with PQO. These are some of my notes I took when watching the system. Maybe they will help you. TakeRoger - I don 't see where you mentioned your Oracle version. RMAN has been
notorious for being picky about the date format. I 've generally heard of
this in terms of recovery times and with Oracle 8iPlease ignore this question....
On Mon 11 Oct 2004 15 54 32 -0500 Manjula Krishnan
<oradba.la@(protected) > wrote
> I did an export/import to convert our Oracle 8174 database to 9204.
> (this So the problem is the select from vu_ttl_tlskwttl is at one point and
time. The create materialized view is at another point in time. If
anything changed in the underlying tables that made up thOn Mon 2004-10-11 at 20 14 Yechiel Adar wrote
> I just set today with a project manager who wanted me to install Oracle on
> drive D of the server because all the stations on his project have OrI just set today with a project manager who wanted me to install Oracle on
drive D of the server because all the stations on his project have Oracle
client installed of drive D (can you say small siHi Niall
I might have been overreacting slightly and maybe I need to rephrase
to [...] If you want to risk suffering from possible bad performance
due to implementing a sub-optimal protocol for I have some notes I wrote up when doing this migration from 8.0.5 to 9.2 if
you 're interested. Email me and I 'll send it to you offline.
Andy Rivenes
arivenes@(protected)
At 10 05 AM 10/11/200you shouldn 't need 1 000 queries with hints unless your tables are not analyzed. I have found that if my tables are analyzed and even if I 'm not using system stats and have really bad index paramters Seema 20
Possible reasons could be
1. Optimizer statistics are not available. May have to update them
ACCURATELY again.
2. All the SQLs are being parsed again freshly (taking more time!) We have been attempting to file a TAR over the last few days. Fortunately a
minor issue. We are able to complete the first screen then receive a long
wait followed by an error message about can 't fHi Alan
>So far so good. But no matter what I try I can 't seem to figure out
>how to extract ItemNumber "Part Id " Quantity or UnitPrice. Do the
>extract and path strings not work properly fPawan
U can use the Administration Assistant for Windows to Achieve this.
Cheers
Ganesh
On Mon 11 Oct 2004 17 54 47 +0530 pawan.dalmia@(protected)
<pawan.dalmia@(protected)Thanks for all the responses.
To surmise
SCCS is outdated and effectively replaced by RCS.
RCS is popular and seems to do everything I require.
CVS is based on RCS but enhanced for multi-devHi
We have a Sun V1280 with 1 application running Oracle 9.2.0.3 installed by
the application vendor and owned by the user 'oracle ' group 'dba '. I have
been asked to install Oracle 9.2.0.1 as hi guys
well this might sound funny but we had this one query for which the
execution time is going on a linear curve upwards as the number of
records in the corresponding tables.
SELECT (-1)10G supports datafile conversion from Big Endian to Little Endian. For
8.1.7 on AIX it would be worthwhile to look into the used market for IBM
equipment such as http //www.xcc.com. There are v "local write wait " refers to the wait in a session to reuse the same
buffer while dbwr is trying to flush the same dirty buffer.
There are variety of bugs listed in Metalink refering to this on Lex
That was the way I read it too the problem is how does one
write the PL/SQL to handle it? You 've got a variable number of elements
that have to be provided for. 20
Dick Goulet
SenioJurijs - Another idea is to just include "oracle-l " in your search string
for Google. There are other web sites that archive the oracle-l list besides
freelists.com. Unfortunately for some of the liThe same testcase except ?set transaction read only?
>1. Step Nr. 5. Why Oracle can?t use already created copy of the block
>during step Nr.4?
Oracle use already created copy of the block.
>2. SteSGVsbG87DQogDQpGb3IgaW5zdGFsbCAsIHJlZnJlc2ggYW5kIHVwZ3JhZGUgLEkgdGhpbmsgdGhl
IGluc3RhbGwgZ3VpZGUgb3IgdXBncmFkZSBndWlkZSBpcyBlbm91Z2guDQpCdXQseW91IGNhbiBy
ZWZlciBodHRwOi8vd3d3LnB1c2NoaXR6LmNvbS8gIHdoI agree with Mark. We have been using Shareplex for the past three years and
we have had great experience. We have master-master replication between two
sites which are 2000 miles apart and have nevI 'm trying to figure out why the oracle process on a Windows 2000 server
is consuming 98% of the cpu. Patch #3820881 for Oracle Security Alert
#68 was recently applied. This is a 2-node FailSafe 3Hi
CJ you are right. Thanks.
On Mon 11 Oct 2004 16 30 29 +0200 Carel-Jan Engel
<cjpengel.dbalert@(protected) > wrote
...
> There is a High Quality and Highly Appreciated site with a payed
Sorry didn 't clarify previous e-mail in enough details - with sql trace
I was referring to event 10046 (extended sql trace).
Regards
pba
-----Original Message-----
From zhu chao [mailto zhIn $ORACLE_HOME/inventory/ContentsXML/comps.xml is the defnite guide to
what products you 've installed and what versions. Also if you 've applied
patches via OUI or Opatch they will be listed in heDear List
I 'm facing strange oddity when tracing MERGE statements. For each
MERGE statement I get one parse error of the "strange " query from
dual. I would like to know why does Oracle needs to
I use RCS. Why? Because it 's there.
And understanding co and ci doesn 't take a lot of brain power.
>-----Original Message-----
>I was wondering what systems (if any)
>you use.
--
http // "Goulet Dick " wrote
>There are some things like this that I believe should not be done even
in test. The >reason is that now you 've crippled a significant item for
database recovery for the > |
|
|
