(Fuad Arshad) The Recovery Appliance or ZDLRA is a great way to ensure consistent Backup and Recovery of you Oracle Database but as DBA’s we often want to see what is happening Behind the Covers. As with every Oracle Product there is a GUI (Enterprise Manager) or Command line based environment.
Tag: Oracle
Fix index corruption found using analyze table validate structure
(Bobby Durrett) We have struggled with a corrupted database and have gone through too many issues and challenges to document in a blog post. But, I thought I would document the fix to some index corruption that I found during the process. This is all on Red Hat 64 bit Linux Oracle 12.1.0.2 database.
Setting APPINFO in SQL*Plus
(Arup Nanda) Ever used the MODULE column of V$SESSION view? If you haven’t, you are missing out on a very important piece of instruemntation code built right into the Oracle database session management.
12.2 New Feature: the FLEX ASM disk group part 1
(Martin Bach) I knew about the 12.2 FLEX ASM disk group type from other presenters but until now – when researching the feature for the upcoming DOAG HA Day – I haven’t been able to appreciate how cool this is.
Display Oracle Forms 12c Sessions with WLST
(Dirk Nachbar) Sometimes you want to get a quick overview of the current connected Forms Sessions in your Oracle Forms 12c environment and the Fusion Middleware Control (http://:7001/em) is sometimes really slow reacting.
Create a 12c physical standby database on ODA X5-2
(Harry Dragstra) ODA X5-2 simplifies and speeds up the creation of a 12c database quite considerably with oakcli. You can take advantage of this command by also using it in the creation of physical standby databases as I discovered when I had to setup Dataguard on as many as 5 production and 5 accep
Offline Analysis of ASH Data with ASHDUMP
(Christian Antognini) From time to time, it happens to me to carry out offline analyses of ASH data. For that, I mean to analyze the ASH data without having access to the database instance that generated it.
Oracle’s ‘Parallel Query Allocate Buffer’ Latch
(David Fitzjarrell) In an Oracle forum recently the following question was posted:
Refresh selected row(s) in an Interactive Grid
(Roel Hartman) In my previous post I blogged about pushing changed rows from the dabatase into an Interactive Grid. The use case I’ll cover right here is probably more common – and therefore more useful!
Oracle Clusterware 12cR2 – deprecated and desupported features
(Syed Jaffar Hussain) Having clear understanding of deprecated and desupported features in a new release is equally important as knowing the new features of the release. In this short blog post, I would like to highlight the following features that are either deprecated or desupported in 12cR2.
