Search notes:

Oracle adminstration

Predefined automated maintenance tasks

Oracle has some predefined automated maintenance tasks:

Automatic Optimizer Statistics Collection
Optimizer Statistics Advisor
Automatic Segment Advisor
Automatic SQL Tuning Advisor
SQL Plan Management (SPM) Evolve Advisor

Database Installation

Installing an Oracle Database roughly consists of three steps:

Create a new Oracle Home directory
Extract an image file (zip) to that directory
Run the setup wizard ($ORACLE_HOME/setup[.exe] or $ORACLE_HOME/runInstaller)

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1758206518, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/adminstration/index(67): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78