This can be really useful in place of database tracing, especially when you want to see the action the *application* takes, and not just what it does in the database.<\/p>\n
\r\n[user@************** common]# tcpdump -A -nn port 1521 | \\\r\n> awk '{if (tolower($0) ~ \"select\" || tolower($0) ~ \"update\") {p=1;print} \\\r\n> else if(p == 1 && $0 !~ \"^[0-9][0-9]:\") {print} \\\r\n> else if ($0 ~ \"^[0-9][0-9]:\") {p=0}}'\r\ntcpdump: verbose output suppressed, use -v or -vv for full protocol decode\r\nlistening on eth1, link-type EN10MB (Ethernet), capture size 65535 bytes\r\n.......................SELECT t1.config_path,t1.content_id\r\n FROM srch_config t1\r\n WHERE ((t1.uniq_server_id IS NULL)\r\n OR (:1 = t1.uniq_server_id)).................... .......i....__NULL__\r\n.......................SELECT t1.config_path,t1.content_id\r\n FROM srch_config t1\r\n WHERE ((t1.uniq_server_id IS NULL)\r\n OR (:1 = t1.uniq_server_id)).................... .......i....__NULL__\r\n.......................SELECT t1.config_path,t1.content_id\r\n FROM srch_config t1\r\n WHERE (NOT ((t1.uniq_server_id IS NULL))\r\n AND NOT ((:1 = t1.uniq_server_id))).................... .......i....__NULL__\r\n.......................SELECT t1.config_path,t1.content_id,t1.generation,t1.claimed_generation,t1.nxt_inc_generation,t1.uniq_server_id,t1.last_activity,t1.last_full_index,t1.last_incr_index\r\n FROM srch_config t1\r\n WHERE ((t1.config_path = :1 AND t1.content_id = :2 ))............................i...............i...-\/atg\/userprofiling\/search\/ProfileOutputConfig.DEFAULT\r\n.......................SELECT t1.config_path,t1.content_id\r\n FROM srch_config t1\r\n WHERE ((t1.uniq_server_id IS NULL)\r\n OR (:1 = t1.uniq_server_id)).................... .......i....__NULL__\r\n.......................SELECT t1.config_path,t1.content_id\r\n FROM srch_config t1\r\n WHERE ((t1.uniq_server_id IS NULL)\r\n OR (:1 = t1.uniq_server_id)).................... .......i....__NULL__\r\n.......................SELECT t1.config_path,t1.content_id\r\n FROM srch_config t1\r\n WHERE ((t1.uniq_server_id IS NULL)\r\n OR (:1 = t1.uniq_server_id)).................... .......i....__NULL__\r\n.......................SELECT t1.config_path,t1.content_id\r\n FROM srch_config t1\r\n WHERE ((t1.uniq_server_id IS NULL)\r\n OR (:1 = t1.uniq_server_id)).................... .......i....__NULL__\r\n...........................UPDATE dms_queue_entry SET handling_client_id = :1 , read_state = :2 WHERE handling_client_id < 0 AND delivery_date < :3 AND queue_id IN (SELECT qr.queue_id FROM dms_queue_recv qr WHERE qr.client_id = :4 ) ...........................i..............i..............i..............i.....^)............$.\\.+..^)..\r\n...........................UPDATE dms_topic_entry SET read_state = :1 WHERE delivery_date < :2 AND read_state = 0 AND subscriber_id IN (SELECT ts.subscriber_id FROM dms_topic_sub ts WHERE ts.client_id = :3 AND ts.active = 1) ...........................i..............i..............i.............$.\\.+...^)..\r\n.......................SELECT t1.config_path,t1.content_id\r\n FROM srch_config t1\r\n WHERE ((t1.uniq_server_id IS NULL)\r\n OR (:1 = t1.uniq_server_id)).................... .......i....__NULL__\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"This can be really useful in place of database tracing, especially when you want to see the action the *application* takes, and not just what it does in the database. [user@************** common]# tcpdump -A -nn port 1521 | \\ >…<\/p>\n