The tablespace map uses a simplified fragmentation formula. The key points in question: What is the 'sum of the blocks for that segment'? SELECT sum(blocks)
FROM dba_extents
WHERE tablespace_nam...
Hi,This article will discuss some PL/SQL performance tuning tips as well as make reference to a variety of good coding practices. There are several things you can do to get your PL/SQL code to run op...
One of the challenges that a DBA team encounters is keeping all of the DBAs up-to-date on connection changes. When a new database is created or an existing database has been changed, the DBAs need to ...
