Is it possible to do a Oracle tile similar to the SQL one if I wanted to build a tile to display information stored in an Oracle DB on a dashboard?
I don’t think so - The tiles are as they are.
You could, possibly (I’m not an Oracle guy), use the PowerShell MP to write an agent task that queries the database, then use the SCOM Task tile. It’s a little more work, but the results would be the same.