Techniques for providing application contextual information
Techniques for providing application contextual information. One or more sets of database context identifiers corresponding to events that occur within the database are generated by the database. The one or more sets of database context identifiers have at least one application context field. A session identifier corresponding to a session to be monitored is sent from the application to the database. Information to be stored in the database with the session identifier is sent to the database. Database logs and application logs are correlated using at least the session identifier.
1. In an environment having at least one database and at least one application, a method comprising:
generating, by the environment, one or more sets of database identifiers corresponding to one or more events that occur within the database, wherein the one or more sets of database identifiers have at least one application field to store diagnostic data;
sending, from the environment to the application, a session identifier corresponding to a group of diagnostic operations;
sending, from the application, information to be stored in the at least one application field with the session identifier;
generating database logs and application logs comprising the one or more events being co-related by at least the session identifier.
2. The method of claim 1 wherein the correlating the database logs and the application logs comprises at least sending an application stack from the application to the environment.
3. The method of claim 2 wherein the correlating database logs and application logs further comprises at least sending a stack trace from the environment to the application.
4. The method of claim 2 wherein the application stack further includes encapsulated diagnostic information from multiple levels within the environment.
5. The method of claim 2 wherein the application stack further includes encapsulated time-spent information from multiple levels within the environment.
6. The method of claim 1 wherein the database identifiers provide context information to identify a logical positioning within the environment of a corresponding component.
7. The method of claim 1 wherein the database identifiers provide error or time-spent statistical information.
8. A non-transitory computer-readable medium having stored thereon instructions that, when executed by one or more processors, cause the one or more processors, in an environment having at least one database and at least one application, to
generate, by the environment, one or more sets of database identifiers corresponding to one or more events that occur within the database, wherein the one or more sets of database identifiers have at least one application field to store diagnostic data;
send, from the environment to the application, a session identifier corresponding to a group of diagnostic operations;
send, from the application, information to be stored in the at least one application field with the session identifier;
generate database logs and application logs comprising the one or more events being co-related by at least the session identifier.
9. The non-transitory computer-readable medium of claim 8 wherein the correlating the database logs and the application logs comprises at least sending an application stack from the application to the environment.
10. The non-transitory computer-readable medium of claim 9 wherein the correlating database logs and application logs further comprises at least sending a stack trace from the environment to the application.
11. The non-transitory computer-readable medium of claim 9 wherein the application stack further includes encapsulated diagnostic information from multiple levels within the environment.
12. The non-transitory computer-readable medium of claim 9 wherein the application stack further includes encapsulated time-spent information from multiple levels within the environment.
13. The non-transitory computer-readable medium of claim 8 wherein the database identifiers provide context information to identify a logical positioning within the environment of a corresponding component.
14. The non-transitory computer-readable medium of claim 8 wherein the database identifiers provide error or time-spent statistical information.
15. A system comprising:
a physical memory device;
one or more hardware processors coupled with the physical memory device, the one or more hardware processors configurable to:
generate, by the environment, one or more sets of database identifiers corresponding to one or more events that occur within the database, wherein the one or more sets of database identifiers have at least one application field to store diagnostic data;
send, from the environment to the application, a session identifier corresponding to group of diagnostic operations;
send, from the application, information to be stored in the at least one application field with the session identifier;
generate database logs and application logs comprising the one or more events being co-related by at least the session identifier.
16. The system of claim 15 wherein the correlating the database logs and the application logs comprises at least sending an application stack from the application to the environment.
17. The system of claim 16 wherein the correlating database logs and application logs further comprises at least sending a stack trace from the environment to the application.
18. The system of claim 16 wherein the application stack further includes encapsulated diagnostic information from multiple levels within the environment.
19. The system of claim 16 wherein the application stack further includes encapsulated time-spent information from multiple levels within the environment.
20. The system of claim 15 wherein the database identifiers provide context information to identify a logical positioning within the environment of a corresponding component.