No, there is no interface to determine after-the-fact whether or not a database was opened in shared cache mode.