Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
21
Views
3
Comments
AM_1
AM_1 Rank 4 - Community Specialist
edited Aug 13, 2024 5:19PM in Oracle Analytics Forum

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

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

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

  • AM_1
    AM_1 Rank 4 - Community Specialist

    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

  • Gianni Ceresa
    Gianni Ceresa Mod

    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.