Home » RDBMS Server » Performance Tuning » ip address
ip address [message #170930] Sat, 06 May 2006 07:54 Go to next message
raviteja
Messages: 4
Registered: April 2006
Location: hyderabad
Junior Member
hiii
i m having some oracle interview questions ..can any one help me in giving solutions
1.how do u tell wht ur machine name is and what is its ip-address?
2.how would you go about verifying the network name that the local_listener is currently using..??
3.you have 4 instances running on the same unix box.how can u determine which shared memory and semaphores are associated with which instance..?
Re: ip address [message #170937 is a reply to message #170930] Sat, 06 May 2006 09:12 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
For which position are you interviewing?

>1.how do u tell wht ur machine name is and what is its ip-address?

ifconfig
uname -a

>2.how would you go about verifying the network name that the local_listener is currently using..??

lsnrctl status

3.you have 4 instances running on the same unix box.how can u determine which shared memory and semaphores are associated with which instance..?

ipcs -a
Previous Topic: Queries perform slow
Next Topic: pinning objects ?? but when ??
Goto Forum:
  


Current Time: Wed May 29 19:00:41 CDT 2024