Sunday, December 23, 2007

Query ...

Asked by a old DBA friend about waits caused by wait event "OS THREAD STARTUP" found in his 10g RAC(4 nodes on solaris with ASM)


SELECT DECODE (session_state, 'WAITING', event, NULL) event,
session_state, COUNT(*), SUM (time_waited) time_waited
FROM gv$active_session_history
WHERE sample_time > SYSDATE - 1
GROUP BY DECODE (session_state, 'WAITING', event, NULL),
session_state order by time_waited desc;

Node 1

enq: TX - row lock contention
WAITING
3517
1734721441

os thread startup
WAITING
743
681425655

log file sync
WAITING
3557
530889167

DFS lock handle
WAITING
1131
528346071

db file sequential read
WAITING
34162
502368757

PX Deq: Signal ACK
WAITING
3917
406436176

reliable message
WAITING
283
251896304

gc buffer busy
WAITING
580
175092687

db file parallel read
WAITING
2606
169615544

Streams AQ: qmn coordinator waiting for slave to start
WAITING
123
121679315


I'm concluding on base of my experiecne of parallel queries(on test
machine with single CPU!!!! so no benefit in my case no matter I had RAC)

I see there are PX events indicating your RAC database
instances has parallel query/dml executions but I
guess the os thread startup wait event has nothing to
do with rac environment. This event indicates the
waitupon starting os process(thread) to start query
slave process for execution of parallel query. if u
set init parameter parallel_min_server sufficently
high,you may slightly cut this overhead but its not
recomendded. But instead of following rules of thumb
you check trade-off if you have significant waits.

23 comments:

Oracle bee said...

Hi,
Good Work!


Imran

Anonymous said...

...please where can I buy a unicorn?

Anonymous said...

Bravo, la frase magnГ­fica y es oportuno http://nuevascarreras.com/tag/cialis/ cialis 20 mg 8 comprimidos Meravigliosa, questo divertente informazioni comprar cialis generico en espana zzuckrvnvg [url=http://www.mister-wong.es/user/COMPRARCIALIS/comprar-viagra/]viagra cialis[/url]

Anonymous said...

