Kategorien
- Java (1)
- Linux (9)
- Installation (2)
- Dokumentation (1)
- Anaconda (1)
- Screenshots (1)
- OEL 7.2 (1)
- Dokumentation (1)
- Konfiguration (2)
- OEL 7.2 (1)
- ASM Disks (1)
- OS (1)
- udev rules for ASM Disks (1)
- OEL 7.2 (1)
- RPi (3)
- DHCP – Service (2)
- DNS – Service (2)
- Firewall (1)
- Hardening (1)
- Installation (1)
- iptables (1)
- Konfiguration (2)
- Router (2)
- Virtual Box (4)
- Installation (1)
- OEL 7.2 (1)
- Konfiguration (1)
- Netzwerk Konfiguration (1)
- VBox network (1)
- VM klonen (1)
- Installation (1)
- vituelles Netzwerkinterface (1)
- YUM Repository (1)
- Installation (2)
- Oracle (36)
- 11g (2)
- AUTHID (1)
- Definer Rights (1)
- Invoker Rights (1)
- Partitioning (1)
- 12c (8)
- Caching (1)
- Compression (1)
- gather_table_stats (1)
- Partitioning (1)
- RAC (2)
- Upgrade (1)
- Performance Issues (1)
- Wrong Results (1)
- Upgrade to (1)
- 12cR2 – 12.2 (1)
- ALERT.LOG (2)
- LISTENER (1)
- EXTPROC (1)
- ORA-28575 (1)
- relink all (1)
- TNS-12518 (1)
- ORA-28575 (1)
- EXTPROC (1)
- Lizenzierung (1)
- 12.1.0.2 (1)
- SE2 (1)
- Standard Edition 2 (1)
- 12.1.0.2 (1)
- LONG (2)
- CLOB Konvertierung (1)
- LOB Konvertierung (1)
- XMLGEN (1)
- LONG RAW (1)
- Materialized Views (1)
- ORA-12162 (1)
- ORA-7445 (1)
- ORA-997 (1)
- Oracle VM (2)
- PL/SQL (1)
- PSU (1)
- RAC (1)
- rebuild table (1)
- RMAN (1)
- ORA-02291 (1)
- RMAN.RLH_F1 (1)
- ORA-02291 (1)
- SQL (4)
- AWR (3)
- AAS (1)
- DB Time (2)
- DBA_HIST-Views (3)
- SQL RunTime (1)
- SQL Time (3)
- sys.x$dbgalertext (1)
- TABLE(GV$(CURSOR (1)
- View (1)
- WITH – Clause (3)
- AWR (3)
- sql*plus (1)
- New Features (1)
- Tuning (4)
- 11g (1)
- Gather Statistics (1)
- Indizierung (1)
- SQL Plan Baseline (1)
- XML (1)
- 11g (2)
Feedback of Modern Consolidated Database Environment
keine Kommentarevia Feedback of Modern Consolidated Database EnvironmentLesen Sie weiter »RMAN on Multitenant DB – Awareness of the Backup Optimization Behavior
keine Kommentarevia RMAN on Multitenant DB – Awareness of the Backup Optimization BehaviorLesen Sie weiter »Summary of new partitioning Features in 12.2
keine KommentareWhile looking for some new features of 12.2 concerning the partitioning e.g the auto listLesen Sie weiter »Using Join Elimination to increase performance on Views
keine KommentareA customer having a DWH has a View with a huge number of Left Outer Joins to a dim table. The Reports using this view will only using a small number of columns of some dim tables. But theLesen Sie weiter »Howto setup and using incremental gather_table_stats
ein KommentarMy friend Bernhard explains to me his issue using incremental gather_table_stats on a large partitioned table in a DWH. This table has only changes on a few partitions per day, normally the last two. I was looking for a solution …Lesen Sie weiter »Droping a Table Column will generate a Hidden Column instead of removing them
keine KommentareThis week a colleaque asked me for help while droping a table column. Inside of a PL/SQL procedure a table column has to be droped to prepare the table for an partition exchange. But while execute the partition exchange theLesen Sie weiter »Avoid mistakes when Gathering System Stats
ein KommentarChristian Antognini descibed in his book Troubleshooting Oracle Performance how to gather the system statistics in a very proficient way. The main idea of gathering system stats is to collect the system stats inLesen Sie weiter »Oracle RAC 12cR1 on OEL 7.2 VBox – Part 4: Install the GI software only
keine KommentareAs described in my previous article Cloning the Node two a 2-Node-RAC we can start to install the GI software on both nodes. Normally you can install and configure the Grid Infrastructure (GI) Software on both nodes, starting on one …Lesen Sie weiter »Oracle RAC 12cR1 on OEL 7.2 VBox – Part 3: Cloning the Node two a 2-Node-RAC
keine KommentareIn my previous article Adding ASM Disks and Configuration of OS I described to add some ASM Disks and to configure the Oracle Enterprise Linux (OEL) 7.2 to be ready for Oracle RAC 12c. In this article I will describe …Lesen Sie weiter »Oracle RAC 12cR1 on OEL 7.2 VBox – Part 2: Adding ASM Disks and Configiguration of OS
keine KommentareIn addition to my first article Installation of OEL 7.2 I will show you how to add some ASM Disks and to configure the Oracle Enterprise Linux (OEL) 7.2 to be ready for oracle RAC 12c on OEL 7.2Lesen Sie weiter »