>My VFP application is currently opening an Oracle session for each remote view that I use. I changed my tools/options/remote data / share connections to my default, and re-built all my views with this option. I also removed my connection re-built it and then re-built my views. I am manuall creating the views, as I do not know a different way. I am still using 23 Oracle sessions. Are there other settings that I can adjust to reduce the Oracle session count?

Run the GENDBC program that comes with VFP against your DBC --

OPEN DATABASE MyDBC
do home() + [tools\gendbc\gendbc]

It will create a PRG file with all the code needed to recreate your DBC and remote views. You can then look at that code to see if your connection is really being shared. If not, I would just create a fixit prg file to loop through all the remote views in the DBC to set the ShareConnection property to .T. on all the RVs.

lnKount = ADBOBJECTS(laViews, 'VIEW')
for each lcView in laViews
    	DBSETPROP(lcView,"VIEW","ShareConnection",.T.)
endfor

As an alternative to GENDBC, you can issue --

? DBGETPROP(ViewName, 'View', 'ShareConnection')

from the Command Window to see if the connection is shared.