When to rebuild Index?

Select owner, index_name, blevel
From dba_indexes
Where blevel > 2;

Sql to get Shared Pool size

select  pool, to_number(v$parameter.value) value, v$sgastat.bytes, 
(v$sgastat.bytes/v$parameter.value)*100 percentfree
from  v$sgastat, v$parameter
where v$sgastat.name = ‘free memory’ and pool=’shared pool’
and v$parameter.name = ’shared_pool_size’;

Sql to find database,redo and temp size

select (select sum(bytes/1048576) from dba_data_files) “Data Mb”,
(select NVL(sum(bytes/1048576),0) from dba_temp_files) “Temp Mb”,
(select sum(bytes/1048576)*max(members) from v$log) “Redo Mb”,  3
(select sum(bytes/1048576) from dba_data_files) +
(select NVL(sum(bytes/1048576),0) from dba_temp_files) +
(select sum(bytes/1048576)*max(members) from v$log) “Total Mb”
from dual;

To Find Apps Release Name

select apps.fnd_release.RELEASE_NAME from dual;