Oracle Securefile Lobs
From: Sanjay Mishra <"Sanjay>
Date: Mon, 24 Feb 2020 22:18:54 +0000 (UTC)
Message-ID: <410366466.1059264.1582582734562_at_mail.yahoo.com>
Date: Mon, 24 Feb 2020 22:18:54 +0000 (UTC)
Message-ID: <410366466.1059264.1582582734562_at_mail.yahoo.com>
I had one application that stores lots of transactional data in LOB and the same is updated heavily. Does frequent update on LOB1. Impact system performance heavily2. Can cause lots of Fragmentation3. Need any frequent maintenance as part of optimization The database is 18c and LOBS are secure files and Partitioned. TIASanjay
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Feb 24 2020 - 23:18:54 CET