joviano silva – DBA Oracle

  • Install tfactl in non RAC environment

    Tfactl has many advantages, and also support oracle uses this tool to troubleshoot and identify performance issues and to collect all database system wide errors. This tool is preinstalled for RAC To check if tfactl is installed and check the tfa home If it would give a output such as… Listen ⇢

  • enq: WL – contention

    I received a complaint about a database slowdown, so I generated an ADDM report, which identified the event ‘enq: WL – contention’ as a contributing factor. The ADDM report: I identified the sessions with this event with the following sql: In my specific case were 30 RMAN concurrent sessions. Find… Listen ⇢

  • Clean Oracle filesystems with tfactl command

    The Best approach to clean Oracle Database Filesystems or automate scripts. Use the tfactl purge command to delete diagnostic collections from the TFA repository that are older than a specific time. Usually tfactl are in the grid user within the following path: /u01/app/18.1.0.0/grid/tfa/tls/tfa_home/bin/tfactl tfactl managelogsUse the tfactl managelogs  command to manage Automatic Diagnostic Repository… Listen ⇢

    Clean Oracle filesystems with tfactl command

Meet the Blog Host, Joviano Silva.

Subscribe Now