asked on
Takes forever to pull logs.
The logging is based on msg_id, msg_ts, msg fields
It takes forever to retrieve logs from this table.
Explain plan suggests it does a full table scan on mylog table which contain log entries since Jul-2012, having 500,000 entries.
There are no partitions or index available on the table.
It is not possible to add partitions now as all programs in my project will have to be modified so that the partition key is also sent by mypkg.write_log(v_msg,v_da
Index on msg filed does not seem to be a proper way since there is no key field in it just text.
How can i pull the logs faster, what are my alternatives.
The logging is based on msg_id, msg_ts, msg fields
It takes forever to retrieve logs from this table.
Explain plan suggests it does a full table scan on mylog table which contain log entries since Jul-2012, having 500,000 entries.
There are no partitions or index available on the table.
It is not possible to add partitions now as all programs in my project will have to be modified so that the partition key is also sent by mypkg.write_log(v_msg,v_da
Index on msg filed does not seem to be a proper way since there is no key field in it just text.
How can i pull the logs faster, what are my alternatives.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.