How can you check if what kind of server sertup is my
Oracle Database ? if dedicated or shared ? can i changed the
and whats the best setup for an OLTP type of database
which has at max of 250 users with 500 sessions...???
but its not always 250 users who are loged in -- it may be
below 50 users at a instance also...
shared or dedicated...?
8 G of RAM my setup (shared - i think)
shared pool ? 2Gig
buffer cache ? 856MB
large pool ? 1.2Gig
java pool ? 0 - since we dont use JAVA for this
PGA ? 2 Gig
You can do a lsnrctl services LISTENER_NAME to show how many dedicated and shared connections have been made. This will at least tell you if shared server connections have been made in the past even if they're aren't any connected right now.
As the other's have said, then you can look at the mts_ init parameters to see what is configured in the database. Typically, you will probably want to go with dedicated server 95% of the time unless there are valid reasons not too.