How to List all Databses in your sharepoint farm

Use a simple powershell commands

Start > Microsoft SharePoint 2010 Products > SharePoint 2010 Management Shell

It gets a list of all the databases used by SharePoint farm :

Get-SPDatabase | Select Name

It gets a list of the content databases :

Get-SPContentDatabase | Select Name

How to Clear SharePoint cache Step by Step

Following are the steps:

Execute below procedure on all servers in the server farm.

Run Services.msc in command prompt

Select SharePoint 2010 Timer service

Right-click SharePoint 2010 Timer, and then click Stop.

Go the fodler: 

%SystemDrive%\ProgramData\Microsoft\SharePoint\Config\GUID

Take a back up the of all folders in the above path for safe side.

For every folder in the GUID, Delete all the XML files in the GUID folder (DO NOTE DELETE THE FOLDER and cache.ini file). In some folders, we may not find a cache.ini file. Delete all the files in that folder where there is no cache.ini file. If there is Cache.ini file inside a folder, open the file reset to 1 

Run Services.msc in command prompt

Start the Timer service

A deployment or retraction is already under way for the solution, and only one deployment or retraction at a time is supported

Following are steps to resolve this Issue:

stsadm -o enumdeployments

stsadm -o canceldeployment -id <id>