 | | | Oracle List | | His presentation at last year 's Hotsos symposium was excellent.
Mike
Ryan wrote
> anyone been to it? Is it any good? He is having one in wash DC in may. Is it worth attending?
> -------------Hi friends
I noticed that the different oracle server processes have different
priority value and all the oracle process belong to the same instance
spawned by the same listener.
Bruce
The fact that you listener.ora resides in the same directory as
%TNS_ADMIN% does
not necessarily indicate that the %TNS_ADMIN% variable is used to locate
the
listener.ora file.
I just s$ ping localhost 2033
PING 2033 (0.0.7.241) 56(124) bytes of data.
--- 2033 ping statistics ---
9 packets transmitted 0 received 100% packet loss time 8013ms
No not really. Neither input nHowdy.
In case you don 't have the fine man page here is the URL
http //www.opengroup.org/onlinepubs/007904975/functions/lio_listio.html
Please read the fine manual and it will tell you everyNo it 's not OK it 's a sacrilege but your system will not be harmed
in any way shape or form except maybe emotionally. There was a famous
movie made after the story called "Do The Androids DreaI agree. The alert log whould tell you what is happening. The Oracle
install process is still not as clean as it should be. My guess is that the
database crashed. Probably an init.ora param is iJuan
Your goal of providing informative articles is laudable.
You might want to consider the following 2 queries more closely.
SQL > select count(*) from daz.utl_tablas_me
2 where tbl_dAs every site our has development and production databases. I 've been
told to transport approximately 20GB of data between them and innocently
asked if I can finish that in an hour. Sure heck whyHi Robert
Sorry for the previous email... I resend it with the correct title...
> > > For hash joins the optimizer creates the hash table on the smaller 20
> > > row source. In this case it 's obvioThomas you are right I didn 't said the contrary
that is the point I showed in a query that situation because
some times one forget it when analyzing if use IN or EXISTS
To show the situatiodone with the rich text editor. i 'm not going to bother with the HTML
editor since we 've seen that works OK.
--
Bill "Shrek " Thater ORACLE DBA
"I 'm going to work my ticket if I can... " -- GHi Zhu
Thanks for your reply.
I 'll share this with everyone - though it 's probably something that some
of you already know - I actually with OWS (what? There 's actually a
person there?)
Looks ok.
Niall had some suggestions for global settings that I will try.
Hopefully it won 't break anything.
Jared
"Thater William " <William.Thater@(protected) >
Sent by oraclecreate tablespace &&myTablespace datafile ' ' '&cPath '|| '/&&mytablespace.dbf ' ' ' size 5m
With all due respect automated creation of tablespaces is a very bad idea. Very
bad idea indeed. There shoulOn 02/20/2004 03 38 29 PM "Grabowy Chris " wrote
> Switch to SQL Server.
>
Yeah no bugs or security flaws there.
Parallel DML?
On 02/20/2004 11 42 35 AM Viktor wrote
> Hello
>
> I was wondering if I could get some insights on how to speed up SQL loader. I am limited to user conventional path only - DIRMichael
I 'm a bit behind in e-mail but I didn 't see that your
question was answered.
Yes you can turn off a 10046 trace.
How to turn it off depends on how you turned it on
oradebug evenThere 's a third way to do this and AFAIK it 's the _supported_ way to
do it quiesce the group run dbms_repcat.alter_master_repobject
followed by dbms_repcat.generate_replication_support. The fI have a table linked into access from oracle with a trigger on it. the
trigger controls a auto number sequence and fills other columns up depending
on what was entered. if I recompile the trigger aAll
We have installed Oracle Warehouse Builder in a development warehouse
environment. We are now being asked to install Oracle Work Flow as OWB
wants to interact with OWF.
My concern is misOn 02/20/2004 12 20 04 PM Jared.Still@(protected) wrote
> Lisa
> If you have a test box to try it on you might try installing the 2.6
> kernel
> which supports up to 64Gig of RAM.
>
> JaredLike in this example I had seen several times is better update only the
necessary
WHEN you have several columns with the values you want to update.
Specially check the redo size.
SQL > UPDATEIt depends on the type of enqueue of course but for a row wait (i.e.
waiting on a locked row)
SELECT sid taddr lockwait status sql_address
row_wait_obj# RW_OBJ# row_wait_file# RW_FILE# Let 's see if I can be the first to ask this question )
How would you define a context switch in this situation?
Are values from registers in the VOS ( don 't know if VOS actually has
registers We are setting up log_archive_dest_1 - 3 on different disks. However we are
having concerns that our design is not OFA compliant. We don 't want any data
files or log files sitting in the /u01 mount On 02/20/2004 09 40 21 AM Ruth Gramolini wrote
> Good morning all
> We just installed a new fast disk farm with fiber channels. For production
> we are using raid 10. My SA set in up with a stActually all this proves is that you have 310 rows in the table
utl_tablas_me.
Jared
"Juan Cachito Reyes Pacheco " <jreyes@(protected) >
Sent by oracle-l-bounce@(protected)
02On 02/20/2004 08 22 13 AM "Thater William " wrote
> OK i 'm using outlook 2000 SR-1 and have just set my encoding to US-ASCII.
> let 's see if the unprintable characters show up. this is plain teCould you be more specific?
Igor Neyman OCP DBA
ineyman@(protected)
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On Behalf Of |
|
|
