Quick SQL tracing

Quick SQL tracing

salim Dawood

Here is a quick way to trace the SQL generated by Username, ABAP program, ProcessId or Transaction code and determine the execution plan.
1. Run transaction ST05
2. Under select-trace, check ALL boxes.
3. Under select-trace-function, select the activate-trace-with-filter.
4. You can now trace by username, transaction, program-name or process-id.
5. Select ok and the trace will be turned ON.
6. After you have executed the program or transaction, go back to ST05.
7. Select the deactivate-trace button.
8. Select diaplay-trace button and - VOILA! - you have all the juicy information you need.

Requires Free Membership to View

Login

When you register, you will start receiving targeted emails from my award-winning team of editorial writers. Our goal is to keep you informed on the hottest topics and biggest challenges faced by SAP professionals today.

Hannah Smalltree, Editorial Director

By submitting your registration information to SearchSAP.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSAP.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

Dig Deeper

Articles

Related glossary terms

Terms for Whatis.com - the technology online dictionary
- requirements stability index (RSI)

Show me more

This was first published in April 2003

Join the conversationComment

Share

Comments

Results

Contribute to the conversation

All fields are required. Comments will appear at the bottom of the article.

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

More from Related TechTarget Sites

Manufacturing ERP
Oracle
Data Management
Data Management UK
Business Analytics
CRM
Content Management
Financial Applications

Manufacturing ERP
- Collaboration technology driven by culture, communication gaps
  
  Industry experts explain how to match collaboration software such as chat, social media and conferencing with the needs of the organization.
- Manufacturer to move hosted JD Edwards ERP to 'virtual private cloud'
  
  In 11 years, EnterpriseOne ERP system has migrated from on-premises to physical and virtual servers at managed hosting provider. Next: private cloud.
- Five signs your multiple ERP systems are out of control
  
  Many manufacturers run multiple ERP systems -- or multiple instances of one system. But there are significant downsides to operating this way.
Oracle
- Integrating non-Oracle applications into Oracle environments
  
  Oracle application integration becomes even more complicated when trying to integrate Oracle applications and databases with non-Oracle applications.
- Integrating Oracle applications brings complexity
  
  Oracle’s various investments and acquisitions over the past decade have some customers struggling to integrate it all, although Oracle’s own middleware might be able to help.
- Implementing a Hyperion system in 3 weeks -- it can be done
  
  An Oracle Hyperion system implementation in three weeks? Yes, it can be done. Communications firm Neustar implemented Hyperion in less than a month and gained efficiencies in the process.
Data Management
- Oracle to financial firms: Speed is the key to avoiding systemic risk
  
  Financial services firms need to speed up their data management and analytics practices to avoid another economic crisis like the one that gripped the world in 2008.
- New GigaSpaces release promises 'big data' analytics in real time
  
  The latest version of GigaSpaces XAP is designed to let users create their own real time "big data" analytics platform, and more big data news from around the Web.
- People, process issues offer path to improve data quality on the cheap
  
  Educating end users and upgrading internal processes can help enterprises fix data quality problems without dropping a ton of cash, analysts say.
DataManagement UK
- SAS: High-performance analytics frees data scientists to model faster
  
  High-performance analytics on "big data" could aid European companies as they struggle to make headway in the recession, say senior SAS executives. All sectors are turning to big data, they claim.
- Organisational design for analytics function needs governance
  
  Scant are the absolute rules for the organizational design of the analytics function. It can be outsourced or in-house; sit within a business unit or run from the centre. But it needs governance.
- History lesson points way forward on data management projects
  
  Data management projects often suffer from historic amnesia. Projects that co-locate business and IT staff and keep to a manageable scale can achieve remarkable results, says consultant Andy Hayler.
Business Analytics
- BI, analytics and performance management software sees growth in 2011
  
  Gartner’s 2011 revenue estimates indicate the worldwide BI, analytics and performance management software market experienced another strong year, with figures that look remarkably similar to 2010.
- Tyagi: 'Big data' technology a solution in search of right problems
  
  Not every data problem requires "big data" technology, says consultant Vineet Tyagi. In a video Q&A, he discusses good uses for big data tools and offers tips on managing a big data project.
- IT bottlenecks drive data visualization tool purchases
  
  Allstate, Autodesk, MGM Resorts and Great Western Bank share the secrets to data visualization tools’ success.
CRM
- Mohegan Sun bets big on Infor CRM across sales, service and marketing
  
  Mohegan Sun's new CRM software platform aims to connect with customers, reduce agent churn and overhaul the sales force.
- Salesforce opens new channels with Chatter
  
  Denis Pombriant sees Salesforce.com's new screen sharing and instant messaging features as long-overdue changes to front office collaboration.
- New call center certification targets social media
  
  CIAC certification now includes testing on the use of social media in call centers.
Content Management
- Easier collaboration drives need for scalable document management strategy
  
  Collaboration, audit and compliance are among the business drivers of scalable document management initiatives even as it becomes easier to engage with content being amassed in growing repositories.
- No effective information governance without change management, expert says
  
  Successful information governance involves a combination of smart processes and the appropriate corporate culture, says consultant Carol Stainbrook.
- Trash the old data: A firm record retention schedule can lead to DM success
  
  Information is growing exponentially and the lack of firm record retention schedules is costing organizations big money and will increase liability as time passes, says consultant Randolph Kahn.
Financial Applications
- Cloud-based dynamic discounting fuels small tech supplier’s growth
  
  One small tech company uses Ariba Network to give cash-rich Fortune 500 customers discounts for early payment of electronic invoices.
- SaaS HR, mobile analytics upends workforce management software market
  
  Nucleus Research names Ceridian, ADP among top performers and finds threats to legacy leader Kronos.
- Basic planning, data cleansing seen as crucial to HR system integration
  
  Save time and money by establishing human resources processes and scrubbing data before embarking on a project to integrate systems, industry watchers say.

All Rights Reserved, Copyright 2000 - 2012, TechTarget