date:20030225

Re: update 30mil rows

2003-02-25 Thread chao_ping

Gurelei,
I suggest your create your new table as select other_columns,0 from 
your old table with nologging and parallel.





Regards
zhu chao
msn:[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(China Oracle User Group)

=== 2003-02-25 13:26:00 ,you wrote£º===

>Hi all:
>
>I need to update every row 30mil-rows table. 
>I have dropped the indices and running the update
> in parallel:
>
>update /*+ parallel (degree 8) */ table_name
>set field1=0;
>
>Is there anything else I could to to speed up this
>process. I don't think I can do an update in nologging
>mode. I'm running 8.1.7.4
>
>thanks for any advice.
>
>__
>Do you Yahoo!?
>Yahoo! Tax Center - forms, calculators, tips, more
>http://taxes.yahoo.com/
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>-- 
>Author: Gurelei
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

= = = = = = = = = = = = = = = = = = = =




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: chao_ping
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm

2003-02-25 Thread Connor McDonald

"Connor does a much better job of presenting than I
do."

Translation:  Connor waves his arms about, swears more
and uses a little more BS, gives beer to attendees


 --- Freeman Robert - IL <[EMAIL PROTECTED]> wrote: >
>> And to the credit of Woodrow Wilson - "The wisest
> thing to do with a fool
> is
> >> to encourage him to hire a hall and discourse to
> his fellow citizens.
> >> Nothing chills nonsense like exposure to air."
> 
> Interesting quote. It's funny, I do present with
> some frequency, and I
> stress out
> about it every time I do I'm just sure that
> there are folks out there
> that know
> a lot more about the topic I'm talking about than I
> do. I fully expect,
> every single
> time, to hear hoards of folks laughing at me when I
> say something totally
> stupid.
> 
> However, the best experience I have ever had
> presenting was at UKOUG this
> last year after my
> Oracle9i New Features presentation. First, I got
> some great feedback from
> Jonathan Lewis,
> which I was very thankful for (but, honestly, I was
> so out of it at the time
> (still in stress induced fight or flight mode) that
> I don't remember much of
> it!). Second, I saw a great presentation by Connor
> McDonald on 9i. Connor
> does a much better job of presenting than I do.
> 
> 
> Cheers to you all!
> 
> RF
> 
> Robert G. Freeman
> Technical Management Consultant
> TUSC - The Oracle Experts www.tusc.com
> 904.708.5076 Cell (It's everywhere that I am!)
> Author of several books you can find on Amazon.com!
> 
> 
> -Original Message-
> Sent: Tuesday, February 25, 2003 8:29 PM
> To: Multiple recipients of list ORACLE-L
> comm
> 
> 
> Been a while since I have been able to scan the
> list, but who could resist
> this one??? :-)
> 
> Additional Do's:
> 
> Do understand the nothing is unbreakable or bullet
> proof, assume the
> impossible isn't and have a plan for disaster
> management.
> Do appreciate that oracle support probably does deal
> with enough clueless
> people to expect you to be one of the same until you
> demonstrate otherwise.
> Do remember that somewhere there is life outside of
> RDBMS challenges, and it
> should be kept relative.
> Do take the time to share your experiences, it makes
> life much simpler for
> all of us.
> Do clearly define the objective, before you start
> detailing the solution.
> 
> Additional Do Nots
> Don't get so focused on a prescribed solution that
> you don't realize when it
> becomes self-defeating to the driving cause.
> Don't forget that as good as you are at being a dba,
> you will make mistakes
> and mis-manage, and so will those who make a living
> managing you.
> Don't forget to prescribe the solution that user
> needs, not the one they
> necessarily demand.
> 
> And to the credit of Woodrow Wilson - "The wisest
> thing to do with a fool is
> to encourage him to hire a hall and discourse to his
> fellow citizens.
> Nothing chills nonsense like exposure to air."
> 
> 
> -Original Message-
> - IL
> Sent: Monday, February 24, 2003 10:40 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> * SHOCK *
> 
> You mean someone disagrees with *ME* 
> 
> Horrors the world is soon to come to an end!!
> 
> :-))
> 
> RF
> 
> Robert G. Freeman
> Technical Management Consultant
> TUSC - The Oracle Experts www.tusc.com
> 904.708.5076 Cell (It's everywhere that I am!)
> Author of several books you can find on Amazon.com!
> 
> 
> -Original Message-
> Sent: Monday, February 24, 2003 7:09 AM
> To: Multiple recipients of list ORACLE-L
> comments
> 
> 
> MccDBA:
> 
> It is just Robert's Don't list ;) but you can always
> give your opinion 
> abt that. Would you mind telling us 'Why you don't
> agree on them?'
> 
> 
> KG
> 
> --- dist cash <[EMAIL PROTECTED]> wrote:
> > 
> > 
> > I don't agree with "don't" #1 and #5.
> > 
> > 
> > 
> > 
> > >From: "Stephane Faroult"
> <[EMAIL PROTECTED]>
> > >Reply-To: [EMAIL PROTECTED]
> > >To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> > >Subject: RE: RE: Top 10 DBA Do's and Don'ts
> anyone - Here is my
> > list,
> > >comments
> > >Date: Mon, 24 Feb 2003 00:23:37 -0800
> > >
> > > >Here is the list of top 10 do's and don't that
> I
> > > >came up with.
> > > >
> > > >#1 - Do Maintain your Expertise
> > > >#2 - Do Use the DBMS_STATS Package to Collect
> > > >Statistics
> > > >#3 - Do Use Bind Variables
> > > >#4 - Do Put your Production Database in
> ARCHIVELOG
> > > >Mode
> > > >#5 - Do Use Locally Managed Tablespaces
> > > >#6 - Do Monitor Your Database
> > > >#7 - Do Practice Recoveries
> > > >#8 - Do Get Involved with User Groups and Other
> > > >Resources
> > > >#9 - Do Establish Standards and Change Control
> > > >Processes
> > > >#10 - Do Think Ahead
> > > >
> > > >Bonus! - Do tune to Reduce Logical IO's Not
> > > >Physical IO's.
> > > >(With regards to Cary!)
> > > >
> > > >Oracle Database Top 10 Don'ts
> > > >#1 - Don't Waste Time Re-Organizing Your
> Databases
> > > >#2 - Don't Use .Log or Other Common Exte

