We do not have a dedicated sensor for monitoring shares on oracle. Perhaps you can use the Oracle SQL v2 sensor, or you can create your own custom script which would retrieve the information, you can then run the script with one of our custom sensors.
Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.