Home » RDBMS Server » Server Administration » 3 imp queries
3 imp queries [message #63122] Mon, 13 September 2004 01:49
Vivek Vijai
Messages: 67
Registered: April 2004
Member
Hi I have 3 very imp quieries for all u Oracle experts

1)How can i verify the network name that the local_listener is currently using?

2)I have 4 instances running on the same UNIX box. How can i determine which shared memory and semaphores are associated with which instance?

3)What do the 9i dbms_standard.sql_txt() and  dbms_standard.sql_text() procedures do?

Vivek
Previous Topic: ORA-03113 Executing query from Developer 4.5 with Oracle 9i
Next Topic: Unsubscribe
Goto Forum:
  


Current Time: Fri Jan 24 03:32:24 CST 2025