RE: LIBRARY CACHE LOCK !!!! ( SQL Tuning )

2003-02-25 Thread Reddy, Madhusudana

Thanks John !!
In this present case the PL/SQL code ,which was shown below itself is
causing the deadlock ( SELF DEADLOCK !! ,also plz find the deadlock graph
shown below), i mean the session which is holding the Library Cache Lock . I
want your expertise in identifying the problem with the code which i have
shown below !. that would be great help to me !!!

Thanks in advance,
Madhu

-Original Message-
Sent: Tuesday, February 25, 2003 9:29 PM
To: Multiple recipients of list ORACLE-L


To see who's holding a library cache lock on your object, you could run
the following query:

Select s.sid,kglpnmod "mode", kglpnreq "req"
>From x$kglpn p, v$session s
Where p.kglpnuse = s.sddr
And kglpnhdl=
(select p1raw 
from v$session_wait
where sid=&your_sid)
/

(as long as you know your sid)

I use this whenever there are lots of library cache pin, library cache
lock, or library cache load lock waits in v$session_wait (in my
environment, usually b/c developers are compiling code at inappropriate
times).

- John

-Original Message-
Madhusudana
Sent: Tuesday, February 25, 2003 8:49 PM
To: Multiple recipients of list ORACLE-L

Thanks Jared 


Here is the Graph i can see in the trace file : ( SELF DEADLOCK  )















