New answers tagged

0

Thank you for responding, I never needed to change any parameter of PostGre server or PgAdmin. So, I don't know them well. I'm not sure about my PgAdmin version, the 'About' form say 1.20 (?!) My client_min_messages is like you and my code doesn' modify it. The result in the messages panel is a little different than you, like that : NOTICE: Function 1 ...


0

Yes it is possible. I have tested the following with PG 12.2 and with psql CLI: show client_min_messages; client_min_messages --------------------- notice (1 row) create or replace function f2 () returns text as $$ declare begin raise notice 'Function 2 is now running'; return 'f2: OK'; end; $$ language plpgsql; CREATE FUNCTION create or replace ...


0

Since you are on 12.2 you can query the alert log directly from SQL using the view V$DIAG_ALERT_EXT. If you need access to any of the trace files generated they are available using views as well, see V$DIAG_TRACE_FILE and V$DIAG_TRACE_FILE_CONTENTS.


1

Try to check if statspack is installed (any user name PERFSTAT in the database ?) and if yes if it configured (look for DBMS_JOB in view DBA_JOBS running something like statspack.snap). If yes you could retrieve last week-end activity with script @?/rdbms/admin/spreport. Statspack does not require Tuning Pack or Diagnostic Pack licences but you should ...


1

someone has access to the alert log. Try to get access. Maybe they can send it to you. Do you have full rights on that database? If so try to figure out what directory has the alert log. For example "show parameter diag" Take that directory add the following %DIAG%\rdbms\\\trace and create a directory object for that path. Then create a database directory ...


1

You can inspect V$SQL for statements that don't use binds, eg. select substr(sql_text,1,80), count(*) from v$sql group by substr(sql_text,1,80) order by count(*) desc Then inspect the full text of the statements that come on top, see where they differ.


Top 50 recent answers are included