Welcome! Use the login menu to access:
Customer Portal
SolarWinds customers can download purchased software, renew maintenance, & more in our updated Customer Portal!
Community
After logging in, community members can rate & review SolarWinds software & participate in forums on thwack.com.
Partner Portal
SolarWinds channel partners will find all the resources they need in the Partner Portal, including exclusive partner tools.
| More

SolarWinds Knowledge Base

DDL or commits - What does this mean?

Description

Ignite may show 'DDL or commits' along with other SQL Statements.  This means that at the time Ignite collected the information, the database instance didn't have a SQL Statement associated with the current session. The session is likely in one of the following situations.

1)  The session was running a command that is not tracked by the database vendor as a traditional statement.

    Commits
    Data Definition Statements (DDL) - e.g. create table statements
    Backups
    Statistics maintenance
    etc.

2)  The session was between SQL statements.  When a session is running multiple SQL Statements it may spend time between the statements cleaning up after the last statement or preparing to accept the next one.

Further Investigation
Drill into the 'DDL or commits' with Ignite to determine the program and waits associated with this classification.  That information will often give a clue as to what is likely occurring.

Oracle SQL run from DBMS_JOB or DBMS_SCHEDULER

There are two Oracle-specific bugs that cause any SQL executed from DBMS_JOB or DBMS_SCHEDULER to show up as 'DDL or commits'

Bug 5928612 -  V$SESSION SQL_ADDRESS / SQL_HASH_VALUE not set for DBMS_JOBs
Fixed in 10.2.0.4 and 11.1.0.7


Bug 5140631  - V$SESSION.sql_address not set by DBMS_SCHEDULER
Fixed in 10.2.0.4 and 11.1.0.6

 



Related Articles

No related articles were found.

Attachments

No attachments were found.

Visitor Comments

No visitor comments posted. Post a comment

Post Comment for "DDL or commits - What does this mean?"

If this article does not provide the solution you need, please consider visiting our community forums on thwack or contacting SolarWinds Support. Please use the following form to provide comments that help us improve this KB article. Fields marked with an asterisk are required.

   Name:
* Email:
* Comment:
* Enter the code below:

 

Article Details

Last Updated
3rd of October, 2014

Would you like to...

Print this page  Print this page

Email this page  Email this page

Post a comment  Post a comment

 Subscribe me

Subscribe me  Add to favorites

Remove Highlighting Remove Highlighting

Edit this Article

Quick Edit

Export to PDF


User Opinions

No users have voted.

How would you rate this answer?




Thank you for rating this answer.

Continue