Programmer Think

Environment-related: OS: CentOS release 5.11 IP: 192.168.77.10 MEM: 16G DISK: 50G 1. Brief description This blog post is actually a silent installation of the CentOS 5 system Oracle 10g in the production environment in use. This blog includes oracle Software silent installation, software upgrade, playing PSU, man ...

[TOC] 1. Steps to generate AWE reports For SQL tuning, local SQL, we can use direct tuning such as execution plan, for the whole system?Oracle provides several performance analysis reports, such as AWR, ASH, ADDM and so on. This blog focuses on AWR AWR, fully known as Automatic Workload Repository, is a performance collection and a ...

MySQL MySQL introduction MySQL was originally an open source relational database management system developed by Swedish company MySQL AB, which was acquired by Sun Microsystems in 2008. In 2009, Oracle acquired Sunrise Microsystems, and MySQL became Oracle's product. MySQL has become the most popular open source database in the past because of ...

At ORACLE10g and 11g versions, the default log archive path for ORACLE is the flash-back recovery area ($ORACLE_BASE/flash_recovery_area).ORACLE has a limitation on this path: it only has 2G of space by default, and it is not only the default path for archive logs, but also the default address for backup files and flash back lo ...