Tag: Oracle.com

SAVE THE DATE: BERLINER EXPERTENSEMINAR MIT MARCO PATZWAHL

Der Kurs erklärt die Methoden um in seiner Oracle Datenbank in Version von 11.2 bis 21.2 aufzuräumen und Objekte zu reorganisieren. Wie kann man unnötigen Speicherplatz durch Statistiken, Jobs Logs, Audits, Trace Dateien u. v. w wieder freigeben? Wie können partitionierte oder normale Tabellen, Indizes, Lobs und Sonderobjekte wie AQ Tabellen, Tabellen mit Long oder der gesamte Tablespace reorganisiert werden?

Zielgruppe:

Fortgeschrittene DBA´s, TeamleiterInnen und interessierte EntwicklerInnen

Vorkenntnisse:

Grundlagen der Datenbank Architektur

Welche Fähigkeiten erlangen die Teilnehmer?

Die Teilnehmer können nach dem Seminar in Ihrer Datenbank aufräumen und unnötigen Speicherplatz wieder freigeben. Auch die Reorganisation von Objekten wie Indizes, Tabellen, Tablespaces und Sonderobjekten ist danach einfach machbar.

Dozent:

Marco Patzwahl, Muniqsoft Training GmbH

Oracle Kenntnisse seit 25 Jahren, Postgres seit 4 Jahren und SQL Server seit 6 Jahren.

Die Anmeldmöglichkeit für Teilnehmer stellen wir asap zur Verfügung!

Wir freuen uns auf Ihre Teilnahme

Ihre DOAG

 

SAVE THE DATE: BERLINER EXPERTENSEMINAR MIT CHRISTIAN PFUNDTNER

Beschreibung Thema:

Dieser Workshop richtet sich speziell an Oracle DBAs, die zusätzlich auch PostgreSQL Datenbanken betreuen sollen. Die Voraussetzung ist ein fundiertes Wissen über die Oracle Datenbanken – von Begriffen wie Tablespace, Schema, Instanz bis hin zu Backup und Recovery. Bei vielen Erklärungen werden Vergleiche mir den entsprechenden Funktionen/Strukuren von Oracle genutzt, was einem Oracle DBA das verstehen deutlich erleichtern sollte.

Zielgruppe:

Der Fokus liegt auf Oracle DBAs.

Architekten und Entwickler mit grundlegenden Oracle-Datenbank-Architektur-Know-How sind ebenfalls willkommen.

Vorkenntnisse:

Grundlegendes Know-How über Oracle-Datenbanken (Architektur, Schema, Security, Administration) sowie Linux.

Welche Fähigkeiten erlangen die Teilnehmer?

Grundlegende Administrationskenntnisse für PostgreSQL 11,12,13 Datenbanken.

Weitere Informationen zu den Inhalten finden Sie hier:

www.dbmasters.at

Dozent:

Christian Pfundtner (OCM, ACE) hält seit Mitte der 1990er Schulungen im Oracle Datenbank Umfeld, wobei der Focus auf High End Schulungen (Performance Tuning, Cluster, HA,…) liegt. Seit knapp 3 Jahren ist er auch im PostgreSQL-Umfeld tägig.

Die Anmeldmöglichkeit für Teilnehmer stellen wir asap zur Verfügung!

Wir freuen uns auf Ihre Teilnahme

Ihre DOAG

DOAG Datenbank Online-Event: PostgreSQL als Resource auf der ODA

Wem kommt das bekannt vor? Die Datenbank läuft auf der neuen ODA und alles ist prima aber auf der ODA ist noch Platz und die CPU-Auslastung ist auch nicht allzu hoch. Und dann kommt die Idee! Man könnte doch, .. ja genau!

Warum bringen wir unsere PostgreSQL Datenbank nicht auf die ODA? Die Datenbank soll nicht von PostgreSQL nach Oracle migriert werden, nein, sie soll nativ auf der ODA als Ressource laufen!

In meinen Vortrag berichte ich über die Installation der PostgreSQL Datenbank auf der ODA und welche Schritte für die Verlagerung erforderlich sind. Eine Betrachtung der rechtlichen Voraussetzungen für die Nutzung der Oracle-Software und Hardware durch PostgreSQL rundet den Vortrag ab.

Referent: Amin Farvardin, MT AG

Co-Referent: Ernst Leber, MT AG

Make it faster – Myths about SQL Performance

Make it faster - Myths about SQL Performance

Many developers don’t pay attention to database performance when implementing new applications. The functionality of the application is important, but the efficiency of the SQL queries is often ignored. The DBA (or the query optimizer) does this job later. If necessary, we can still create some indexes, add hints or adjust some database parameters. And in the Cloud, the Oracle database does everything automatically and autonomously, anyway.

Really? Unfortunately, the reality looks different. Many performance problems are caused by a poor software design, unsuitable data models or inefficient SQL statements. Correcting such issues at the end of a project or when the system is already in operation is often very costly and cannot be fixed with just a few configuration parameters.

With SQL live demos (all based on James Bond characters and movies), multiple-choice questions and some funny stories that happened to me in my job as an Oracle consultant, I will explain why the impact of performance is important in every phase of a software project. You can check yourself what you know about SQL performance tuning and which myths you still believe in.

Oracle 21c: New Features and Enhancements of Data Pump / TTS

Oracle 21c: New Features and Enhancements of Data Pump / TTS

