 | | | Oracle List | | Hi All
Thought will get somethings clarified .. I am not able to find
anything on the docs on this.
During Instance Recovery .. The Recovery is Performed by Smon and the
Change Vectors GenerHello Seema
Look in V$SQLAREA for SQL statements with a high number of DISK_READS.
Examine the execution plans for these statements and consider
whether they can be tuned to reduce the number One idea would be to fix SQL statements that are causing I/O and make
them cause less I/O.
The other idea is to increase BCHR. These ideas are not equally good.
Take yor pick.
--
Mladen Gogala
No problem. As a veteran of IT (20 years) it doesn 't bother me. Call
me what you want but call me DBA.
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@My understanding is the same number of standby logfile is OK. so if your
maxlogfile number is 20 so you should have no problem to setup 10
standby logfile as well as the 10 normal logfile. And ofcoHas any one seen (at least in Oracle10g) that the object# is -2 for certain
CR blocks of an object and not the real object or data object number and
knows why that is? The object in questions is a rI guess I left out the "locally managed " part! That is what I meant of
course! )
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From Niall Litchfield [mailto n > Do you mean _corrupt_blocks_on_stuck_recovery ?
>
> It 's gone starting from 9i...
Btw in 9i you can issue "recover database allow 1 corruption "
Tanel.
--
http //www.freelists.org/webpw2k adv svr sp4
9.2.0.1.0 base release - clean install
10.1.0.2 OUI installed into the 9.2 home
9.2.0.5.0 applied against the 9.2 home
then the real fun begins.
http //metalink.oracle.com/metI know I 'm a couple of days late but I 'll add in my two cents anyway.
In Oracle 8.1 the parameter O7_DICTIONARY_ACCESSIBILITY was set to TRUE
by default.
In Oracle 9.2 the parameter O7_DICTIONHow many objects with synonyms does your test environment have? And how
many concurrent users did you test? You need to get up to hundreds of
concurrent users to begin noticing an effect - as Mark
On 09/14/2004 10 03 10 PM Mark Richard wrote
>
>
>
>
> I just wanted to pose a question to anyone on the list (particular the wait
> event guru 's like Cary)...
Event guru? That 's whatIronic? No.
Funny? Yes.
Even Jared 's human!
-----Original Message-----
From Bobak Mark [mailto Mark.Bobak@(protected)]
Sent Tuesday September 14 2004 12 23 PM
To oracle-l@(protected)Interesting that this should come back to the list.
You see I have a filter setup to exclude Oracle-l@(protected) from
any OOO messages. Apparently it is not working though it has
in the pasMatt
Centiseconds or as Oracle likes to say "tens of milliseconds ".
http //download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/apc2.
htm#1186645
-----Original Message-----
FroHi
We are running Oracle 9.2.0.4.0 on Solaris 9 and please see the output from "vmstat ".
Do you think we have a paging problem? We are using plain UFS and I do not think
direct/IO is turn on.
Mladen
Do not worry! This is quit normal when you get older. Slowly forgetting things that aren 't
important anyway...
--
Rob Zijlstra
On 14 Sep 2004 at 13 44 Gogala Mladen wrote
> HerDoes anyone here have any positive or negative experience running 9205
Oracle on Linux Red Hat AS Rel 3 with the following patches
1) Patch 3588448 applied on Tue Aug 03 23 26 42 GMT 2004 <-
The *real question* is why in the world is the documentation hidden behind a
site where you need to log in?
Oracle makes no sense sometimes.
Tom Mercadante
Oracle Certified Professional
-Hello
Please ignore the question. But if you are interested in this error.
here you go.
After applied the patch instead of run those plb scripts under mdsys
schema we run it under sys. (mI 'd ask the developer to explain the functionality he or she is after. I 've
never seen that term in the Oracle documentation...
My guess (hope?) is that the user is asking how to use
dbms_obfuscPrem
You can download Oracle Trace Analyzer from Metalink. It 's a decent tool relying on sql & pl/sql to read and parse the trace file.
The reports that are output are kind of 'noisy ' and very
Written by Kevin Quinn and at that time he was working for Oracle UK
Support. Now he is working for Oracle DDR (not the ex-country but the
department led by Nancy Reier).
Anjo.
-----OriginaLarry
Just saw your qst.
Besides looking at the official Ora docs you might look at
'Oracle pl/sql programming 3rd ed. ' by Steven Feuerstein.
He explains the whole time/date format subject inGuys
What is the best method/approach for backing up the infrastructure
database that comes with 9ias. I am using RMAN with hot backups and
running in archivelog mode to minimize downtime. On Mon 13 Sep 2004 12 23 41 -0700 (PDT) Jeremiah Wilton
<jwilton@(protected) > wrote
> I think someone posted recently about the ability in 10g to set events
> over the scope of all sessions ofWe have a system that is raw and configured with 1 db_writer_process.
IO wait on the server is around 50%.
I have read some contradictory or unclear information and I 'm hoping to
get some clarificaHi Sami 20
What is the statement? I 've seen this before when the statement
included a number conversion to a format that wasn 't valid. 20
Lisa Koivu
Database Monkey
Orlando FL USA
--Steve
Those archivelog destinations are all mandatory right?
Non-mandatory destinations shouldn 't really be counted on and may do
more harm than good.
Paul
On Mon 13 Sep 2004 15 38 47 |
|
|
