fragmented sysauth$ table
From: Willy Klotz <willyk_at_kbi-gmbh.de>
Date: Wed, 28 Apr 2021 10:24:36 +0200
Message-ID: <!&!AAAAAAAAAAAYAAAAAAAAAJxRhRLvfEhBnlOLJd92a2XCgAAAEAAAAMySQHDPo19ImOKPJlpK8owBAAAAAA==_at_kbi-gmbh.de>
Hi all,
Date: Wed, 28 Apr 2021 10:24:36 +0200
Message-ID: <!&!AAAAAAAAAAAYAAAAAAAAAJxRhRLvfEhBnlOLJd92a2XCgAAAEAAAAMySQHDPo19ImOKPJlpK8owBAAAAAA==_at_kbi-gmbh.de>
Hi all,
we are on Oracle 19.8. customer has several large databases, with several tens of thousands users and a number of roles.
We are experiencing slow "set role" (15 seconds and up), and we see some "select . from sysauth$" in top10 SQL of the AWR Reports . I can see that sys.sysauth$ is fragmented, 40% wasted space in there.
Is there a way to compact this table? Alter table move or similar do not work on it.
Thank you and best regards
Willy
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 28 2021 - 10:24:36 CEST