Peter`s DBA Blog

Erfahrungen eines Oracle DBA`s

Menü

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

SQL PL/SQL

12.2 New Feature: SQL*Plus History

Oracle 12.2 is finally released on premise and for that reason I would like to share some of my experiences with testing the new Features. First I would like to write about a small new feature, which would be very useful for all DBAs. Now SQL*Plus can keep history of the commands executed, and let you see…

März 5, 2017 in 12c database, SQL PL/SQL, Uncategorized.

SQL*Plus error logging – A forgotten feature

Some days ago a customer show me a script where he did intensive PL/SQL Code for logging errors during exection. This additional code was responsible for same Performance Problems during the script execution. After same code Review i find out that there was a much easier way the same Debugging without the Overhead. You can…

Juni 16, 2015 in Error Codes, Performance, SQL PL/SQL, Uncategorized.

Oracle SQL Developer & Data Modeler update v4.0.2 Available

Oracle released two new updates for  Oracle SQL Developer and the Oracle SQL Developer Data Modeler. The list of bugs fixed for the SQL Developer can be found here. Also a complete list for fixed bugs in the SQL Developer Data Modeler can be found on the OTN Page here. You should install a JDK…

Mai 6, 2014 in Installation, SQL PL/SQL.

12c New Feature: Histogram Enhancements

Today i want to explain the new Histograms Enhancements in 12c. But first i want to explain some basic about basic about histograms, because i know that they are not well known by some DBA`s.The Optimizer normaly thinks that the data in a column is uniformly distributed. A example of this is a primary key column…

Januar 22, 2014 in 12c database, Database, Performance, SQL PL/SQL.

DDL Logging and licensing?

12c introduce a New Feature which allows the DBA to log all data definition language (DDL) statements to a DDL alert log. I think that this is a usefull feature, for example you can audit a update from your software vendor to see what is happen on your database. But be carefull, this parameter needs…

November 15, 2013 in 12c database, Database, Error Codes, Lizenzierung, SQL PL/SQL.

12c New Feature: SQL Row-Limiting Clause

Its not realy a new feature because many other database vendors have this feature already but it is new to Oracle 12c. You can now limit the Output of rows in a SQL Query. A small example: Check the employees Table SQL> select count(*) from employees;   COUNT(*) ———-       107 Now we are only…

November 14, 2013 in 12c database, Database, Performance, SQL PL/SQL.

SQL Profiles and SQL Baseline what the optimizer uses

Some weeks ago i posted an article which describes how SQL Baselines effects Adaptive Cursor Sharing (german). In this article i want to show what will happen when you use SQL Profiles while SQL Baselines are active. First let us configure a database to capture and use SQL Baselines. SQL> show parameter baselines NAME      …

September 14, 2013 in Database, Performance, SQL PL/SQL.

Beitragsnavigation

← Ältere Beiträge

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
  • Beitrags-Feed (RSS)
  • Kommentare als RSS
  • WordPress.com
Werbeanzeigen
Erstelle eine kostenlose Website oder Blog – auf WordPress.com.
Peter`s DBA Blog
Erstelle eine kostenlose Website oder Blog – 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