How rammpeter/panorama works
Panorama is a Rails web tool for inspecting Oracle database performance, including current and historical state, and offering SQL-based tuning analysis. The main user journey is to connect with an Oracle account, inspect database views, and use analysis results to investigate issues. A separate sampler workflow captures Oracle performance data for later review; its job delegates snapshot work to worker threads, while structure checks and PL/SQL packages support sampler setup. The tree and excerpts establish these branches, but do not expose the full routing or rendering flow, so unsupported links are omitted.
Main entry points: panorama_sampler_structure_check.rb Schema checks · dragnet_controller.rb SQL diagnostics · panorama_sampler_job.rb Sampler scheduler · storage_controller.rb Storage views
Components 22
Web analysis
- Panorama web app
app/controllers/application_controller.rb
Database views
- Session history
app/controllers/active_session_history_controller.rb - Current DBA views
app/controllers/dba_controller.rb - Historical DBA views
app/controllers/dba_history_controller.rb - SGA views
app/controllers/dba_sga_controller.rb - Wait analysis
app/controllers/dba_waits_controller.rb - I/O views
app/controllers/io_controller.rb - Storage views
app/controllers/storage_controller.rb - Long-term trends
app/controllers/longterm_trend_controller.rb
Tuning analysis
- SQL diagnostics
app/controllers/dragnet_controller.rb - Index recommendations
app/helpers/dragnet/optimal_index_storage_helper.rb
Performance sampling
- Sampler scheduler
app/jobs/panorama_sampler_job.rb - Sampler workers
app/models/worker_thread.rb - Sampler configuration
app/models/panorama_sampler_config.rb - Schema checks
app/models/panorama_sampler_structure_check.rb - Snapshot package
app/helpers/panorama_sampler/package_panorama_sampler_snapshot.rb - ASH package
app/helpers/panorama_sampler/package_panorama_sampler_ash.rb - Lock package
app/helpers/panorama_sampler/package_panorama_sampler_blocking_locks.rb - Container DBID package
app/helpers/panorama_sampler/package_con_dbid_from_con_id.rb
Application runtime
- Exception handling
app/helpers/exception_helper.rb
Other components
- Oracle user
- Oracle database
Connections 11
- Oracle user → Panorama web app: opens web app
- Oracle user → Oracle database: logs in
- Storage views → Oracle database: queries
app/controllers/storage_controller.rb - SQL diagnostics → Oracle database: executes SQL
app/controllers/dragnet_controller.rb - Sampler scheduler → Sampler configuration: reads configs
- Sampler scheduler → Sampler workers: starts sampling
app/jobs/panorama_sampler_job.rb - Schema checks → ASH package: includes package
app/models/panorama_sampler_structure_check.rb - Schema checks → Container DBID package: includes package
app/models/panorama_sampler_structure_check.rb - Schema checks → Snapshot package: includes package
app/models/panorama_sampler_structure_check.rb - Schema checks → Lock package: includes package
app/models/panorama_sampler_structure_check.rb - SQL diagnostics → Index recommendations: uses recommendations