22 lines
550 B
SQL
22 lines
550 B
SQL
-- Copyright 2018 Tanel Poder. All rights reserved. More info at http://tanelpoder.com
|
|
-- Licensed under the Apache License, Version 2.0. See LICENSE.txt for terms & conditions.
|
|
|
|
COL process_name_ksbtabact HEAD PROCESS_NAME FOR A20
|
|
|
|
-- similar to X$MESSAGES
|
|
|
|
SELECT
|
|
indx
|
|
, process_name_ksbtabact
|
|
, action_description_ksbtabact
|
|
, timeout_ksbtabact
|
|
, options_ksbtabact
|
|
FROM
|
|
X$KSBTABACT
|
|
WHERE
|
|
LOWER(ACTION_DESCRIPTION_KSBTABACT) LIKE LOWER('%&1%')
|
|
OR LOWER(PROCESS_NAME_KSBTABACT) LIKE LOWER('%&1%')
|
|
/
|
|
|
|
|