recursive SQL — oracle-tech

    Forum Stats

  • 3,701,023 Users
  • 2,239,262 Discussions
  • 7,834,978 Comments

Discussions

recursive SQL

kaericnkaericn Posts: 305 Blue Ribbon
edited October 15 in SQL & PL/SQL

We have got a critical oracle error and that's what the DBA tells us

Looks like this was a recursive SQL from Sql developer session which was unable to parse and LGWR was stuck on this .

Can someone explain how this can happen ?


SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type 

FROM sys.all_tab_cols 

WHERE hidden_column = 'NO' and rownum <=50 and owner = :1 and table_name = :2 and column_name like :3 union all 

SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type 

FROM sys.all_tab_cols 

WHERE hidden_column = 'NO' and rownum <=50 and owner = :4 and table_name = :5 and column_name like :6 union all 

SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type 

FROM sys.all_tab_cols 

WHERE hidden_column = 'NO' and rownum <=50 and owner = :7 and table_name = :8 and column_name like :9 union all 

SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type 

FROM sys.all_tab_cols 

WHERE hidden_column = 'NO' and rownum <=50 and owner = :10 and table_name = :11 and column_name like :12 union all 

SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type 

FROM sys.all_tab_cols 

WHERE hidden_column = 'NO' and rownum <=50 and owner = :13 and table_name = :14 and column_name like :15 union all 

SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type 

FROM sys.all_tab_cols 

WHERE hidden_column = 'NO' and rownum <=50 and owner = :16 and table_name = :17 and column_name like :18 union all 

SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type 

FROM sys.all_tab_cols 

WHERE hidden_column = 'NO' and rownum <=50 and owner = :19 and table_name = :20 and column_name like :21 union all 

SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type 

FROM sys.all_tab_cols 

WHERE hidden_column = 'NO' and rownum <=50 and owner = :22 and table_name = :23 and column_name like :24 union all 

SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type 

FROM sys.all_tab_cols 

WHERE hidden_column = 'NO' and rownum <=50 and owner = :25 and table_name = :26 and column_name like :27 union all 

SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type 

FROM sys.all_tab_cols 

WHERE hidden_column = 'NO' and rownum <=50 and owner = :28 and table_name = :29 and column_name like :30 union all 

SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type

Sign In or Register to comment.