 | | | Oracle List | | "Gets " and "misses " are not indications of a problem merely that latches
are being used.
"Sleeps " are more significant indicative that latch waits are taking long
enough to require preemptive wHi list
My database is up since december 2003. However when I go through
v$latch I found the following
NAME GETS MISSES SLEEPS
hi list friends
I installed the patches in DBED/AC MP2 and did a system reboot. Patch name like
[root@(protected) mp2]# ls -l
total 299872
-rwxr-xr-x 1 root root 30657 Aug 6 2003What is "further then this ". The use RMAN requires that the user
that RMAN uses to connect to the database has the role SYSDBA.
In particular that means that password file must be set to either
sh > In the process of testing 10g rel 1 I see that neither 'namesctl ' and
> associated Onames directories exist nor does it resolve TNS entries
unless
> made available via tnsnames.ora..... If so The damage is minimal if at all. Your partner probably created the database using dbca and one of the templates. That seed db is 92010. To prevent this in the future always check the values from dba_r
Several weeks ago I updated one of my 9i R2 database servers to the
9.2.0.5.0 patch set and ran all of the necessary scripts on the database
after patching the binaries. A partner of mine created "Smith Ron L. " wrote
>
> I have a compressed import hanging.
> I found the following code in the system ALTER SESSION SET EVENTS
> '22825 TRACE NAME CONTEXT FOREVER LEVEL 1 '
>
> I tries tranTry the -ignoreSysPrereqs option to runInstaller to turn off the OS checks.
-----Original Message-----
From Ken Payton [mailto Ken.Payton@(protected)]
Sent Fri 4/23/2004 4 55 PM
To oSomehow I missed the definition of "COTS "...will someone please
enlighten me? Thanks.
The one that comes to mind is a particularly nasty query from a Business
Objects (aka "B.O. ") report that runs against our OLTP DB. Did I mention
that the vendor ported the schema from VMS RMS fileIn 8.1.7.4.0 on HP-UX 11.0 I 've got this table
TX_COUNT NUMBER
TIMESTAMP DATE
(thanks Oracle for making "TIMESTAMP " a reserved word in 9i despite it
being used as column names in the DD!)
On 04/23/2004 02 06 31 PM Tim Gorman wrote
> Do you see a lot of FAST FULL scans? Generally when I see them they are
> the result of either
>
> * SELECT COUNT(*) on table with PK (usua
Alas even that isn 't necessarily true.
What if you have a low update rate but a high read rate.
You 've just isolated a disc or two for a very low level
of redo I/O and reduced the number oJeez Paul it was just an example. )
Jared
On Fri 2004-04-23 at 18 15 Paul Drake wrote
> OOH - odd number of disks for RAID 0 > > BRAIN HURTS.
>
> These days I can only do math in my heaMan I wish I lived in your world...
Rich
Rich Jesse System/Database Administrator
rich.jesse@(protected) QuadTech Sussex WI USA
> From Tim Gorman
> S
Is anyone on here live in or near San Diego that can tell me how they like living there and so on and so forth? How expensive is it and what are the DBA pay scales like there in relation to costs?
It looks like you need to
Create working table as select old data excluding
new number year and qtr from old partition
Insert append new data into working table.
Index workThe myth is that "they are both accessed at the same time ". They are not.
At least not by the same session processing a single sql statement.
At 10 13 AM 4/23/2004 you wrote
>Hi
>Does any one It is a myth because the index has to be read first so the rowid for the
table can be determined. At that point an I/O for the table can be
done. So index reads and their associated tables are fo
And an old truism - which I think I first ran up the flagpole
during v6 days
20 inserts might go into just one table block
20 inserts could easily mean 60 scattered index block
Why does the private nic not have an IP? It should . Also ensure thet once
the private nic 's have IP 's
that the binding order is such that the public IP 's are loaded first.
----
Not necessarily.Michael I don 't know anything about the mentioned courses I haven 't attended
either of them. I do however believe that you should read Cary 's book if you haven 't
already done so and get a goodhi
can anybody give me a suggestion regarding this..its related to data
loading using sqlldr
in a particular filed data is like this..
12345
23451
34567
i have to load them as 12.345 2I would uninstall again and this time go into the registry and under
local machine \ software delete the oracle key.
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit AI think Michael M?ller from Miracle implemented PV with one of our
Support customers and it works nicely. Inserts will have to be guided
to the right table/partition by the application or by the inHello List
We are using Oracle collection to pass data to the JDBC. ( MASTER
DETAILS RECORDS).
CREATE OR REPLACE VIEW prod_offer_view OF master
WITH OBJECT id (PROD_OFFER_ID) AS
SELECT Which open source rDBMS is "better " to be used with PERL
where the application would involve at most a couple of
concurrent users and a probably less than 100MB of data.
The application will almos
First guess - they 're using direct load and
still loading one row at a time so you get
one row per block (or worse).
Since you 've got the v$sql entry check
executions against rows processedHad the (unpleasant) opportunity to do this recently on 817 as described
and
it did in fact work for me. YMMV.
-----Original Message-----
From Jonathan Lewis [mailto jonathan@(protected) |
|
|
