OBIEE12c: How can I prevent Usage Tracking from inserting to S_NQ_DB_ACCT?

Question

Hi gurus,

I am using Usage Tracking. I would like to enable writing to  S_NQ_ACCT and disable writing to S_NQ_DB_ACCT.

Is it possible?

Thanks!

Alex

Gianni Ceresa · Answer

Setup a job in the database rolling your logs.

Partition the table and simply drop the old partition on a monthly/weekly/daily base.

Ask your DBAs, they will easily fix that in a clean way.

AM_1 · Answer

Christian,

Thanks for the answer.

I needed that because we serve a lot of queries every day and the table grows very quickly.

Thanks again

Alex

[Deleted User] · Answer

Drop the table, rename the table, truncate it once per day... but more importantly: Why? Why would you want that?