摘要:
test=# select * from pg_available_extensions where name like '%prewarm%' order by name; name | default_version | installed_version | comment + + + sys 阅读全文
摘要:
select s.sess_id,s.SQL_TEXT,s.RUN_STATUS from v$sessions s , v$lock l where l.tid=s.trx_Id and l.blocked=1; SP_CLOSE_SESSION(SESS_ID)来关闭对应的会话 select ' 阅读全文
摘要:
CREATE PROCEDURE [dbo].[sp_who_lock] AS BEGIN DECLARE @spid INT , @bl INT , @intTransactionCountOnEntry INT , @intRowcount INT , @intCountProperties I 阅读全文