SQL Performance (MOSC)

MOSC Banner

Linux DB 19.19 ORA-12850 raised in sqlid

in SQL Performance (MOSC) 42 commentsAnswered ✓

Oracle Enterprise Linux 7.9

Oracle Database Enterprise Edition 19.19 Apr/18/2023

alert_mcs1.log has repeated occurrences of ORA-12850

ORA-12850 raised in sqlid=9s8vy5xp8uvkt

-----

--sqlid=9s8vy5xp8uvkt -- PDB: AUX@MARDEV1

SELECT sum(priv),layer_id FROM

(SELECT DISTINCT a.owner,a.table_name,sum(decode(privilege,'SELECT',1, 'INSERT',2,'UPDATE',4,'DELETE',8,NULL)) priv,l.layer_id

FROM (SELECT DISTINCT owner,table_name,privilege

FROM all_tab_privs_recd) a,SDE.LAYERS l WHERE a.owner = REPLACE (l.owner,'"')

AND a.table_name = l.table_name AND a.privilege IN ('SELECT','UPDATE','INSERT','DELETE')

GROUP BY (a.owner,a.table_name,l.layer_id)) GROUP BY owner,table_name,priv,layer_id ORDER BY layer_id

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center