Shared Server versus Dedicated Server

Oracle Hyperion Financial Management requires all connections to the Oracle database to be served by dedicated server processes. In other words, Financial Management does not work with shared server processes. Dedicated server processes consume more CPU and memory resources but achieve better performance. To use a dedicated server, the net service name value should include the SERVER=DEDICATED clause in the connect descriptor. This is an example of a net service configured for dedicated server processes:

HFMDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = hfm.oracle.com)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = HFMDB1) ) )