Contact

February 11th, 2009

My contact email is tanel@tanelpoder.com

Phone/fax numbers etc are available for my consulting services clients.

  • Share/Bookmark
  1. Trackbacks

  2. No trackbacks yet.
  1. Comments

  2. March 1st, 2009 at 01:27 | #1

    Hi Tanel,
    I have been following your blog and you must have read some of my comments too over here as well as over the OTN forums too with the same sign. I am always interested in the internals and P/T stuff. I have started doing it more seriously now from some time. I want your guidance and support to learn all this. How do you research the topics? As you mentioned that you didn’t have the formal IT training so its just amazing what you are doing. I shall appreciate if you can help/guide me to go ahead with the research path. A good mentor is must as there must not be a wrong learning. And I believe, one can’t do P/T if he doesn’t know how oracle works. So can you please help me in it?

    In wait for the reply.
    Regards
    Aman….

  3. March 10th, 2009 at 23:40 | #2

    Hi Aman,

    I am still planning to write a blog entry about exacly this stuff! So keep tuned!

  4. Sriram
    September 17th, 2009 at 14:58 | #3

    I was in your recent class of Advanced troubleshooting in DC. It was really great to be in the class, learned a lot and hopefully make practical use of the systematic troubleshooting approach.
    I am trying to download your latest set of scripts, where can I find them on your web site?

  5. September 18th, 2009 at 06:00 | #4

    Hi Sriram, thanks for attending! I enjoyed these three days too!

    I have uploaded the seminar logs to my blog and also have put the latest scripts in a zip file there.

    Logs are downloadable from here:

    http://blog.tanelpoder.com/seminar/seminar-logs/

    The TPT scripts are here:

    http://blog.tanelpoder.com/seminar/seminar-files/

  6. Simon Palmer
    December 9th, 2009 at 07:22 | #5

    Hi Tanel,

    Have been using your tools alot recently… For some reason when I use usql I get a disconnect:

    SQL*Plus: Release 10.2.0.3.0 – Production on Wed Dec 9 12:20:35 2009

    Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

    Enter user-name: / as sysdba

    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – 64bit Production
    With the Partitioning, Real Application Clusters, OLAP and Data Mining options

    USERNAME INST_NAME HOST_NAME SID SERIAL# VERSION STARTED SPID CPID SADDR PADDR
    ——————– ———— ————————- —– ——– ———- ——– ————— ————— —————- —————-
    SYS UK1 lscxw01p1.ukdatapoint.com 198 4875 10.2.0.3.0 20091208 6222 6154 000000021F578F08 000000021F40E918

    SQL> select * from v$version;

    BANNER
    —————————————————————-
    Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – 64bi
    PL/SQL Release 10.2.0.3.0 – Production
    CORE 10.2.0.3.0 Production
    TNS for Linux: Version 10.2.0.3.0 – Production
    NLSRTL Version 10.2.0.3.0 – Production

    SQL> !uname -a
    Linux lscxw01p1.ukdatapoint.com 2.6.9-67.0.4.ELsmp #1 SMP Fri Jan 18 05:00:00 EST 2008 x86_64 x86_64 x86_64 GNU/Linux

    SQL> @usql 243

    HASH_VALUE CH# PLAN_HASH SQL_TEXT
    ———- —– ———- ————————————————————————————————————–
    (XMLAGG889115592 /* Formatted on 2009/09/04 12:11 (Formatter Plus v4.8.7) */
    (“venue”,ELEMENT
    (ea.venue_id AS “venue_id”,
    FROM mv_attribute_value
    AND activity_id = 301
    ),te_name = ‘venue_name’) AS “venue_name”
    (SELECT XMLAGG
    (“title”,
    xmlattributes

    CH# PARENT_HANDLE OBJECT_HANDLE PARSES H_PARSES EXECUTIONS FETCHES ROWS_PROCESSED LIOS PIOS SORTS CPU_MS ELA_MS USERS_EXECUTING
    —– —————- —————- ———- ———- ———- ———- ————– ———- ———- ———- ———- ———- —————
    0 0000000206CEF2A0 0000000206AD0200 1 1 5 4 4 32488739 16856 68775 867697.956 1240898.07 1

    SQL hash value: 586338503 Cursor address: 0000000206CEF2A0
    | Statement first parsed at: 2009-12-09/11:19:26 | 3690 seconds ago

    select –+ ordered use_nl(p ps)
    *
    ERROR at line 1:
    ORA-03113: end-of-file on communication channel

    ERROR:
    ORA-03114: not connected to ORACLE

    Have you seen this before?

    All other sqls; snapper, sw etc work fine.

    Any thoughts,

    Regards,

    Simon

  7. December 9th, 2009 at 23:51 | #6

    Hmm interesting – can you check for a tracefile from udump and send the errorstack dump which should have been written in there?

    If no tracefile is generated, check into core_dump_dest and run pstack on the corefile if one is generated and send it to me.

  8. Simon Palmer
    December 10th, 2009 at 05:05 | #7

    Good morning Tanel,

    Have emailed you @ tanel@tanelpoder.com

    Cheers,

    Simon

  9. Alvaro Fernandez
    January 17th, 2010 at 17:45 | #8

    Hi Tanel,

    I was playing with the “*ss.awk” systemstate decoder script from LTOM, but frankly I would prefer to get first more knowledge about this kind of dumps. I’ve read in some section here that you had previously taught in a seminar ways to work with them, and I wonder if this particular seminar is still available online?

    Best regards, and great thanks for your site and effort!

  10. February 1st, 2010 at 20:29 | #9

    Hello, I have been following your blog has some time and I believe that it contributes greatly to professional with performance issue in Oracle.

    I’ve been developing for some time a tool named Mandela to diagnose performance problems. It need not be installed or create any object in the database analyzed. It only needs read access to the tables of STATSPACK or AWR.

    The site is still under development, but if you want can download the Mandela and follow the launch of the latest versions.

    What makes Mandela nice? Well, he can show into timeline all statistical system, redo log files switches, statistics I/O (tablespace, and datafile filesystem) and much more…

    But what it does well done is to decompose the wait events (two clicks, three at most) and allow drilldown for the top sql by metrics (buffer gets, diskreads, cpu time, elapsed time, etc.) and now for the wait event. That’s right … from a chart of wait events you right click mouse and see the statements SQL that waited for “db file sequential read” or “CPU”, for example.

    If you’re interested (and available) to see how Mandela can help you gain productivity, access http://www.trevis.com.br/projetos/mandela/download

    If you want to chat or ask questions about the Mandela my contacts is as follows:

    [] s,
    Rafael Trevisan
    http://www.trevis.com.br
    EMail / MSN / GTalk: rafael@trevis.com.br

  11. Khalid Azmi
    March 3rd, 2010 at 05:19 | #10

    Hey Tanel, can you share some of the books that you refer or that could be helpful to Oracle DBAs in general. Also some specific books on Unix etc. I would be really grateful for that.