Posts Tagged ‘Oracle Query’

To find the ROW Counts of tables that belongs to a Particular Schema

September 12th, 2017, posted in Oracle
Share
select table_name,num_rows counter from dba_tables where owner=’Schema_name’ order by table_name;
Share

How to check Oracle EBS/APPS Version

May 22nd, 2016, posted in Oracle
Share

To check Oracle EBS/APPS Version

Run following SQL from apps user :Problem sys@standby> startup mount; ORACLE instance started. Total System Global Area 835104768 bytes Fixed Size 2217952 bytes Variable Size 490735648 bytes Database Buffers 335544320 bytes Redo Buffers 6606848 bytes Database mounted. sys@standby> alter database recover managed standby database using current logfile disconnect; alter database recover managed standby database using current logfile disconnect * ERROR at line 1: ORA-01153: an incompatible media recovery is active Cause This indicates a currently running media recovery process. Action sys@standby> alter database recover managed standby database cancel; sys@standby> alter database recover managed standby database using current logfile disconnect; Note When shutting down physical standby database, firstly turn off media recovery process. Otherwise the next time when starting up redo apply again, you will encounter error ORA-01153.

select RELEASE_NAME from fnd_product_groups; 

You should see output like :

RELEASE_NAME
-----------------------
11.5.10.2
Share