Databases Reference
In-Depth Information
On the same screen, Janice selects the Connection Mode tab. Oracle can
accept connections in one of two modes: Dedicated or Shared. Dedicated mode
gives the best response time for users who run queries constantly, and Shared
mode works best for users who run infrequent queries on a server that may have
limited memory resources. Only a handful of users will be using this data ware-
house, so Janice selects Dedicated Server Mode.
After clicking Next, Janice has the option to tweak the datafile names and loca-
tions, but she once again accepts the defaults for all file locations and clicks Next.
