Tags » 11g

Oracle DataGuard and Standby Database Archive Logs

Users see your wonderful DataGuard implementation like this:

And yet, you know the actual picture looks more like this:

High-availability – the concept behind it makes every DBA shudder because every time it seems you deal with one element and have it protected, there’s another underlying component that also needs protection and redudancy, or else your solution is still insufficient. 845 more words

Oracle

Oracle 11gR2 - DBA_DATA_FILES MAXBYTES value 0

Oracle 11gR2 – DBA_DATA_FILES MAXBYTES value 0

When we query the DBA_DATA_FILES table (for scripting), we need to take extra care while getting data from MAXBYTES column. 157 more words

Oracle Database

Export to Excel enhancements in JDeveloper 11.1.1.9.0 and JDeveloper 12.1.3

In the current JDeveloper version 11.1.1.9.0 and 12.1.3 the af:exportCollectionActionListener got enhanced by options to filter the data to export.

The option this blog talks about is the one marked, the FilterMethod. 776 more words

JDeveloper

adfgok reblogged this on adfgok.

Naviagting an af:table in pagination mode from a bean

A question on the JDeveloper and ADF OTN forum asked about how to navigate to a specific page of an af:table in pagination mode. As of JDeveloper 11.1.1.7.0 adf tables can be rendered in scroll mode or in pagination mode where only a specific number of rows are visible in the table. 863 more words

ADF

adfgok reblogged this on adfgok.

Know when to rebuild indexes

Summary

An Oracle server index is a schema object that can speed up the retrieval of rows by using a pointer.

You can create indexes on one or more columns of a table to speed SQL statement execution on that table. 593 more words

11g

Reducing Tablespace Size

In the last post about tablespaces (tablespaces free space) I talked about used and free space in permanent and temporary tablespaces. I also included a script to see all the tablespaces with the f…

Source: Reducing Tablespace Size

11g

Oracle RAC 11gR2- Configure job scheduler to run on a preferred node

Oracle RAC 11gR2- Configure job scheduler to run on a preferred node

In Oracle RAC, a job that is defined in the scheduler may run on either node by default.  312 more words

Oracle Database