Question: What is a the local_listener
parameter and and how does it differ from an ordinary listener?
When do I need to specify a local listener in my spfile?
Answer: A local listener is specified in your
pfile/spfile startup deck when you database an instance with
The local_listener init.ora parameter specifies a
network name that resolves to an address or address list of Oracle
Net local listeners and it is used used ONLY when you have multiple
listeners that are running on the same machine as this instance.
The local_listener service name, address or address list
is must be specified in the tnsnames.ora file or you will get an
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.