An Oracle Log file is created every hour and each file is over19 GB.
These logs are created when a procedure is run which has been running fine and smaller logs until now.
What do I need to do so the files are not so large? How do I monitor this procedure? In SQL Server, I've used SQL Analyzer and Trace to analyze the performance but I am not familiar with a similar Oracle tool.