Monday, 30 December 2013

Simplest query to check the existing application and Database nodes in your database:
-----------------------------------------------------------------------------------------------------------
set lines 150
set pages 200
col NODE_NAME for a10
col NODE_NAME for a20
col SERVER_ADDRESS for a18
col HOST for a15
col DOMAIN for a18
col SUPPORT_CP for a3
col SUPPORT_FORMS for a3
col SUPPORT_WEB for a3
col SUPPORT_ADMIN for a3
col STATUS for a10
select NODE_NAME, SERVER_ADDRESS, HOST, DOMAIN,SUPPORT_DB D, SUPPORT_CP C, SUPPORT_FORMS F,SUPPORT_WEB w, SUPPORT_ADMIN A, STATUS from apps.fnd_nodes;

Posted by at

5 comments:

  1. Unknown30 December 2013 at 06:08

    Very Good...

    ReplyDelete
  2. Unknown30 December 2013 at 06:10

    Please share some query to find tables in the database which have been not gathered stats for a very long time.

    ReplyDelete
    Replies
    1. Akash6 January 2014 at 03:04

      Hi Rima,
      Please try this query as sys user:-
      select OWNER,TABLE_NAME,LAST_ANALYZED,GLOBAL_STATS,USER_STATS,NUM_ROWS from all_tables order by NUM_ROWS;

      Delete
  3. Unknown3 January 2014 at 02:46

    Thanks Bro It is a good peace of information..
    Keep it up (Y)

    ReplyDelete
  4. Akash6 January 2014 at 03:00

    Thanks friends. for your support.

    ReplyDelete

Subscribe to: Post Comments (Atom)