Recent content by DomGo

I am not quite sure why this query uses a filter for object_type as we want to query invalid objects. In fact this query takes much longer (10 seconds) compared to select object_name, owner, object_type from sys.all_objects WHERE status 'VALID' order by object_name (0,5 seconds). But...

We're dealing exactly with the same problem. The shared_pool_size was already significantly raised by our administrator. The first (initial) query needs up to 60 seconds to show any invalid object. Is there a solution to this problem in the meantime? Regards, Dominik

Hi, how can I align the output in cells at the top of the cell? My report displays a column with long multiline texts. The output in the other cells of the row is vertically centered. I would like to have it at the top of the cell. Regards, Dominik