Monday, September 28, 2009

Module name for logon trigger in 11g R2 AWR report

Today while working on Production performance tuning, We came across one difference in awr report of 11g R1 and 11R2

In oracle 11g R1 AWR report logon trigger modelue name usually come like
sqlplus / perl / Mid Tier@server_name_from_it_login

But in 11g R2 AWR report logon trigger modelue name usually come like oraagent.bin@DB_SERVER_WHERE_IT_RUN

New change looks more logical because DB server running logon trigger code ,
not the user.




# Excerpt from 11g R1 AWR report
# In below given example app678 is server name from where
# user logged in to database using sqlplus

Module: sqlplus@app678utl (TNS V1-V3)
UPDATE scott.MY_AUDIT SET LAST_LOGIN = SYSDATE WHERE XYZ_USERNAME = :B1


#Excerpt from 11g R2 AWR report
#In below given example apps001 is database server

Module: oraagent.bin@apps001 (TNS V1-V3)
UPDATE scott.MY_AUDIT SET LAST_LOGIN = SYSDATE WHERE XYZ_USERNAME = :B1



5 comments:

  1. Never put off till tomorrow what may be done today..........................

    ReplyDelete
  2. Always keep your words soft and sweet, just in case you have to eat them.............................................

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. Yes its true that every version comes up with lots of exciting new features that not only dominates the earlier version but also interesting to explore too. I do have recently started working on 11g and have yet to explore many of its new feature.
    sap erp download

    ReplyDelete

Google