Query to get current executing statement in Oracle concurrent program

Use below query to get the current executing statement in Oracle Apps concurrent programs. SELECT va.sql_text ,va.module FROM APPS.fnd_concurrent_requests fcr ,V$SESSION vs ,V$SQLAREA va WHERE fcr.oracle_session_id = vs.audsid AND vs.sql_hash_value = va.hash_value AND fcr.request_id = <request_id>; Table Information fnd_concurrent_requests:- This table holds the history of all submitted program in Oracle Apps like request id, request …

Query to get current executing statement in Oracle concurrent program Read More »

XAMPP Control Panel – Manage/Configure Apache, MySQL, FileZilla, Tomcat, Mercury

This article explains how to use the XAMPP control panel to start/stop, administer/ configure services like Apache, MYSQL, FileZilla, Mercury, Tomcat with just a click of a button. Before moving further, let’s discuss XAMPP in Brief. XAMPP XAMPP is free and easy to install Apache distribution. It acronyms to Cross-Platform (X), Apache (A), MariaDB (M), PHP …

XAMPP Control Panel – Manage/Configure Apache, MySQL, FileZilla, Tomcat, Mercury Read More »

what is ^m Character

What is ^m character and how to find and remove it from Unix/Linux text file?

Control M or Ctrl-M or ^M character whatever you call them creates the problem when present in Unix or Linux text files. The presence of these characters may lead to unexpected results or interrupt the working of shell script, configuration files, etc. Unix /Linux is the most widely used operating system for server and database …

What is ^m character and how to find and remove it from Unix/Linux text file? Read More »