This is part of a series of "best practice" articles for Oracle Analytics.
The first step in tuning session variable initialization blocks is to follow the recommendations from another article in this series, Performance Issues Signing-in when Oracle Analytics Cloud Uses Data Gateway or Remote Data Connector. That article deals entirely with optimizing session variable initialization blocks.