Question
How to Control Use of Shared Servers

Answers

If you are running your user process locally on the server machine, you can bypass the shared server simply by using a direct connection. From a SQL*Plus prompt, issue the command
SQL> connect sys/oracle as sysdba
and you will get a dedicated server, because you have not specified a network alias that would go via a listener. All local connections, not just yours as sysdba, will do this. But most of your users will be coming in across a network through a listener. An application has no way of controlling whether it is using a shared server or a dedicated server, but as DBA you can control this through Oracle Net. If dispatchers and shared servers are available, by default every connection through the listener will use them. This default can be overridden by the connection details you specify in the client side tnsnames.ora file, configured either by hand or through the Net Manager.
Note that choosing a connection type is an example of something that can be done if you are using local or directory naming, but not with Easy Connect. Easy Connect will always use shared server if it is available.   Your Comment




More Software Questions..
What is the inputsplit in map reduce software?

What is software configuration management?

What Is Java Api For Xml-based Rpc (jax-rpc)?

How can you implement fine-grained auditing?

What is IBM’s simple explanation for Big Data’s four critical features?

What is static synchronized method in JDBC API? Give an example?

What does the NULLIF function do?

What happens if a start method is not invoked and the run method is directly invoked?

Should we override finalize method

what is the difference between mysql_fetch_array and mysql_fetch_object?

How will XML affect my document links?

Why to use Style Sheets?

What are Filters in MVC?

Can you explain Application layer in OSI model?

How to define new testplan attributes?

What are the minimum system requirements to run Photoshop? Is it possible to run Photoshop over linux?

Which oracle package is used to manage the oracle lock management services?

What is Latch Up? Explain Latch Up with cross section of a CMOS Inverter. How do you avoid Latch Up?

What is marker interface?

What types of partitioning are there for BW?



Search
Can you Answer!!
  • Q Tell me about a difficult loan you approved.
  • Q What are the test types supported by selenium?
  • Q What is a Form collection?
  • Q Who was cartoonist William Hannah's professional partner?
  • Q what are the default addin’s provided by WR
  • Q ‘Mamankom’ festival of medieval Kerala was conducted at:
  • Q As per RBI, a credit card will be an NPA if any payment is not received till
  • Q In Hungary, goiter is prevalent in the northern Transdanube region because the iodine content of drinking water is usually low in Hungary.
  • Q What is Special G/L transactions
  • Q What salary are you seeking at Whole Foods?
  • Q How can you force garbage collection?