[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Filters for "show status" query



Martin Cordova S. wrote:

> We would like to obtain only certain records returned by "show status". Is
> there an alternative form to execute this query using a where clause of some
> kind of filter?

Martin,

Yes, use a query such as,

   SELECT * FROM SYS_INFO.sUSRDatabaseStatistics
    WHERE "stat_name" LIKE 'Runtime.memory.%'

Toby.