30 somehow rings a bell, but I don't remember what it exactly was.
Probably the maximum recommended number of active sessions. But this
shouldn't be a hard limit.What's the result of this query in your
system?SELECT * FROM sys.EXA_METADATA emWHERE PA...
Not sure what you're trying to achieve or why 30 is your limit. Maybe
you can elaborate?Have you read the article about Session Management?
TO_NUMBER offers some more functionality to make it a bit more
comfortable regarding the comma/dot:WITH q(income) AS (SELECT '3.600,00
€'UNION ALLSELECT '-9.500,00 €')SELECT to_number(REPLACE(income, '€',
''), '999G999D99') AS income_numericFROM q;Bu...
You could also use DBeaver which provides exactly the function you're
looking for (sorry, most of it is in German but I think it's
self-explanatory; the tool itself also supports English):To get this
overview DBeaver fires this SQL to the database wh...
Is this a dev environment? If so you could enable profiling for the
whole system to see all queries in exa_dba_profile_last_day.ALTER SYSTEM
SET PROFILE = 'ON'If this is a production environment I'd be a bit more
careful and have a closer look if ena...