A deadlock among DDL and parse locks is detected.
This deadlock is usually due to user errors in
the design of an application or from issuing a set
of concurrent statements which can cause a deadlock.
This should not be reported to Oracle Support.
The following information may aid in finding
the errors which cause the deadlock:
ORA-04020: deadlock detected while trying to lock object
MDO.MDO_BSE_TEMP_RETEK_PRICE

  object   waiting  waiting   blocking blocking
  handle   session lock mode   session lock mode
        
c0004f641168  c00031a6df18 c00033dd66f8X
c00031a6df18
c00033cef0a0S

-- DUMP OF WAITING AND BLOCKING LOCKS --

- WAITING LOCK -

SO: c00033dd66f8, type: 33, owner: c0003393b710, flag:
INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=c00033dd66f8 handle=c0004f641168
request=X
call pin=0 session pin=0
user=c00031a6df18 session=c00031a6df18 count=0 flags=[00]
savepoint=408
LIBRARY OBJECT HANDLE: handle=c0004f641168
name=MDO.MDO_BSE_TEMP_RETEK_PRICE
hash=74b60038 timestamp=01-09-2002 18:05:20
namespace=TABL/PRCD/TYPE flags=TIM/SML/[0200]
--=-055d-075d lock=S pin=S latch=1
lwt=c0004f641198[c00033dd6718,c00033dd6718]
ltm=c0004f6411a8[c0004f6411a8,c0004f6411a8]
pwt=c0004f6411c8[c0004f6411c8,c0004f6411c8]
ptm=c0004f641258[c0004f641258,c0004f641258]
ref=c0004f641178[c0004e451f50,c00035020518]
  LIBRARY OBJECT: object=c0004f6476a0
  type=TABL flags=EXS/LOC[0005] pflags= [00] status=VALD load=0
  DATA BLOCKS:
  data# heap  pointer status pins change
  -   --  --
  0 c0004f6410a8 c0004f647790 I/P/A 0 NONE
  2 c000483699e0 c00038dfdcb8 I/P/A 1 NONE
  3 c00048369a88 c00047ed33f0 I/-/A 0 NONE
  4 c0004f640c98 c000354158b8 I/-/A 0 NONE
  6 c0004f640d400 -/P/- 0 NONE
  8 c0004f640bd0 c0003b9a80f0 I/-/A 0 NONE
  9 c00048369b500 I/P/- 0 NONE
 10 c0004f640de8 c0003bf98e90 I/-/A 0 NONE
- BLOCKING LOCK 

SO: c00033cef0a0, type: 33, owner: c00033d58720, flag:
INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=c00033cef0a0 handle=c0004f641168
mode=S
call pin=c00033cec8b8 session pin=0
user=c00031a6df18 session=c00031a6df18 count=5 flags=PNC/[04]
savepoint=241
LIBRARY OBJECT HANDLE: handle=c0004f641168
name=MDO.MDO_BSE_TEMP_RETEK_PRICE
hash=74b60038 timestamp=01-09-2002 18:05:20
namespace=TABL/PRCD/TYPE flags=TIM/SML/[0200]
--=-055d-075d lock=S pin=S latch=1
lwt=c0004f641198[c00033dd6718,c00033dd6718]
ltm=c0004f6411a8[c0004f6411a8,c0004f6411a8]
pwt=c0004f6411c8[c0004f6411c8,c0004f6411c8]
ptm=c0004f641258[c0004f641258,c0004f641258]
ref=c0004f641178[c0004e451f50,c00035020518]
  LIBRARY OBJECT: o

Newspaper story about conferences, Hotsos Symposium

2003-02-25 Thread Cary Millsap

Many of you attended our Hotsos Symposium in Dallas earlier
this month. You might be interested in an article (below) that was published in
the Dallas Morning News about a week ago.

1 2 >

1 - 100 of 181 matches

Mail list logo