Hi All,
We're trying to figure out if there is any query activity against a few tables in our data warehouse. I suspect I will get asked why we want/need to know this type of information ... so, here's why: We have 2 steps in our ETL process which take a considerable amount of time to update/insert. They are aggregate tables. But, we can simply turn these steps off IF there isn't a reason to keep them active.
We are unsure if the data is being used by our current dashboards. Keep in mind that there are already existing tables with this data, it is just not aggregated in the way that these tables are. If we can confirm no queries are hitting these tables, we'll eliminate the unnecessary steps.
DB version 12.1.0.2
Thanks,
Charles