 | | | Oracle List | | Check the dba_ind_expressions table.
-----Original Message-----
From Muqthar Ahmed [mailto Muqthar.Ahmed@(protected)]
Sent Monday March 01 2004 1 40 PM
To 'oracle-l@(protected) '
As has already been pointed out the estimated
volume of data to sort is different.
> > 1 0 SORT (UNIQUE) (Cost 118228 Card 8046044 Bytes 225289232)
> > 2 1 MERGE JOIN (Cost 1
I think you 're running into a problem with the
Hakan factor. This is a number used by the
bitmap index algorithms to limit the number
of rows that Oracle assumes can be stored
in a single blockIIRC there was a bug related to a shutdown abort during a
kernel transaction that would cause corruption. I don 't know the
bug but the additional info may help. One of the 'bugs ' that
was often dList
I have completed the upgrade of my linux play box from a 20 G dev/hda
to an 80 G /dev/hda and reloaded the RedHat 7.1 successfully.
I restored the Oracle datafiles and binaries from tape wheThis was a new one for me.
I 'm having a database restored using the "latest " and greatest with SAN and Omniback and putting it on a different server.
Some of my disks were "full " some prettyHey all
Migrating from 8i to 9i we 're hoping to be able to use the expanded ONLINE
features of tables mostly for post-conversion moving of tables. I see in
James Morley 's outlawed paper on 9i
----- Original Message -----
From "Tanel P?der " <tanel.poder.003@(protected) >
To <oracle-l@(protected) >
Sent Saturday February 28 2004 12 07 AM
Subject Re Your opinion please ) keep in th
That was the interpretation that Tim Gorman
supplied as a nice 'human ' way of looking at
it. Since it still works in 9i you could (for
values up to 100) view it as the fraction of
single blockHi Indy
I 've configured appr. 30 DG installations 8(.1.7/9.01/9.2.0.2 and up) and
only one of them was LSB. This one was intended for serving the www-access
and witth the LSB solution the iRyan
That is the best book I 've seen for using many of the advanced features
of Oracle SQL. I highly recommend it!!!
Stephen
> > > jonathan@(protected) 03/01/04 06 46AM > > >
Monday March 1ITtoolbox.com has an active application forum
<oracle-apps-l@(protected) > There are other application
groups available at Yahoo groups too.
Ron
> > > tanel.poder.003@(protected) 03/01/2004 7anyone seen these in trace files? (not in alert log) after upgrading to 9204 (and a whole bunch of patches) ??
*** 2004-02-29 11 12 50.454
diag for 3194997
*** 2004-02-29 11 13 06.563
diag for 3Hi
I had a strange situation going on
2 batch scripts seem to be waiting
- 1 doing an index fast full scan on a table
in v$session_wait this results in a direct path read event
- 1 havinHi
Server HP-UX
Oracle Ver 9.2.0.4 64 bit
Sorry I missed this info in my previous post.
Thanks
Vidya
vidya kalyanaraman wrote
> Hi All
> While trying to use statspack to generate sHi All
While trying to use statspack to generate snaps got the following error.
$sqlplus perfstat/perfstat
SQL > execute statspack.snap
BEGIN statspack.snap END
*
ERROR at line 1
ORA-065Hi all
We did an export rows n when the created dump was imported these were
created as tables. Some of them was created as MV 's but failed to
re-fresh.
Oracle 9.2.0.4 64 Bit on Solaris.
Even I have tried to find a way to find the same on 9i but was unable to. I
think the only way to find it is via the alert log file since events set
via ALTER SYSTEM will get logged there.
If tHere is a litle something that might help
declare
event_level number
begin
for i in 10000..10999 loop
sys.dbms_system.read_ev(i event_level)
if (event_level > 0) then
dbms_output.put_line(
Perhaps the author is thinking of hash-partitioning
of index organized tables - which I think appeared
only in 9.2
Regards
Jonathan Lewis
http //www.jlcomp.demon.co.uk
The Co-operative OThanks. I got search to work exactly this way.
There is also some good info in the 10g docs if you
search for 1813 (the port number).
Regards
Mike Thomas
--- Jonathan Gennick <jonathan@Pete it says "malformed archive " which probably means that your
library is corrupt. Please do
"nm u01/app/oracle/product/10.1.0/db_1/lib//libctxc10.a "
and see if nm can read it. The "nm " uHave a look at Metalink under note 122567.1
-- Note titled "Poor Performance in Query on DBA_WAITERS "
There is an update to catblock.sql that improves the performance.
HTH
Bruce Reardon
NOTIIve got bug number 1475310 scribbled down here - something to do with corruption. Check it out on
metalink and see what turns up
hth
connor
--- Jay <jaysingh1@(protected) > wrote > Dear GuDear All
We were trying to create an index on one of the table in our Production
system.
Background
Version 8.1.7.3 OPS
OS Sun Solaris
Table Size 300 000 rows 200MB size
Index Type You have to run $ORACLE_HOME/rdbms/admin/catblock.ora of your latest version
of Oracle 8.1.7.x.
It is a known issue. I opened a tar 4/5 months back for same issue and they
told me this solution aI 'm slowly working through an install of Oracle Database 10g
on SuSE Linux Enterprise Server. I haven 't had anything
profound to say yet but if you 're interested in following
my progress you can Metalink note 132692.1 provides a list of heterogenous services guides &
howtos.
Tanel.
----- Original Message -----
From "Waleed Haggagy " <haggagy@(protected) >
To <oracle-l@(protected) >If you just want to have a database link then go with Heterogenous Services
and ODBC driver for DB2.
Transparent gateway is overkill in most situations and last time I checked
it did cost a fortuIf you did not check this out... Its not late.. we have a few more seats
Charlotte Oracle Users Group is hosting a one day seminar by Jonathan Lewis
Great opportunity ...Just two weeks ahead.. |
|
|
