Tags » 11g

How to hide blank item from SelectOneChoice in ADF

Use Case – There is a use case where User wants to display blank as selected when page loads. But he doesn’t want blank to remain there once user select any value. 298 more words

adfgok reblogged this on adfgok.

[RMAN] Criando catalogo do RMAN

 Olá pessoal,

apesar de básico isso que eu vou colocar hoje, tive alguns problemas, entao já comcamos com:

CUIDADO: Ao instalar o DB do RMAN, coloque-o em letras MAIUSCULAS, pois em alguns casos pode dar erro abaixo:

299 more words
ORACLE

Oracle DB 11gR2 - How to list all hidden/undocumented parameters

How to list all hidden/undocumented parameters in Oracle Database

Oracle database is extremely powerful due to many reasons. One of it is the level of tuning and optimisation that you can perform on it. 174 more words

11g

How to Find Daily & Monthly Data Growth Per Tablespace

How to Find Daily & Monthly Data Growth Per Tablespace

Please click below link to view document.

View Document

How_To

Failed Primary Conversion to Physical Standby

1) Query on old standby database (new primary)

SQL> SELECT TO_CHAR(STANDBY_BECAME_PRIMARY_SCN) FROM V$DATABASE;

TO_CHAR(STANDBY_BECAME_PRIMARY_SCN)
—————————————-
12496643189

2) Flash back the failed primary database.

SQL> shutdown immediate; 61 more words

Oracle

Get DDL from impdp

The below command will not import the dump, but will just create a .sql file with the DDL statements

impdp system/**** directory=import_dir dumpfile=IMPORT.DMP sqlfile=getddl.sql

Oracle

ASM Query to check diskspace as SYSASM 

set lines 999

select GROUP_NUMBER,NAME,TOTAL_MB/1024/1024 as “Total Space in TB” ,FREE_MB/1024/1024 as “Free Space in TB” ,DATABASE_COMPATIBILITY from v$asm_diskgroup;

Oracle