 | | | Oracle List | | FYI there is a documentation bug in this section.
'space_error_info ' should be 'ora_space_error_info '.
Jared
Jared.Still@(protected)
Sent by oracle-l-bounce@(protected)
05/10/2Could you be running into a platform-specific limitation? 1073741824
could be too large so it ignores the command and leaves the default of
5m.
Daniel Fink
Thomas Jeff wrote
> Any ideas w
You 've lost a bit of your wait.
Hi Abhishek
I have a question and a comment
> The cost
> calculated by the CBO is primarily comprised of physical I/O.
> 3D The actual formula is documented as 3D20 IO + CPU/1000 +
> NetIO*
On 05/03/2004 02 37 10 PM solbeach@(protected) wrote
> OK I 'm having a brain cramp and can 't find an SQL example.
> I have a table with a PK which has a child table associated
> with it by a FK.
Has anybody been successful with building DBD Oracle under Cygwin environment?
DBI-1.42 wasn 't making any problems but I couldn 't build DBD Oracle client with
neither 10g client nor with the 9.2
Notes in-line.
Regards
Jonathan Lewis
http //www.jlcomp.demon.co.uk
The Co-operative Oracle Users ' FAQ
http //www.jlcomp.demon.co.uk/faq/ind_faq.html
Optimising Oracle Seminar
http //Thank you Jonathan.
I changed the approach.
I started looking for this wait in realtime and I found it. As a matter of
fact it 's still there andit seems it will be here for a while.
V$SESSIO
Something has to be updating one of the tables
or you couldn 't get ORA-01555. I would check
to see if any of the code is doing 'select for update '
rather than a simple 'update '. There are versiOracle Application Express
http //www.oracle.com/technology/products/database/application_express/index.html
Cheers
---Phil
On 31/01/06 Mladen Gogala <gogala@(protected) > wrote
>
> On 01/31/2I am not sure about 10g but 9i comes with a utility called Oracle
Administration Assistant for Windows NT
you can use this to set the database to open with the service starts.
Josh C.
----
On 05/03/2004 01 48 50 PM Michael Milligan wrote
> ....
Mladen is out of this thread as he promised to some friends in private.
Please do not mention my name in vain.
--
Mladen Gogala
OracI don 't think that it will work without a significant programming/configuration
effort on your part. I spent one entire morning trying to make OpenOffice to work
with the oracle JDBC. These things a
Can you clarify your comments about ITL and ITC.
Do you mean that the value from ini_trans in
dba_tables and dba_indexes were 10 and 11
respectively ?
If so then you should expect the numbeHi!
You can use oradim.exe for changing Oracle services in windows.
Also you should check your alert.log to see which command was used for
startup and whether there was any errors.
Tanel.
On 05/03/2004 11 24 37 AM "Khedr Waleed " wrote
> May be it 's not the right time to mention this but I previously
> wondered about the need of those tips.
>
> We all know the source know David
By output differences do you mean time and stats related to
logical i/o and physical i/o? Or do you mean execution plans
row counts etc.
In the first case you can flush the buffer cRyan
I think a lot depends on how much you judge the risk to be. Cary has
some ideas in his book (Optimizing Oracle Performance) for taking the
logical I/O 's and trying to extrapolate them to t
Swap on Solaris is so much more fun than other systems. Roughly 50% to 75%
of physical memory is considered swap space. If you don 't believe me check
the swap information output from a "top | You are using MTS/SS in an idle database instance.
on 5/6/04 2 23 PM Seema Singh at oracledbam@(protected) wrote
> Hi
> My system waitevents show follwoing stats.
>
If you use the mechanism
open ref cursor for SQL statement
this requires an explicit parse call -
which can still introduce undesirable
contention in a high-activity even if
the parse cgo here and run this script. It will set whatever hit ratio you want.
http //www.oracledba.co.uk/tips/choose.htm
Love that script. Very useful when management wants a high hit ratio.
>
> I n > Hi all
>
> I actually have an Oracle8i certification available for sale.
>
> I got my 8i certification a while back so it 's all a little worn and used
> now. However my poor head is so full ofAs an alternative consider using the AUDIT command if all you 're going to do is store who what and when.
Rich
Rich Jesse System/Database Administrator
rich.jesse@(protected)
On 04/30/2004 03 59 43 PM Juan Cachito Reyes Pacheco wrote
> ( the reason to change the name is because mladlen asked not to do weekly
> tips so from now I do no weekly tips)
The name is Mla >Officially the vendor 's policy is that these are not to be changed
>however I 've had some success using outlines to elicit different
>behaviors for queries of this type.
>
>Try entering an outHi Dan
I MetaLink 'd as well and then RTFM 'd.
It seems that retrieving all DDL that is needed to recreate a schema via
DBMS_METATDATA is a daunting task.
It is frankly rather amazing to me thHi List.
I have detected high enqueue waits in one instance.
After quering x$ksqst I realized most of them were TX and TC enqueues.
I 'm on the TX enqueues by tracing some sessions. But I have nevAnyoe have amy idea why I 'm not gettign trace files gnerated?
On my first go around I got a trace on one session but not the 2nd and now
I can 't get either one to generate a trace file
max_dump_fi |
|
|
