 | | | Oracle List | | > I too have seen this condition. I 'm not sure I understand the
> client side mechanics but from a server perspective a process
> is created when an attempt to connect to the database is made
> If you send your bstat/estat or statspack report to YAPP they will give you
a suggested number for this parameter. They suggested 100 for one of my
production databases.
Ruth
-----Origina
If your primary key contains all the columns of
the partitioning key you don 't need a global index
for the primary key - you can use a local index.
Regards
Jonathan Lewis
http //www.jlcoZhu Chao
Sustained rates of 15-20 Mbytes/sec is absolute network saturation if you 're
running 100BaseT - don?t forget that 100 Mbits/sec is 12.5 Mbytes/sec. Even
if the network segment closest On Fri 2004-04-30 at 00 49 Fahd Mirza wrote
> Hi all
> Can any one please guide me to a resource about efficient SQL writing Tips.
> Thanks
> regards
> Fahd
http //www.amazon.com/Hi
What do you exactly mean by download tar? If it is about the
re-enetering the customer "particulars " - i.e. "Create a TAR - Step 1 "
you can save your profile (actually more profiles) in the Is the "when others " exception trying to capture errors like "table does
not exist " or is it only for a "%notfound " condition in case there is no
row in the table for "id jid " ?
-----OriginaMatt
>You can respond to me directly if you like - unless the list at large
>is interested in iSCSI on netapp.
I would very much like to keep this in the list..... The ground beneath us
as faRich
On 04/29/2004 12 22 45 PM "Jesse Rich " wrote
> Hey all
Yeah? Whaddya want now? May watch NASCAR in peace and quiet? Ya know
the Non-Athletic Sport Created Around Redn... OK it 's not
There are a couple of bugs where Oracle fails
to drop global temporary tables (Possibly because
it gets their names wrong on the drop). Another
example where SYS will accumulate GTTs is you
dro--- Muqthar Ahmed <Muqthar.Ahmed@(protected) >
wrote
> Hi
>
> I have a RAC system of 3 nodes with 7 webservers
> (clients). I would like to configure SDU/TDU
> parameters at client levelHi!
> Any advice on having more than one freelist for an index? I have looked
into
> freelists for tables but I cannot find anything about indexes.
With indexes the story is more complicated1. whether direct migration is supported from 8.0.5/8.0.4 to 10g in the
oracle doc it is said that first we will need to
migrate to 8.0.6 and then to 9i so which path u had used in your case?
Chhi
the following is the o/p of iostat on a new configured machine with netapp filer over icsci running oracle 9i database(1 tb in size).
Device rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-You had 247 executions of the statement each execution returns
1 row for a grand total of 247 rows returned.
If you had 1 execution with 247 fetches to return 1 row I 'm
thinking you have a seri > They cause no harm if they are "RELY " (i.e. unenforced) allowing the
DBA to
> create ERDs...
It seems you might also want these for Materialized views and Star
transformations IIRC. I haven 'tHi!
I think you should start with other methods for reducing the downtime like
patch merging etc..
I wouldn 't want to mention those parameters here since they 're very
dangerous if any crash sValerie - My guess is that it would be a risk. The patch might relate to
something you would encounter or might not. If it was a production system
probably an unacceptable risk. For a test system As well as 7.3 references of caching on Ixora...I have it bookmarked
for a
reason! (sigh)
Thanks!
Rich
Rich Jesse System/Database Administrator
rich.jesse@(protected)It has something to do with XML. That 's all I can tell you.
Ruth
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)]On Behalf Of SeemaSeema - Did you turn on the "RUN_FASTER " switch? Start with the Unix command
uptime see what is happening on the server.
Dennis Williams
DBA
Lifetouch Inc.
dwilliams@(protected)
-----Ori
There doesn 't seem to be any real point
in using IOTs for your scenario. For an
intersection table that small the saving in
space is likely to be non-existent. You may
as well have
cr
Bullet 1 is partly correct.
When you truncate or drop a table (shrink a
rollback segment) Oracle does write all
dirty blocks to disc before doing so and can
do this by walking the checkpoint I have a process where I am writing debug information to process trace
file using ksdwrt ... What I have noticed is that when someone deletes
the trace file a new file isn 't generated so where doTry Wolfgang 's presentation...Using DBMS_STATS in Access Path
Optimization...
www.centrexcc.com/Using%20DBMS_STATS%20in%20Access%20Path%20Optimization
.ppt.pdf
...its still on my pile of preseFahd
Autoextend does work in 8.1.7.4 and 9.2.0.5
example
CREATE TABLESPACE fixed_data
DATAFILE '/data5/lnxdb/fixedd01.dbf ' SIZE 2 M
AUTOEXTEND ON NEXT 100 k
EXTENT MANAGEMENT LOCAL UNIFORBarb Baker Do you want to tell everyone about the 3rd-party COTS
application that demanded DB_BLOCK_SIZE 4608? And the rationale behind
that number?
Hopefully it 's been migrated to a dumpsteI only now saw this post. Sorry for being late. There is an oracle
bug in 8i with DLM. To make the long story short a global enqueue
"loses " owner and consequently cannot be relased. That causesSeema What makes you think something is wrong with the query?
Tanel Are you sure about that? See this example in Oracle 9.2.0.4 Windows XP
SQL > describe x
Nom NULL ? With the penchant some people have for using layers of views with multiple
complex joins and subqueries instead of tables I am wondering if in 10g (or
later) the database is going to start looking |
|
|
