Oracle Magazine, May/June 2019
Database Developer and DBA ETL tion is running under This equates to the USER_ ID column in the DBA_ USERS dictionary ORACLE MAGAZINE MAY JUNE 2019 111 view SERVICE is the database service your application is connecting to Sadly services are a dramatically underutilized feature of Oracle Database so many applications simply use the default service name equal to the database name See the documentation for details on how to take advantage of database services The MODULE and ACTION columns enable you to track back the level of granularity provided by the application developer in SQL statements if your application is instrumented to use the MODULE and ACTION column values via the DBMS_ APPLICATION_ INFO package or via the end to end metrics capabilities in the various Java Python and other drivers The PROGRAM_ ID and PROGRAM_ LINE columns will include the OBJECT_ ID function and the program line number of the PL SQL object in the database if the SQL statement originated from a PL SQL stored program unit The sidebar A Higher Level Perspective on SQL Tuning Part 2 PL SQL includes an example that uses these V SQL columns to track SQL Refer to the SmartDB Resource Center for details on the benefits of controlling all database access via a secure PL SQL shell Although V SQL is a very powerful view for discovering information about SQL statements currently in the shared SQL area there is a risk to using it Querying V SQL occasionally for a particular performance issue that occurs rarely is fine but if you are diagnosing a system that is under severe duress then hammering away at V SQL can create problems of its own A system under duress is quite possibly experiencing extreme contention in its shared memory structures and by aggressively querying V SQL you may be adding to that workload and or contention This appears to be a catch 22 situation How do you diagnose a struggling system if diag
You must have JavaScript enabled to view digital editions.