Library cache miss ratio is very high ,95% of shared pool is in use if I want to flush shared pool without shuting down database and (while activity going on) what is the effact.
Will it create problems ?
Is there any way to find out problem queries or which queries is running what time.
Or Which session is creating contentation ??