wise to spring pendants [url=http://www.blingforfun.com]hip go jewelry[/url],[url=http://www.blingforfun.com/pendants/cat_9.html]hip skip pendants[/url],informed short trip watches,[url=http://blingforfun.com/belts/cat_18.html]bling bling[/url] ,hip come,[url=http://blingforfun.com/chains/cat_7.html]hip caper chains[/url],hip leap bling,[url=http://blingforfun.com/chains/cat_7.html]iced alibi chains[/url],[url=http://www.blingforfun.com/chains/cat_7.html]wholesale chains[/url]
hip spring jewelry

Anonymous said...

[url=http://forum.runningsports.org/members/pamela-anderson-sex-video.aspx] pamela anderson sex video[/url] [url=http://www.sqlprof.com/members/carmen-electra-naked.aspx] carmen electra naked[/url] [url=http://www.sqlprof.com/members/britney-spears-naked.aspx] britney spears naked[/url] [url=http://www.sqlprof.com/members/nude-lara.aspx] nude lara[/url] [url=http://www.sqlprof.com/members/kidman-nude.aspx] kidman nude[/url] [url=http://www.sqlprof.com/members/lisa-edelstein-nude.aspx] lisa edelstein nude[/url] [url=http://www.sqlprof.com/members/adriana-lima-nude.aspx] adriana lima nude[/url] [url=http://www.sqlprof.com/members/jodi-lyn-o-keefe-nude.aspx] jodi lyn o keefe nude[/url] [url=http://www.sqlprof.com/members/naked-emma.aspx] naked emma[/url] [url=http://www.sqlprof.com/members/sandra-bullock-nude.aspx] sandra bullock nude[/url]

Anonymous said...

[url=http://www.sqlprof.com/members/rhona-mitra-nude.aspx] rhona mitra nude[/url] [url=http://forum.runningsports.org/members/pamela-porn.aspx] pamela porn[/url] [url=http://www.sqlprof.com/members/victoria-silvstedt-nude.aspx] victoria silvstedt nude[/url] [url=http://www.sqlprof.com/members/emma-sjoberg-nude.aspx] emma sjoberg nude[/url] [url=http://www.sqlprof.com/members/carmen-electra-naked.aspx] carmen electra naked[/url] [url=http://www.sqlprof.com/members/KATY-PERRY-NAKED.aspx] katy perry naked[/url] [url=http://forum.runningsports.org/members/pamela-nude.aspx] pamela nude[/url] [url=http://www.sqlprof.com/members/tomb-raider-nude.aspx] tomb raider nude[/url] [url=http://www.sqlprof.com/members/lopez-nude.aspx] lopez nude[/url] [url=http://www.sqlprof.com/members/jennifer-lopez-naked.aspx] jennifer lopez naked[/url]

Anonymous said...

[url=http://forum.runningsports.org/members/pam-anderson-naked.aspx] pam anderson naked[/url]
[url=http://forum.runningsports.org/members/pamela-anderson-naked.aspx] pamela anderson naked[/url]
[url=http://forum.runningsports.org/members/pamela-anderson-tape.aspx] pamela anderson tape[/url]
[url=http://forum.runningsports.org/members/pamela-anderson-porn.aspx] pamela anderson porn[/url]
[url=http://forum.runningsports.org/members/hot-pamela-anderson.aspx] hot pamela anderson[/url]
[url=http://forum.runningsports.org/members/pamela-anderson-sex-video.aspx] pamela anderson sex video[/url]
[url=http://forum.runningsports.org/members/pamela-anderson-xxx.aspx] pamela anderson xxx[/url]
[url=http://forum.runningsports.org/members/pamela-anderson-boobs.aspx] pamela anderson boobs[/url]
[url=http://forum.runningsports.org/members/pamela-anderson-sextape.aspx] pamela anderson sextape[/url]
[url=http://forum.runningsports.org/members/pamela-anderson-sex-videos.aspx] pamela anderson sex videos[/url]

Anonymous said...

[url=http://www.sqlprof.com/members/denise-milani-naked.aspx] denise milani naked[/url]
[url=http://forum.runningsports.org/members/salma-hayek-nude.aspx] salma hayek nude[/url]
[url=http://forum.runningsports.org/members/nude-salma-hayek.aspx] nude salma hayek[/url]
[url=http://forum.runningsports.org/members/salma-hayek-sexy.aspx] salma hayek sexy[/url]
[url=http://forum.runningsports.org/members/salma-hayek-sex-scene.aspx] salma hayek sex scene[/url]
[url=http://forum.runningsports.org/members/salma-hayek-tits.aspx] salma hayek tits[/url]
[url=http://forum.runningsports.org/members/pamela-sex.aspx] pamela sex[/url]
[url=http://forum.runningsports.org/members/anderson-nude.aspx] anderson nude[/url]
[url=http://forum.runningsports.org/members/pamela-nude.aspx] pamela nude[/url]
[url=http://forum.runningsports.org/members/naked-pamela.aspx] naked pamela[/url]
[url=http://forum.runningsports.org/members/pamela-porn.aspx] pamela porn[/url]

Anonymous said...

[url=http://www.sqlprof.com/members/bellucci-nude.aspx] bellucci nude[/url]
[url=http://www.sqlprof.com/members/lopez-nude.aspx] lopez nude[/url]
[url=http://www.sqlprof.com/members/sandra-nude.aspx] sandra nude[/url]
[url=http://www.sqlprof.com/members/aniston-nude.aspx] aniston nude[/url]
[url=http://www.sqlprof.com/members/jolie-nude.aspx] jolie nude[/url]
[url=http://www.sqlprof.com/members/rhona-mitra-naked.aspx] rhona mitra naked[/url]
[url=http://www.sqlprof.com/members/natalia-oreiro-naked.aspx] natalia oreiro naked[/url]
[url=http://www.sqlprof.com/members/amy-wong-naked.aspx] amy wong naked[/url]
[url=http://www.sqlprof.com/members/summer-glau-naked.aspx] summer glau naked[/url]
[url=http://www.sqlprof.com/members/amy-smart-naked.aspx] amy smart naked[/url]

Anonymous said...

[url=http://www.sqlprof.com/members/evangeline-lilly-nude.aspx] evangeline lilly nude[/url]
[url=http://www.sqlprof.com/members/erica-durance-nude.aspx] erica durance nude[/url]
[url=http://www.sqlprof.com/members/jordana-brewster-nude.aspx] jordana brewster nude[/url]
[url=http://www.sqlprof.com/members/jamie-lee-curtis-nude.aspx] jamie lee curtis nude[/url]
[url=http://www.sqlprof.com/members/elizabeth-banks-nude.aspx] elizabeth banks nude[/url]
[url=http://www.sqlprof.com/members/amanda-tapping-nude.aspx] amanda tapping nude[/url]
[url=http://www.sqlprof.com/members/victoria-silvstedt-nude.aspx] victoria silvstedt nude[/url]
[url=http://www.sqlprof.com/members/rhona-mitra-nude.aspx] rhona mitra nude[/url]
[url=http://www.sqlprof.com/members/tomb-raider-nude.aspx] tomb raider nude[/url]
[url=http://www.sqlprof.com/members/rachel-weisz-nude.aspx] rachel weisz nude[/url]

Anonymous said...

[url=http://www.sqlprof.com/members/paris-hilton-naked.aspx] paris hilton naked[/url]
[url=http://www.sqlprof.com/members/jennifer-aniston-naked.aspx] jennifer aniston naked[/url]
[url=http://www.sqlprof.com/members/naked-emma.aspx] naked emma[/url]
[url=http://www.sqlprof.com/members/jolie-naked.aspx] jolie naked[/url]
[url=http://www.sqlprof.com/members/britney-spears-naked.aspx] britney spears naked[/url]
[url=http://www.sqlprof.com/members/kamael-nude.aspx] kamael nude[/url]
[url=http://www.sqlprof.com/members/mylene-farmer-nude.aspx] mylene farmer nude[/url]
[url=http://www.sqlprof.com/members/milla-jovovich-nude.aspx] milla jovovich nude[/url]
[url=http://www.sqlprof.com/members/adriana-lima-nude.aspx] adriana lima nude[/url]
[url=http://www.sqlprof.com/members/oniblade-nude.aspx] oniblade nude[/url]

Anonymous said...

[url=http://www.sqlprof.com/members/maxprobka.aspx] naked angel[/url]
[url=http://www.sqlprof.com/members/naked-mary.aspx] naked mary[/url]
[url=http://www.sqlprof.com/members/jennifer-lopez-naked.aspx] jennifer lopez naked[/url]
[url=http://www.sqlprof.com/members/KATY-PERRY-NAKED.aspx] katy perry naked[/url]
[url=http://www.sqlprof.com/members/carmen-electra-naked.aspx] carmen electra naked[/url]
[url=http://www.sqlprof.com/members/jessica-simpson-naked.aspx] jessica simpson naked[/url]
[url=http://www.sqlprof.com/members/naked-nicole.aspx] naked nicole[/url]
[url=http://www.sqlprof.com/members/pamela-anderson-naked.aspx] pamela anderson naked[/url]
[url=http://www.sqlprof.com/members/lindsay-lohan-naked.aspx] lindsay lohan naked[/url]

Anonymous said...

[url=http://healingstartswithus.net/members/naked-sandra-bullock.aspx]naked sandra bullock[/url]
[url=http://healingstartswithus.net/members/nude-sandra-bullock.aspx]nude sandra bullock[/url]
[url=http://healingstartswithus.net/members/sandra-bullock-ass.aspx]sandra bullock ass[/url]
[url=http://healingstartswithus.net/members/sandra-bullock-naked.aspx]sandra bullock naked[/url]
[url=http://healingstartswithus.net/members/sandra-bullock-nude.aspx]sandra bullock nude[/url]
[url=http://healingstartswithus.net/members/sandra-bullock-nude-scene.aspx]sandra bullock nude scene[/url]
[url=http://healingstartswithus.net/members/sandra-bullock-porn.aspx]sandra bullock porn[/url]
[url=http://healingstartswithus.net/members/sandra-bullock-sex.aspx]sandra bullock sex[/url]
[url=http://healingstartswithus.net/members/sandra-bullock-sex-scene.aspx]sandra bullock sex scene[/url]
[url=http://healingstartswithus.net/members/sandra-bullock-sexy.aspx]sandra bullock sexy[/url]

Anonymous said...

[url=http://healingstartswithus.net/members/sexy-sandra-bullock.aspx]sexy sandra bullock[/url]
[url=http://healingstartswithus.net/members/chris-brown-rihanna-sex-tape.aspx]chris brown rihanna sex tape[/url]
[url=http://healingstartswithus.net/members/free-rihanna-sex-tape.aspx]free rihanna sex tape[/url]
[url=http://healingstartswithus.net/members/naked-rihanna.aspx]naked rihanna[/url]
[url=http://healingstartswithus.net/members/nude-rihanna.aspx]nude rihanna[/url]
[url=http://healingstartswithus.net/members/rihanna-ass.aspx]rihanna ass[/url]
[url=http://healingstartswithus.net/members/rihanna-boobs.aspx]rihanna boobs[/url]
[url=http://healingstartswithus.net/members/rihanna-fake-nude.aspx]rihanna fake nude[/url]
[url=http://healingstartswithus.net/members/rihanna-fucking.aspx]rihanna fucking[/url]
[url=http://healingstartswithus.net/members/rihanna-having-sex.aspx]rihanna having sex[/url]

Anonymous said...

[url=http://healingstartswithus.net/members/rihanna-naked.aspx]rihanna naked[/url]
[url=http://healingstartswithus.net/members/rihanna-nude.aspx]rihanna nude[/url]
[url=http://healingstartswithus.net/members/rihanna-nude-chris-brown.aspx]rihanna nude chris brown[/url]
[url=http://healingstartswithus.net/members/rihanna-nude-scandal.aspx]rihanna nude scandal[/url]
[url=http://healingstartswithus.net/members/rihanna-nudes.aspx]rihanna nudes[/url]
[url=http://healingstartswithus.net/members/rihanna-playboy.aspx]rihanna playboy[/url]
[url=http://healingstartswithus.net/members/rihanna-porn.aspx]rihanna porn[/url]
[url=http://healingstartswithus.net/members/rihanna-porn-video.aspx]rihanna porn video[/url]
[url=http://healingstartswithus.net/members/rihanna-sex.aspx]rihanna sex[/url]
[url=http://healingstartswithus.net/members/rihanna-sex-tape.aspx]rihanna sex tape[/url]

Anonymous said...

[url=http://healingstartswithus.net/members/rihanna-sex-tape-free.aspx]rihanna sex tape free[/url]
[url=http://healingstartswithus.net/members/rihanna-sex-tapes.aspx]rihanna sex tapes[/url]
[url=http://healingstartswithus.net/members/rihanna-sex-video.aspx]rihanna sex video[/url]
[url=http://healingstartswithus.net/members/rihanna-sextape.aspx]rihanna sextape[/url]
[url=http://healingstartswithus.net/members/rihanna-sexy.aspx]rihanna sexy[/url]
[url=http://healingstartswithus.net/members/rihanna-tits.aspx]rihanna tits[/url]
[url=http://healingstartswithus.net/members/rihanna-xxx.aspx]rihanna xxx[/url]
[url=http://healingstartswithus.net/members/sexy-rihanna.aspx]sexy rihanna[/url]
[url=http://healingstartswithus.net/members/watch-rihanna-sex-tape.aspx]watch rihanna sex tape[/url]
[url=http://healingstartswithus.net/members/free-paris-hilton-porn.aspx]free paris hilton porn[/url]

Anonymous said...

PETRA NEMCOVA NUDE
[url=http://my.curse.com/members/KATHERIN3.aspx]PETRA NEMCOVA NUDE[/url]
PETRA NEMCOVA NUDE
[url= http://my.curse.com/members/KATHERIN3.aspx ] PETRA NEMCOVA NUDE [/url]
KIRSTEN DUNST NUDE
[url=http://my.curse.com/members/KATHERINE4.aspx]KIRSTEN DUNST NUDE[/url]
KIRSTEN DUNST NUDE
[url= http://my.curse.com/members/KATHERINE4.aspx ] KIRSTEN DUNST NUDE [/url]
SARAH SILVERMAN NUDE
[url=http://my.curse.com/members/KATHERYN4.aspx]SARAH SILVERMAN NUDE[/url]
SARAH SILVERMAN NUDE
[url= http://my.curse.com/members/KATHERYN4.aspx ] SARAH SILVERMAN NUDE [/url]
MONICA BELLUCCI NUDE
[url=http://my.curse.com/members/KATHI1.aspx]MONICA BELLUCCI NUDE[/url]
MONICA BELLUCCI NUDE
[url= http://my.curse.com/members/KATHI1.aspx ] MONICA BELLUCCI NUDE [/url]
KATE BECKINSALE NUDE
[url=http://my.curse.com/members/KATHLEEN5.aspx]KATE BECKINSALE NUDE[/url]
KATE BECKINSALE NUDE
[url= http://my.curse.com/members/KATHLEEN5.aspx ] KATE BECKINSALE NUDE [/url]

Anonymous said...

[url=http://healingstartswithus.net/members/free-paris-hilton-sex-tape.aspx]free paris hilton sex tape[/url]
[url=http://healingstartswithus.net/members/free-paris-hilton-sex-video.aspx]free paris hilton sex video[/url]
[url=http://healingstartswithus.net/members/naked-paris-hilton.aspx]naked paris hilton[/url]
[url=http://healingstartswithus.net/members/nude-paris-hilton.aspx]nude paris hilton[/url]
[url=http://healingstartswithus.net/members/paris-hilton-blow-job.aspx]paris hilton blow job[/url]
[url=http://healingstartswithus.net/members/paris-hilton-blowjob.aspx]paris hilton blowjob[/url]
[url=http://healingstartswithus.net/members/paris-hilton-boobs.aspx]paris hilton boobs[/url]
[url=http://healingstartswithus.net/members/paris-hilton-free-sex-tape.aspx]paris hilton free sex tape[/url]
[url=http://healingstartswithus.net/members/paris-hilton-fuck.aspx]paris hilton fuck[/url]
[url=http://healingstartswithus.net/members/paris-hilton-fucked.aspx]paris hilton fucked[/url]

Anonymous said...

[url=http://swienton.com/members/tila-tequila-naked-video.aspx]tila tequila naked video[/url]
[url=http://swienton.com/members/tila-tequila-nude.aspx]tila tequila nude[/url]
[url=http://swienton.com/members/tila-tequila-nude-video.aspx]tila tequila nude video[/url]
[url=http://swienton.com/members/tila-tequila-playboy-video.aspx]tila tequila playboy video[/url]
[url=http://swienton.com/members/tila-tequila-porn.aspx]tila tequila porn[/url]
[url=http://swienton.com/members/tila-tequila-porn-video.aspx]tila tequila porn video[/url]
[url=http://swienton.com/members/tila-tequila-porno.aspx]tila tequila porno[/url]
[url=http://swienton.com/members/tila-tequila-sex-videos.aspx]tila tequila sex videos[/url]
[url=http://swienton.com/members/tila-tequila-sexy.aspx]tila tequila sexy[/url]
[url=http://swienton.com/members/tila-tequila-strip.aspx]tila tequila strip[/url]
[url=http://swienton.com/members/tila-tequila-uncensored.aspx]tila tequila uncensored[/url]
[url=http://swienton.com/members/tila-tequila-video-naked.aspx]tila tequila video naked[/url]
[url=http://swienton.com/members/tila-tequila-xxx.aspx]tila tequila xxx[/url]

Anonymous said...

BRYCE DALLAS HOWARD NUDE
[url=http://my.curse.com/members/LIZZIE1.aspx]BRYCE DALLAS HOWARD NUDE[/url]
BRYCE DALLAS HOWARD NUDE
[url= http://my.curse.com/members/LIZZIE1.aspx ] BRYCE DALLAS HOWARD NUDE [/url]
DAISY FUENTES NUDE
[url=http://my.curse.com/members/LONNIE2.aspx]DAISY FUENTES NUDE[/url]
DAISY FUENTES NUDE
[url= http://my.curse.com/members/LONNIE2.aspx ] DAISY FUENTES NUDE [/url]
DANNII MINOGUE NUDE
[url=http://my.curse.com/members/LORAINE1.aspx]DANNII MINOGUE NUDE[/url]
DANNII MINOGUE NUDE
[url= http://my.curse.com/members/LORAINE1.aspx ] DANNII MINOGUE NUDE [/url]
DANNEEL HARRIS NUDE
[url=http://my.curse.com/members/LOREAN1.aspx]DANNEEL HARRIS NUDE[/url]
DANNEEL HARRIS NUDE
[url= http://my.curse.com/members/LOREAN1.aspx ] DANNEEL HARRIS NUDE [/url]
ANGIE HARMON NUDE
[url=http://my.curse.com/members/LOREEN2.aspx]ANGIE HARMON NUDE[/url]
ANGIE HARMON NUDE
[url= http://my.curse.com/members/LOREEN2.aspx ] ANGIE HARMON NUDE [/url]

Anonymous said...

miley cyrus porn cartoon porn of miley cyrus

Anonymous said...

Ukraine Distributor of electrical & utility products.

Best regards,

Alexander

please contact us:
mailto:stock-nelikvid@mail.ru
fax: +38.067.236.8637
skype: radiodetali123

Anonymous said...

Купим оптом на склад неликвиды

ICQ 177-211-010
tel:+38.095.856.14.68
Руслан

Разъем для Шлейфа 31 pin , шаг 0,5mm 7дн
ШР28У2НШn-К
СНЦ23-10/18Р1(2,4,6,8,11,12,13)(а,б,в,г)В
Р4-11 соединитель 90
ШР60ПК47НГ2 розетка приб.с прям.кож. бРО.364.028ТУ ОТК СССР
РП15-32ГВФВ СОЕДИНИТЕЛЬ НИЗКОЧАСТОТНЫЙ. 1990-2010 ГОДА.
2РМДТ30БПН32ШnВ(А)1(ЛБ)В
Соединитель угловой разъёмный 90 град. для труб ПВХ d 20
ОНп-ВС-40-6-В52
2РМГД33БПН32ШnЕ1(2)(Б)
ШР20ПК3ЭГn-К
Соединитель плоский 2,8 вилка +См
Разъем PH-3FC розетка на кабель < 1000
2РМДТ45КУЭ50ГnВ(А)1(ЛБ)В
РРС6-19-7-1-В
СНЦ23-7/22Р2В группа Разъемы ---811013
ОНЦ-БС12-76/22В1-1(1-20)В
РГ48П28ЭШ1 Коннектор "5" 79-80г
СР50-875ФВ СОЕДИНИТЕЛЬ РАДИОЧАСТОТНЫЙ. 1990-2010 ГОДА.
Разъем для а/м JVC (KS-RT 404)
РРС4-4-1-А-3(4…12)-В
2РМДТ30БПН24Г5В1В/разъем
ШР16П1ЭГ3 вилка з/у Коннектор "5" надпись шр16п2эг5
Разъем SPEACON 4MP приб.
48-365-34 разъем CPM 5,08/5
СНЦ13-22/76Р-1-а(б,в,г,д,е)(У)В
ОНп-ВС-40-4-В52
Разъем IDC-отв.часть с защелк. 2х 5 (п) на плату (104313-1) (AMP)
СНЦ13-14/30Р-6-а(б,в,г,д,е)(У)В
2РТТ60КПЭ31Ш35В
10-0060 red разъем 7дн
BNC-120 50ом/разъем
РРС4-50-А-7-2-В
4РТ28КПН7ГnОВ
Соединитель RST20i3 96.233.3004.1
СР50-470ФВ СОЕДИНИТЕЛЬ РАДИОЧАСТОТНЫЙ. 1990-2010 ГОДА.
РП15-9ШВВ
DS1070- 4F (HU-04) P.C.B. разъем шаг 2.54мм 4 контакта мама CONNFLY
Разъем РшИм2-5-4 штеккер (20 шт) ИЭК
Разъем 2х 2 (м) для пайки на плату 2мм (PBD-04N) (PBD2-4)
СШР48П20ЭГ2 Р роз блочн(перкрут с СШР48П20ЭШ2 5пз 92г) Коннектор
РРС4-4-А-9-3(4…12)-В
СНЦ27-45/39В-1(а,б,в,г)В
Разъем 2х 3 (м) для пайки на плату (PBD-6)
Имп.разъем DB-9F (черные)
ШР28П2НГn-К
Соединитель 99.483.9999.9 -99.483.9999.9 Запрос WE
Разъем SD-08 для карт SD 7дн
СРГ50-751ФВ СОЕДИНИТЕЛЬ РАДИОЧАСТОТНЫЙ. 1990-2010 ГОДА.
СР50-75ФВ(5) группа Разъемы ---808907


54013