Like all our patterns Mike the Oracle one is self documenting. If you click on the link in the SI or the PatternModule itself in ADDM it will take you to the online "Configipedia" documents and the entry here.
What you are seeing in Oracle's case is the SID, because this is part of the command line and therefore can be discovered using the OS credentials.
You can disable any of the deep database patterns if you wish, or simply don't provide credentials if you want the sipler but slightly less efficient route. But you would then be limited to the data that can be recovered using OS credentials and not through JDBC. Again each pattern is documented on Configipedia so you can make that judgement.
Currently ADDM does not create an entity in the CMDB for the logical database (which would be BMC_Database) just the server itself (as BMC_SoftwareServer).
Hope that helps.
A little update to this thread.
As of ADDM 8.3 ADDM will create an entity in the CMDB for the logical database (BMC_Database) for Oracle RDBMS, Microsoft SQL Server, Sybase ASE and MySQL RDBMS.
In case of Oracle and Microsoft SQL Server logical database(s) name(s) can be obtained without JDBC credentials.