V9 EXTREMELY SLOW AFTER REGISTERING REPORTS – TRACE SEQ

After trying to register custom reports v9 took minutes to load between every new screen. Turns out that the problem was a pref I had changed to troubleshoot report problems. Pg 14 of the Customer Reports for RPRO 9.1 doc says to ENABLE SQL TRACE by editting the oracleadminrproodspfileinit.ora by removing the pound sign # (a comment character) from the line ‘sql_trace=true’. ONce I put that comment character back on and restarted the services RPRO9 and report view ran at normal speeds. It was causing SQL trace on all activities, not just reports running.

Probably a no brainer for DBAs, but there isn’t one here (or at RetailPro apparently).

Karen Page

As VP of Sales & Marketing, Karen has been helping to break sales records since 1994! That’s almost 30 years of award-winning sales, helping to build Big Hairy Dog as a leading POS Software and Service provider…worldwide. She has a degree in fine arts (with a minor in business) from the University of Oregon, and with three amazing children and saint of a husband, Karen is still loving life in the Northwest—where she works from home in the Portland, Oregon area.

Her favorite pastime is tailgating at college football games with friends and family. Go Ducks!

Karen Page

As VP of Sales & Marketing, Karen has been helping to break sales records since 1994! That’s 25 years of award-winning sales, helping to build Big Hairy Dog as a leading POS Software and Service provider…worldwide. She has a degree in fine arts (with a minor in business) from the University of Oregon, and with three amazing children and saint of a husband, Karen is still loving life in the Northwest—where she works from home in the Portland, Oregon area.

Her favorite pastime is tailgating at college football games with friends and family. Go Ducks!