currently v$session "module", "action" and "client_info" (each varchar2(64) ) are, umm.. left unused: module always contains "Jdbc thins client", action and client info are NULL

I'd like to suggest make formspider

  • offer an application parameter client_info, controlled by the developer, changaable at runtime via "api_application.setclientinfo"
  • at runtime automatically set module to "application_name" - "datasource_schema"
  • at runtime automatically set action to "panel_name" - "event_name"

That way existing profiling tools like ORACLE Enterprise Manager immediately could help the admins to pin point ressource usage down to panel and event, even in a multi-homed app running in different schemas!

Advantage #1

When the developer additionally stores the logical "logged in user" inside_client info any legacy db triggers easily could continue to protocol username (via client_info instead of "username") with minimal trigger tweaking.

Advantage #2

Currently the operator is effectively blind, as every session belongs to "formspider" and the oracle provided module, action and client_info values are empty. Very hard to find hot spots in an application in such environment.

Cost:

Sholud be a piece of cake for the formspider team to do two calls to dbms__application__info before having the DB do their work.

desc dbms_application_info
...
PROCEDURE SET_CLIENT_INFO
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 CLIENT_INFO                    VARCHAR2                IN

PROCEDURE SET_MODULE
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 MODULE_NAME                    VARCHAR2                IN
 ACTION_NAME                    VARCHAR2                IN

asked 15 Nov '14, 16:36

dipr's gravatar image

dipr
1561323
accept rate: 0%

edited 15 Nov '14, 16:36


Hi Paul,

This sounds like a very good idea. I opened a ticket for this feature request. Thank you very much.

Kind Regards,
Yalim

link

answered 16 Nov '14, 15:56

Yalim%20Gerger's gravatar image

Yalim Gerger ♦♦
1.8k5
accept rate: 15%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×5
×3
×1
×1
×1

Asked: 15 Nov '14, 16:36

Seen: 943 times

Last updated: 16 Nov '14, 15:56


© Copyright Gerger 2017