Badri... Thanks...

Global is often manually updated and it could be pointing to a wrong value if the database is cloned from another database.

If there a USERENV or SYS_CONTEXT command we can do to get SID from dual?