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, with the database, one or more sets of database context identifiers corresponding to events that occur within the database, wherein the one or more sets of database context identifiers have at least one application context field, the application context field storing information to provide the database environment with diagnostic files;
sending, from the database to the application, a session identifier corresponding to a session for diagnostic operations;
sending, from the application to the database, information to be stored in the database with the session identifier;
correlating database logs and application logs using at least the session identifier.
2. The method of claim 1 wherein the correlating the database logs and the application logs using at least session identifier comprises at least sending an application stack from the application to the database.
3. The method of claim 2 wherein the correlating database logs and application logs using at least session identifier further comprises at least sending a stack trace from the database 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 context identifiers provide context information to identify a logical positioning within the environment of a corresponding component.
7. 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:
generating, with the database, one or more sets of database context identifiers corresponding to events that occur within the database, wherein the one or more sets of database context identifiers have at least one application context field, the application context field storing information to provide the database environment with diagnostic files;
sending, from the database to the application, a session identifier corresponding to a session for diagnostic operations;
sending, from the application to the database, information to be stored in the database with the session identifier;
correlating database logs and application logs using at least the session identifier.
8. The non-transitory computer-readable medium of claim 7 wherein the correlating the database logs and the application logs using at least session identifier comprises at least sending an application stack from the application to the database.
9. The non-transitory computer-readable medium of claim 8 wherein the correlating database logs and application logs using at least session identifier further comprises at least sending a stack trace from the database to the application.
10. The non-transitory computer-readable medium of claim 8 wherein the application stack further includes encapsulated diagnostic information from multiple levels within the environment.
11. The non-transitory computer-readable medium of claim 8 wherein the application stack further includes encapsulated time-spent information from multiple levels within the environment.
12. The non-transitory computer-readable medium of claim 7 wherein the context identifiers provide context information to identify a logical positioning within the environment of a corresponding component.
13. 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, with the database, one or more sets of database context identifiers corresponding to events that occur within the database, wherein the one or more sets of database context identifiers have at least one application context field, the application context field storing information to provide the database environment with diagnostic files,
send, from the database to the application, a session identifier corresponding to a session for diagnostic operations,
send, from the application to the database, information to be stored in the database with the session identifier, and
correlate database logs and application logs using at least the session identifier.
14. The system of claim 13 wherein the correlating the database logs and the application logs using at least session identifier comprises at least sending an application stack from the application to the database.
15. The system of claim 14 wherein the correlating database logs and application logs using at least session identifier further comprises at least sending a stack trace from the database to the application.
16. The system of claim 14 wherein the application stack further includes encapsulated diagnostic information from multiple levels within the environment.
17. The system of claim 14 wherein the application stack further includes encapsulated time-spent information from multiple levels within the environment.
18. The system of claim 13 wherein the context identifiers provide context information to identify a logical positioning within the environment of a corresponding component.