The Automatic Workload Repository (AWR) is often only used to when you have been notified that there is or has been a problem.

Oracle Statistics are critical to the optimizer and your system performance, whether on-premises, in the Cloud or Autonomous.

Hints - kratka navodila o tem, kako naj se poizvedba izvaja - so na voljo za uporabo in zlorabo že kar nekaj časa. Dovoljujejo nam predpisati način izvedbe poizvedbe - ker verjamemo, da je boljši, kot jo predlaga naš predragi optimizer.

Our daily life bringing us a lot of challenges in both personal and professional aspects. Fast-changing technology and more pressure from business bring a lot of pressure to IT which have to deliver a project on time. It will is only possible if IT shops start using automation in every phase of work.

Ste že kdaj izgubili podatke?

Pred časom smo prikazali nekaj scenarijev, kako lahko izgubimo podatke, tudi če vse naredimo prav in celo po priporočilih. Vas zanima, kako je s tem v novejših verzijah Oracla - 12, 18, 19?

Na Oracle konferenci Open World 2019, September 2019, bodo predstavljene novosti, ki ji bodo vsebovale prihajajoče verzije Oracle baze (Oracle 20c) in Autonomous Database za podatkovna skladišča (ADWH) in Transakcijsko procesiranje (ATP).

Migrating and Consolidating databases or servers is a regular task for DBAs all over the world, caused mostly by hardware upgrades, RAC revision, application decommissioning and other strategic decisions.

I’ll start with a brief description of the most important V$ views and then continue with listing most of the tools that I know of that can be used to track performance related issues on Oracle Database.

I’ll start off by explaining the core concepts of Grid Infrastructure and its relation to Oracle RAC. Afterward, we’ll dive into a few specific features/characteristics, possibly accompanied by a quick live showcase.

This session will try to convince you of the advantages of using Windows to authenticate your MySQL users.

V modernih rešitvah "single points of failure" ne pridejo v poštev, zato je potrebno na vseh nivojih rešitve poskrbeti za redundanco. Če je to pri aplikacijskih strežnikih mogoče nekoliko bolj preprosto, pa se na nivoju podatkovne baze ponavadi pojavijo težave.

Nowadays databases require to use secure connections to communicate with clients, from application users through listener services, internal features (Apex, OEM), to consuming external services from the database (eg.: sending emails from PL/SQL).