General Ledger - EBS (MOSC)

MOSC Banner

Gather Stats taking too much time to complete

edited Oct 9, 2017 5:27AM in General Ledger - EBS (MOSC) 6 commentsAnswered ✓

Having a table, sized around 155GB.

Script is given below to gather stats for the table.. It run more than 2 weeks thn also not completed. Then because of some batch process we forced to stop this scripts.

Need help for tuning the scripts to get better performance...

bash-3.2$ cat gather_stats_for_table_GL_JE_LINES.sql

-- vi gather_stats_for_table_GL_JE_LINES.sql

SET ECHO ON;

-- Spooling the log

SPOOL 'gather_stats_for_table_GL_JE_LINES.log';

-- Unlock the table

exec dbms_stats.unlock_table_stats(ownname=>'GL',tabname=>'GL_JE_LINES');

-- Gather Stats

Tagged:

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