 | | | Oracle List | | > I 've been asked to prove why the Redos shouldn 't be RAID 10 because the
> striping should allow for faster writes. I remember reading that this was
> nullified by the sequential nature of the wrOn 02/02/2004 11 04 04 AM "Jesse Rich " wrote
> According to screenshots from
> http //otn.oracle.com/obe/obe10gdb/install/linuxinst/linuxinst.htm it
> looks
> like the installer checks to see isource$ ?
select s.source
from source$ s obj$ o
where o.obj# s.obj#
and o.name 'fn_Format_Address '
/
Ray
-----Original Message-----
From Tim Onions [mailto tim.onions@(protected)Got it. Thanks very much!
Viktor
Connor McDonald <hamcdc@(protected) > wrote
Once you drop out of your final loop don 't forget to close the currently open file
hth
connor
--- Viktor wroteNT ? Seriously?
3.51 or 4.0?
I hope you really mean Windows 2000 or Windows Server 2003.
Better yet leave it alone.
Why would you do this?
Your performance on NT/Win2k will be percepibI 'm writing SQL to summarise packages/procedures/functions right down to
parameters used datatypes and defaults values. However although I can find
a flag that shows whether or not a parameter has
If you are controlling the trace file from outside
the session you may be stuck. But if the session
is issuing its own 'set sql_trace true ' call then you
try to include a mechanism for gettingGene
If you see your enqueue waits are significant in v$system_event then you
may have an enqueue wait problem in your instance.
Then you can also check sys.x$ksqst (enqueue statistics) and getCary is certainly welcome to correct me if I 'm wrong but I think since
it doesn 't make logical sense to have negative wait time you should
report 0 wait time and the negative time as "unaccountedHi
Thank you. Very helpful.
Regards
Stefan
-----Urspr?ngliche Nachricht-----
Von Frank B. Hansen [mailto frank.b.hansen@(protected)]
Gesendet Montag 2. Februar 2004 12 17
An oracle-l@John
Below is a sample sql script which demonstrates using stored outlines. It 's
based on one used at a course I was on but it should work with the sample
SCOTT/TIGER emp table (it does on 9.2).Hi Stefan
Check out Metalink note 116833.1
Cheers Frank
DBA 8i 9i OCP.
----- Original Message -----
From "Stefan Jahnke " <Stefan.Jahnke@(protected) >
To "Oracle DBA List (E-Mail) " <oracle-l@(protected)I was wondering if there is a tool that will parse PLSQL code and show what tables columns join criteria etc. is being done. I am not looking for a trace or debug but rather a parser and grammer fiOnce you drop out of your final loop don 't forget to close the currently open file
hth
connor
--- Viktor <stant_98@(protected) > wrote > I got the procedure to write files as I want it - ThanksIsn 't that why the good lord has given us procmail?
A simple entry like this in your .procmailrc will do the trick
0
*^Subject .*(Out of office|autoreply)
/dev/null
This entry stores all You can even do something like
alter database backup controlfile to trace as '/tmp/rename.sql '
Connected to
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning oplittle-endian vs. big-endian architecture.
There may be methods for this in 10g but
not as of 9i.
Jared
On Sun 2004-02-01 at 05 20 Diego Cutrone wrote
> Hi list
>
> I know it 's not pHi
Here are my experiences.
I 've used it quite a few times. First back when
Revealnet sold it as a product. Now its free to
download but there may be 9i (10g) issues getting it
all compiledtest
Try and get the correct address (
> -----Original Message-----
> From Niall Litchfield [mailto niall.litchfield@(protected)]
> Sent 31 January 2004 16 14
> To 'ORACLE-L@(protected) '
> Sudeclare
prev_mth number -1
begin
for i in my_big_24mth_cursor loop
if to_number(to_char(i.date_of_interest 'MM ')) ! prev_mth then
if utl_file.is_open(f) then
clHi all
Thought you might be interested to know that Oracle has announced that the price of Oracle 10g Standard Edition One has been reduced by US$1000 to US$4999. The restriction to limit it to a dGVzdC4NCnBsZWFzZSBpZ25vcmUuDQo
>From a note by Mark Townsend on comp.databases.oracle.server
Docs go up Monday.
Announcement Tuesday
Solaris is now on-line as well.
Regards
Jonathan Lewis
http //www.jlcomp.OOps. Just replied without checking the address
At 08 44 PM 1/30/2004 you wrote
>-----BEGIN PGP SIGNED MESSAGE-----
>Hash SHA1
>
>last post
>
>Wolfgang Breitling wrote
Wolfgang Breitli
>Date Sat 31 Jan 2004 10 57 25 +0800
>To ORACLE-L@(protected)
>From Hemant K Chitale <hkchital@(protected) >
>Subject Re ** v$log.status
>
>
>LGWR will always write to the redo-logs in
/*+ no_merge */ goes after the select keyword
in the in-line view or you can use
/*+ no_merge (alias) */ after the select that has
the in-line view in its from clause.
I haven 't been follNice huh? Just thought you guys might want to know. A little error code would have been nice - like bad file not specified (I know I had seen that in some version) - but this time - nada just a littResending this to the new group ...
I have been trying to get stored outlines to work. It seems simple enough but it is working the exact opposite as I think it should. Anyone else use these? I Ana
I have been studying some of these issues but haven 't implemented
anything yet so I sincerely hope you get some good responses. I hadn 't
heard of NDS before so if you can explain that a l |
|
|
