Database Tuning (MOSC)

MOSC Banner

Impact on System tables by creating & purging tables frequently [1k-5k tabs/Hr]

edited May 6, 2022 3:14PM in Database Tuning (MOSC) 10 commentsAnswered ✓

Greetings Everyone :)

We are developing a reporting tool, where we can select the fields of report & customize as we want from very large options. since we are gathering data from multiple sources we have design the code as such it would create table, dump data, process it, generate report & purge table..

out of normal table option & PTT[Private Temp Tables] option, normal table option is much better since it gives best performance & we can create require indexes as well.. However I think this could lead to we bloat system tables with very frequent inserts & deletes of new tables data definitions at long term.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center