At the end of the year 2020, Oracle released 21c on its Cloud infrastructure. The on-premises version will follow later this year. As with every new Oracle version, the Data Pump utility gets new features or enhancements for existing features.

This presentation gives an overview of the enhancements of Data Pump and Transportable Tablespaces. The following list is an excerpt of the points I will talk about

  • Simultaneous use of EXCLUDE and INCLUDE
  • Parallelized import of metadata during a TTS import operation
  • Checksum support for dump files
  • Direct access to Oracle Cloud Object Store for exports and imports

Oracle Audit Vault and Database Firewall beyond Oracle Database

Oracle Audit Vault and Database Firewall are one of the industry-leading Database and Access monitoring solutions. This session will focus on how Oracle AVDF can integrate with Non-Oracle DB’s using the latest AVDF 20.1 features.
Oracle Audit Vault and Database Firewall (AVDF) is a complete Database Activity Monitoring (DAM) solution that combines native audit data with network-based SQL traffic capture. AVDF includes:

– An enterprise quality audit data warehouse.
– Host-based audit data collection agents.
– Powerful reporting and analysis tools.
– Alert framework.
– Audit dashboard.
– A multi-stage Database Firewall.

Speakers BIO: Suraj Ramesh
Principal Solution Engineer, Oracle

Suraj Ramesh, Principal Solution Engineer, Oracle
Expert Oracle DB Consultant and Solution architect with 15 years of experience handling Production Oracle Databases in Various Domains, including Banking, Telecom, and Insurance. Good Knowledge of ITIL Standards, Tools, and Policies. Certified in Oracle DB Ad.

DB DATA GUARD: CONFIGURATION AND BEST PRACTICES

Join ODTUG and Viscosity for a hands-on virtual class on Oracle Database 19c.

We have a limited number of user IDs available for the hands-on lab, so be sure to register quickly as a “Hands-On Participant” or for the HOL Waiting List.

Registration is unlimited for those interested in View and Listen only mode.

DATA GUARD: BEST PRACTICES and 19c NEW FEATURES

Data Guard Lecture: Learn how you can setup Data Guard with all the best practices. Attendees will receive a brief history of Data Guard and how it became Data Guard. Then, dive directly into new features in Oracle Data Guard 12c Release 2/18c/19c. This workshop will disseminate Data Guard best practices and reference architectures that DBAs need to know to protect their Oracle ecosystem. Viscosity will demonstrate how DBAs should setup, configure, and monitor mission critical Data Guard environments (including Active Data Guard).

 

Session Outline:

– Building the Physical Standby database

– Monitoring the Physical Standby database

– Maintaining the Physical Standby database

– Configuring Data Guard Broker

– Performing Backup and Recovery with RMAN

– Setting Archive Retention

– Switchovers

– Failovers

– Active Data Guard

– Snapshot Standby

Authentication options for the Oracle Database

Authentication options for the Oracle Database

Session Abstract: Oracle Database accepts several different authentication methods – each with its own advantages and disadvantages. Join us to review database authentication, appropriate use cases, and how you can use authentication methods to reduce risk and improve security

Speaker BIO: Russ Lowenthal
Senior Director of Product Management for Database Security, Oracle

Russ Lowenthal is the Senior Director of Product Management for Database Security, focused on database encryption, access control, audit, and monitoring. Russ is based in Orlando, Florida, USA, and has been with Oracle for over twenty years. Leveraging more than thirty years of experience in IT including database, UNIX systems, and network administration, he now advises Oracle’s customers on secure implementations of information systems technology. Russ’ certifications include Certified Information System Security Professional (CISSP), Certified Information Systems Auditor (CISA), Certified Information Systems Manager (CISM), Oracle Certified Master (OCM), Microsoft Certified Systems Engineer (MCSE), and Certified Technical Trainer (CTT).

Registration Link: http://bit.ly/3exvRpy

Running Oracle Database Upgrades on Docker

Organizations planning for an Oracle upgrade should consider Docker in their upgrade strategy. Docker is an ideal environment for evaluating and testing Oracle database features and upgrades are no exception. Creating an Oracle database in Docker is fast and easily repeated. Containers require little time or effort to create and are light enough to run on a laptop. This makes Docker the ideal platform for evaluating, practicing, and perfecting database upgrade procedures. In this session, I’ll demonstrate: – Approaches for installing, patching, and customizing Oracle database software on Docker – Modifications needed in Oracle’s default Docker image builds to support upgrades – Techniques for creating “upgrade containers with source and target Oracle database homes preinstalled – How to merge multiple database images into a single container – Methods for creating reference data for running instant databases

Where will you practice your next upgrade? How many chances will database teams have to familiarize themselves with the tools, and how prepared will they be if something goes wrong? Docker makes it easy to rehearse upgrades and produces more confident teams and better outcomes!

Speakers BIO: Sean Scott
Principal Consultant, Viscosity NA

Sean has worked with Oracle technologies since 1995 with a focus on RAC/MAA, Engineered Systems, migrations and upgrades, systems reliability and resilience, and performance tuning. His experience includes DevOps, automation, cloud computing, containers, TFA/AHF, virtualization, and Infrastructure as Code. Sean is a regular presenter at conferences and webinars including Collaborate and Oracle OpenWorld. He serves on the boards of the Utah Oracle User Group and Real Applications Special Interest Group. He is an Oracle ACE, Oracle Certified Professional, Oracle Certified Specialist, and blogs at https://oraclesean.com.