Peter`s DBA Blog

Erfahrungen eines Oracle DBA`s

Menü

Zum Inhalt springen
  • Startseite
  • Links
  • Oracle Engineered Systems
  • Usefull things
  • About
  • Contact

Schlagwort-Archive: NOLOGGING

Boost your Database Performance with SecureFiles

Introduction Today i want show you a comparison between Securefiles and Basicfiles. I know that there are some other sites out there which are showing how fast Securefiles can be, but in my Tests i will also try to show some more facts and benefits about the NOLOGGING Option which i have described in a…

Februar 11, 2014 in Database, Move Data, Performance.

NOLOGGING What it is (and what it is not)

Whenever a insert or bulk load operations are performed on a database, also redo and undo blocks are created. Through the NOLOGGING option less redo blocks are written by the corresponding operation. When are NOLOGGING operations useful: To improve the performance of large insert operations To improve the build times of large indexes To improve…

Januar 26, 2014 in Database, High availability, Move Data, Performance.

Aktuelle Beiträge

  • 12.2 New Feature: Automatically Synchronize Password Files in Oracle Data Guard
  • 12.2 New Feature: SQL*Plus History
  • Critical Patch Update for July 2016 Now Available
  • Remember there is more than one preupgrd.sql
  • Oracle Standard Edition is dead, Long life Oracle Standard Edition 2 (SE2)

Archive

  • März 2017
  • Juli 2016
  • Dezember 2015
  • Juli 2015
  • Juni 2015
  • Dezember 2014
  • August 2014
  • Juni 2014
  • Mai 2014
  • Februar 2014
  • Januar 2014
  • Dezember 2013
  • November 2013
  • Oktober 2013
  • September 2013
  • August 2013
  • Juli 2013
  • Juni 2013
  • Mai 2013
  • April 2013
  • März 2013
  • Februar 2013
  • Januar 2013
  • Dezember 2012
  • November 2012
  • Oktober 2012
  • September 2012
  • August 2012
  • Juli 2012
  • Mai 2012
  • April 2012

3.2.6 11.2.0.4.1 12.1.0.1 12.1.0.2 12c 12c Database 12c new feature 512Bit 6880880 14851480 16056266 17478514 active ASM cdb cellcli cloud cloud control control create database database database 12c dataguard DEGREE dgrml enterprise manager error Exadata export imp import install Internet Explorer KB 2661254 license lizenz Login MOS My Oracle Support new feature News NOLOGGING NO_PARALLEL oda ORA-00600 ORA-12953 Oracle oracle.sysman.eml.maxInactiveTime oracle database appliance Oracle diagnostic pack Oracle VM Server Oracle XE oratop Patch 2.5 patchset pdb Performance perfstat psu rman SecureFiles Security Warning session timeout size limit snap snapshot standby database sql baseline sql developer 4.0 standard edition standby statspack Troubleshooting Tool tuning pack update upgrade

Kategorien

  • 12c database
  • Allgemein
  • Apex
  • ASM
  • Cloud Control
  • Database
  • Database Firewall
  • Database replay
  • Enterprise
  • Error Codes
  • Exadata
  • FMW
  • High availability
  • Installation
  • JAVA
  • Konfiguration
  • Lizenzierung
  • Move Data
  • Multitenant
  • OBIEE
  • OEL
  • Oracle Database Appliance
  • Oracle Net
  • Oracle Virtual Compute Appliance
  • Oracle VM
  • Oracle VM Server
  • Performance
  • RMAN
  • Security
  • SQL PL/SQL
  • Total Recall
  • Uncategorized
  • Webforms
  • Weblogic
  • Zertifizierung

Meta

  • Registrieren
  • Anmelden
  • Feed der Einträge
  • Kommentare-Feed
  • WordPress.com
Bloggen auf WordPress.com.
Abbrechen
Datenschutz & Cookies: Diese Website verwendet Cookies. Wenn du die Website weiterhin nutzt, stimmst du der Verwendung von Cookies zu.
Weitere Informationen, beispielsweise zur Kontrolle von Cookies, findest du hier: Cookie-Richtlinie