Oninit cdi / Archive
Talk to an expert →

onmode -Y

Posted in 2005

Topics: Performance & Tuning, Server Administration

Floyd Wellershaus — — source: IIUG Forums & Mailing Lists

Anybody have any experience using onmode -Y ? It seems I should be able to find an active session I want to look at, and say, onmode -Y sessionid 1 or 0, ( I think 1 would be on ), to get an sqexplaintype output for the session. When I do it, nothing happens. Thanks, floyd ======================== -<<Floyd Wellershaus>>- Database Administrator Unix Administrator email: fwellers@yahoo.com Work: 703-733-4126 Pager: 703-705-9241 Email Pager: 7037059241@my2way.com Home: 703-430-0805 Cell: 703-477-6045 ========================

↪ replying to Floyd Wellershaus
Jairo Gubler — — source: IIUG Forums & Mailing Lists

onmode -Y <sessionid> 1 activates sqexplain. On UNIX, look at files created on the user directory (*session owner*) named sqexplain.out.<sesid>. If the session owner is <someuser> look at /home/someuser (for example). The files are created after some SQL is executed in the session. Jairo Floyd Welle.... escreveu: >Anybody have any experience using onmode -Y ? >It seems I should be able to find an active session I want to look at, and say, >onmode -Y sessionid 1 or 0, ( I think 1 would be on ), to get an sqexplaintype output for the session. When I do it, nothing happens. > >Thanks, >floyd > > >======================== >-<<Floyd Wellershaus>>- >Database Administrator >Unix Administrator > >email: fwellers@yahoo.com >Work: 703-733-4126 >Pager: 703-705-9241 >Email Pager: 7037059241@my2way.com >Home: 703-430-0805 >Cell: 703-477-6045 >======================== > > > > > -- *Jairo Gubler* /Analista de Sistemas //APL - IBD (Interfaces e Banco de Dados)/ *DÍGITRO TECNOLOGIA* *E-mail:* jairo.gubler@digitro.com.br <mailto:jairo.gubler@digitro.com.br> *Fone:*(48) 281 7213 *Fax:*(48) 281 7299 *Site:*www.digitro.com.br <http://www.portaldigitro.com.br>;

↪ replying to Floyd Wellershaus
Floyd Wellershaus — — source: IIUG Forums & Mailing Lists

Thanks. I tried that, and it doesn't work. No sqexplain file anywhere. Jairo Gubler <jairo.gubler@digitro.com.br> wrote: onmode -Y 1 activates sqexplain. On UNIX, look at files created on the user directory (*session owner*) named sqexplain.out.. If the session owner is look at /home/someuser (for example). The files are created after some SQL is executed in the session. Jairo Floyd Welle.... escreveu: >Anybody have any experience using onmode -Y ? >It seems I should be able to find an active session I want to look at, and say, >onmode -Y sessionid 1 or 0, ( I think 1 would be on ), to get an sqexplaintype output for the session. When I do it, nothing happens. > >Thanks, >floyd > > >======================== >-<>- >Database Administrator >Unix Administrator > >email: fwellers@yahoo.com >Work: 703-733-4126 >Pager: 703-705-9241 >Email Pager: 7037059241@my2way.com >Home: 703-430-0805 >Cell: 703-477-6045 >======================== > > > > > -- *Jairo Gubler* /Analista de Sistemas //APL - IBD (Interfaces e Banco de Dados)/ *DÍGITRO TECNOLOGIA* *E-mail:* jairo.gubler@digitro.com.br *Fone:*(48) 281 7213 *Fax:*(48) 281 7299 *Site:*www.digitro.com.br ======================== -<<Floyd Wellershaus>>- Database Administrator Unix Administrator email: fwellers@yahoo.com Work: 703-733-4126 Pager: 703-705-9241 Email Pager: 7037059241@my2way.com Home: 703-430-0805 Cell: 703-477-6045 ========================

Glossary