# rammpeter/panorama architecture

> Architecture diagram of the GitHub repository rammpeter/panorama, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-19). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/rammpeter/panorama
- Repository: https://github.com/rammpeter/panorama

## Overview

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: [`app/models/panorama_sampler_structure_check.rb`](https://github.com/rammpeter/panorama/blob/master/app/models/panorama_sampler_structure_check.rb) (Schema checks), [`app/controllers/dragnet_controller.rb`](https://github.com/rammpeter/panorama/blob/master/app/controllers/dragnet_controller.rb) (SQL diagnostics), [`app/jobs/panorama_sampler_job.rb`](https://github.com/rammpeter/panorama/blob/master/app/jobs/panorama_sampler_job.rb) (Sampler scheduler), [`app/controllers/storage_controller.rb`](https://github.com/rammpeter/panorama/blob/master/app/controllers/storage_controller.rb) (Storage views)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_web["Web analysis"]
  node_web_app["Panorama web app"]
end

subgraph group_database_views["Database views"]
  node_session_history["Session history"]
  node_dba_current["Current DBA views<br/>[dba_controller.rb]"]
  node_dba_history["Historical DBA views"]
  node_dba_memory["SGA views"]
  node_dba_waits["Wait analysis"]
  node_io_views["I/O views<br/>[io_controller.rb]"]
  node_storage_views["Storage views"]
  node_longterm_views["Long-term trends"]
end

subgraph group_advisory["Tuning analysis"]
  node_dragnet["SQL diagnostics"]
  node_index_advice["Index recommendations"]
end

subgraph group_sampling["Performance sampling"]
  node_sampler_job["Sampler scheduler"]
  node_worker_threads["Sampler workers<br/>[worker_thread.rb]"]
  node_sampler_config["Sampler configuration"]
  node_structure_check["Schema checks"]
  node_snapshot_package["Snapshot package"]
  node_ash_package["ASH package"]
  node_blocking_package["Lock package"]
  node_con_dbid_package["Container DBID package"]
end

subgraph group_runtime["Application runtime"]
  node_exception_helper["Exception handling"]
end

node_analyst(("Oracle user"))
node_oracle[("Oracle database")]

node_analyst -->|"opens web app"| node_web_app
node_analyst -->|"logs in"| node_oracle
node_storage_views -->|"queries"| node_oracle
node_dragnet -->|"executes SQL"| node_oracle
node_sampler_job -.->|"reads configs"| node_sampler_config
node_sampler_job -->|"starts sampling"| node_worker_threads
node_structure_check -->|"includes package"| node_ash_package
node_structure_check -->|"includes package"| node_con_dbid_package
node_structure_check -->|"includes package"| node_snapshot_package
node_structure_check -->|"includes package"| node_blocking_package
node_dragnet -.->|"uses recommendations"| node_index_advice

click node_web_app "https://github.com/rammpeter/panorama/blob/master/app/controllers/application_controller.rb"
click node_session_history "https://github.com/rammpeter/panorama/blob/master/app/controllers/active_session_history_controller.rb"
click node_dba_current "https://github.com/rammpeter/panorama/blob/master/app/controllers/dba_controller.rb"
click node_dba_history "https://github.com/rammpeter/panorama/blob/master/app/controllers/dba_history_controller.rb"
click node_dba_memory "https://github.com/rammpeter/panorama/blob/master/app/controllers/dba_sga_controller.rb"
click node_dba_waits "https://github.com/rammpeter/panorama/blob/master/app/controllers/dba_waits_controller.rb"
click node_io_views "https://github.com/rammpeter/panorama/blob/master/app/controllers/io_controller.rb"
click node_storage_views "https://github.com/rammpeter/panorama/blob/master/app/controllers/storage_controller.rb"
click node_longterm_views "https://github.com/rammpeter/panorama/blob/master/app/controllers/longterm_trend_controller.rb"
click node_dragnet "https://github.com/rammpeter/panorama/blob/master/app/controllers/dragnet_controller.rb"
click node_index_advice "https://github.com/rammpeter/panorama/blob/master/app/helpers/dragnet/optimal_index_storage_helper.rb"
click node_sampler_job "https://github.com/rammpeter/panorama/blob/master/app/jobs/panorama_sampler_job.rb"
click node_worker_threads "https://github.com/rammpeter/panorama/blob/master/app/models/worker_thread.rb"
click node_sampler_config "https://github.com/rammpeter/panorama/blob/master/app/models/panorama_sampler_config.rb"
click node_structure_check "https://github.com/rammpeter/panorama/blob/master/app/models/panorama_sampler_structure_check.rb"
click node_snapshot_package "https://github.com/rammpeter/panorama/blob/master/app/helpers/panorama_sampler/package_panorama_sampler_snapshot.rb"
click node_ash_package "https://github.com/rammpeter/panorama/blob/master/app/helpers/panorama_sampler/package_panorama_sampler_ash.rb"
click node_blocking_package "https://github.com/rammpeter/panorama/blob/master/app/helpers/panorama_sampler/package_panorama_sampler_blocking_locks.rb"
click node_con_dbid_package "https://github.com/rammpeter/panorama/blob/master/app/helpers/panorama_sampler/package_con_dbid_from_con_id.rb"
click node_exception_helper "https://github.com/rammpeter/panorama/blob/master/app/helpers/exception_helper.rb"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_web_app,node_analyst toneBlue
class node_session_history,node_dba_current,node_dba_history,node_dba_memory,node_dba_waits,node_io_views,node_storage_views,node_longterm_views,node_oracle toneAmber
class node_dragnet,node_index_advice toneMint
class node_sampler_job,node_worker_threads,node_sampler_config,node_structure_check,node_snapshot_package,node_ash_package,node_blocking_package,node_con_dbid_package toneRose
class node_exception_helper toneIndigo
```

## Components

### Web analysis

- [Panorama web app](https://github.com/rammpeter/panorama/blob/master/app/controllers/application_controller.rb): `app/controllers/application_controller.rb`

### Database views

- [Session history](https://github.com/rammpeter/panorama/blob/master/app/controllers/active_session_history_controller.rb): `app/controllers/active_session_history_controller.rb`
- [Current DBA views](https://github.com/rammpeter/panorama/blob/master/app/controllers/dba_controller.rb): `app/controllers/dba_controller.rb`
- [Historical DBA views](https://github.com/rammpeter/panorama/blob/master/app/controllers/dba_history_controller.rb): `app/controllers/dba_history_controller.rb`
- [SGA views](https://github.com/rammpeter/panorama/blob/master/app/controllers/dba_sga_controller.rb): `app/controllers/dba_sga_controller.rb`
- [Wait analysis](https://github.com/rammpeter/panorama/blob/master/app/controllers/dba_waits_controller.rb): `app/controllers/dba_waits_controller.rb`
- [I/O views](https://github.com/rammpeter/panorama/blob/master/app/controllers/io_controller.rb): `app/controllers/io_controller.rb`
- [Storage views](https://github.com/rammpeter/panorama/blob/master/app/controllers/storage_controller.rb): `app/controllers/storage_controller.rb`
- [Long-term trends](https://github.com/rammpeter/panorama/blob/master/app/controllers/longterm_trend_controller.rb): `app/controllers/longterm_trend_controller.rb`

### Tuning analysis

- [SQL diagnostics](https://github.com/rammpeter/panorama/blob/master/app/controllers/dragnet_controller.rb): `app/controllers/dragnet_controller.rb`
- [Index recommendations](https://github.com/rammpeter/panorama/blob/master/app/helpers/dragnet/optimal_index_storage_helper.rb): `app/helpers/dragnet/optimal_index_storage_helper.rb`

### Performance sampling

- [Sampler scheduler](https://github.com/rammpeter/panorama/blob/master/app/jobs/panorama_sampler_job.rb): `app/jobs/panorama_sampler_job.rb`
- [Sampler workers](https://github.com/rammpeter/panorama/blob/master/app/models/worker_thread.rb): `app/models/worker_thread.rb`
- [Sampler configuration](https://github.com/rammpeter/panorama/blob/master/app/models/panorama_sampler_config.rb): `app/models/panorama_sampler_config.rb`
- [Schema checks](https://github.com/rammpeter/panorama/blob/master/app/models/panorama_sampler_structure_check.rb): `app/models/panorama_sampler_structure_check.rb`
- [Snapshot package](https://github.com/rammpeter/panorama/blob/master/app/helpers/panorama_sampler/package_panorama_sampler_snapshot.rb): `app/helpers/panorama_sampler/package_panorama_sampler_snapshot.rb`
- [ASH package](https://github.com/rammpeter/panorama/blob/master/app/helpers/panorama_sampler/package_panorama_sampler_ash.rb): `app/helpers/panorama_sampler/package_panorama_sampler_ash.rb`
- [Lock package](https://github.com/rammpeter/panorama/blob/master/app/helpers/panorama_sampler/package_panorama_sampler_blocking_locks.rb): `app/helpers/panorama_sampler/package_panorama_sampler_blocking_locks.rb`
- [Container DBID package](https://github.com/rammpeter/panorama/blob/master/app/helpers/panorama_sampler/package_con_dbid_from_con_id.rb): `app/helpers/panorama_sampler/package_con_dbid_from_con_id.rb`

### Application runtime

- [Exception handling](https://github.com/rammpeter/panorama/blob/master/app/helpers/exception_helper.rb): `app/helpers/exception_helper.rb`

### Other components

- **Oracle user**
- **Oracle database**

## Connections

- Oracle user → Panorama web app: opens web app
- Oracle user → Oracle database: logs in
- Storage views → Oracle database: queries (evidence: `app/controllers/storage_controller.rb`)
- SQL diagnostics → Oracle database: executes SQL (evidence: `app/controllers/dragnet_controller.rb`)
- Sampler scheduler → Sampler configuration: reads configs
- Sampler scheduler → Sampler workers: starts sampling (evidence: `app/jobs/panorama_sampler_job.rb`)
- Schema checks → ASH package: includes package (evidence: `app/models/panorama_sampler_structure_check.rb`)
- Schema checks → Container DBID package: includes package (evidence: `app/models/panorama_sampler_structure_check.rb`)
- Schema checks → Snapshot package: includes package (evidence: `app/models/panorama_sampler_structure_check.rb`)
- Schema checks → Lock package: includes package (evidence: `app/models/panorama_sampler_structure_check.rb`)
- SQL diagnostics → Index recommendations: uses recommendations
