SAP transaction log trace

Use this tip if you want to view the users activity using sql command.

Aminul Haque

Published: 18 Feb 2004

If you want to view user activity using sql command then follow the steps below:

1. Tcode ST05
2. Click Trace on
3. Run transaction
4. Click Trace off
5. E:usrsapPRDDVEBMGS00logTRACE000.LOG
6. You can find the sql statement

Dig Deeper on SAP Basis

Extracting data from memory dumps with Event Tracing for Windows Admins facing Windows Server frequent hangs and crashes can use a number of tools, like Event Tracing for Windows, to catch a badly behaving task.

Bedeviled by SQL Server lock escalation? Trace flags can help SQL Server lock escalation can save on memory when working with a table strewn with locks, but it also can lead to blocking. Use SQL Server trace flags to disable lock escalation.

Parallel processing: Using parallel SQL effectively Using parallel processing only makes sense for your customers in specific situations. Find out when to use parallel SQL with the Oracle databse to avoid excessive usage.

Using Microsoft Upgrade Advisor for SQL Server 2008 R2 A solution provider can use the Microsoft Upgrade Advisor to analyze SQL Server and highlight issues that may arise during a SQL Server 2008 R2 upgrade.

SQL Profiler: A network trace for SQL Server SQL Server newbies should be sure to take advantage of Microsoft's SQL Profiler tool, which can be used as sort of a network monitor for the database.

Tracking data changes on IBM i with triggers Triggers can be implemented on the AS/400 using a high-level language or SQL and can be used to enforce business rules or validating input data. Learn how to use DB2 triggers as a means of auditing data inserts, deletes or changes.

SearchERP

CRM vs. ERP: Understand differences and CRM choices

As vendors' offerings of ERP suites and CRM standalone modules get more complex, it can be helpful to learn -- or review -- the ...

With Scout, Workday acquisition strategy takes shape

Workday's planned acquisition of Scout RFP, a sourcing and procurement platform, says one thing to analysts: It is pushing to ...

10 ERP software choices for process manufacturing

Selecting ERP software for process manufacturing can be confusing, and different industries have different requirements. Learn ...

SearchOracle

Oracle Autonomous Database shifts IT focus to strategic planning

This handbook looks at what Oracle Autonomous Database offers to Oracle users and issues that organizations should consider ...

Oracle Autonomous Database features free DBAs from routine tasks

Oracle Autonomous Database can automate routine administrative and operational tasks for DBAs and improve productivity, but ...

Oracle co-CEO Mark Hurd dead at 62, succession plan looms

Oracle co-CEO Mark Hurd's abrupt death at 62 has put the software giant in the position of naming his replacement, and the ...

SearchDataManagement

How AI could save the enterprise data catalog

Enterprise data catalogs record all the databases and files in a corporation, but sometimes it can become out of date. Advances ...

With Vitess 4.0, database vendor matures cloud-native platform

Scaling a MySQL database in the cloud is not easy, but the open source Vitess project manages the project at scale for ...

Managing unstructured data is crucial to enterprises' AI goals

Unstructured data makes up a huge portion of most businesses' data volume. But, with data-hungry AI systems coming online, making...

SearchAWS

AWS SysOps certification exam guide outlines admin responsibility

In this book excerpt from "AWS Certified SysOps Administrator Associate All-in-One Exam Guide," review the best practices for OS ...

AWS data lake and data warehouse options for the cloud

Get ready for data analytics in the cloud. Learn the best ways to handle your data on AWS. Distinguish between data lakes and ...

AWS should address these key challenges at re:Invent 2019

AWS has flooded its catalog with services but enterprises still struggle with the gaps that remain. Find out which pain points ...

SearchBusinessAnalytics

Salesforce acquisition of Tableau finally getting real

With Salesforce and Tableau finally free to start integrating, Andrew Beers, Tableau's chief technology officer, talks about what...

Tableau analytics platform upgrades driven by user needs

In a Q&A, Tableau chief technology officer Andrew Beers talks about the driving factors behind recent product upgrades centered ...

Tableau or Qlik: What separates the data visualization tools?

While leading data visualization vendors Tableau and Qlik may seem similar, there are substantial differences. Understanding the ...

SearchContentManagement

Acquia cloud CMS on AWS, Vista cash flow raise user expectations

Acquia's new venture backing and customer experience cloud apps precipitate a need for easier integrations and setup for future ...

Adobe Sign introduces updates targeting mobile device users

The updates include a new home screen and a page for users to track the signing process, the ability to zoom and navigation ...

Acquia, Drupal founder Dries Buytaert on open source, Vista, CDPs

Acquia and Drupal founder Dries Buytaert discusses his company's move into marketing automation, CDPs and what's next after Vista...

SearchHRSoftware

Discover the key elements of talent management systems

Discover the four components of talent management systems: recruiting, performance management, corporate learning and ...

Kronos introduces its latest time clock, Kronos InTouch DX

The newly launched time clock integrates with Workforce Dimensions, Kronos' workforce management suite, providing real-time ...

HRIS department an essential bridge between HR, IT

Emerson Electric's VP of HRIS explains why it's important to have a team that can translate HR needs into the black and white of ...

SAP transaction log trace

Use this tip if you want to view the users activity using sql command.

Dig Deeper on SAP Basis

Start the conversation

0 comments

Please create a username to comment.

-ADS BY GOOGLE

SearchERP

CRM vs. ERP: Understand differences and CRM choices

With Scout, Workday acquisition strategy takes shape

10 ERP software choices for process manufacturing

SearchOracle

Oracle Autonomous Database shifts IT focus to strategic planning

Oracle Autonomous Database features free DBAs from routine tasks

Oracle co-CEO Mark Hurd dead at 62, succession plan looms

SearchDataManagement

How AI could save the enterprise data catalog

With Vitess 4.0, database vendor matures cloud-native platform

Managing unstructured data is crucial to enterprises' AI goals

SearchAWS

AWS SysOps certification exam guide outlines admin responsibility

AWS data lake and data warehouse options for the cloud

AWS should address these key challenges at re:Invent 2019

SearchBusinessAnalytics

Salesforce acquisition of Tableau finally getting real

Tableau analytics platform upgrades driven by user needs

Tableau or Qlik: What separates the data visualization tools?

SearchContentManagement

Acquia cloud CMS on AWS, Vista cash flow raise user expectations

Adobe Sign introduces updates targeting mobile device users

Acquia, Drupal founder Dries Buytaert on open source, Vista, CDPs

SearchHRSoftware

Discover the key elements of talent management systems

Kronos introduces its latest time clock, Kronos InTouch DX

HRIS department an essential bridge between HR, IT

Dig Deeper on SAP Basis

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.