Skip to content
| Marketplace
Sign in
Visual Studio Code>Programming Languages>AuspexLens ProNew to Visual Studio Code? Get it now.
AuspexLens Pro

AuspexLens Pro

LenSQL

| (0) | Free
Visual explain plans, session monitoring and advisors for AuspexLens.
Installation
Launch VS Code Quick Open (Ctrl+P), paste the following command, and press enter.
Copied to clipboard
More Info

AuspexLens Pro

The paid half of AuspexLens, the native, lightweight Oracle Database client for VS Code. It requires the free AuspexLens extension, and adds the analysis layer:

  • Visual explain — the execution plan as a navigable tree, with cost hotspots called out and advisors that say what to improve first.
  • Session monitor — who is connected, what each session is running, and how long it has been waiting. Built on v$session and v$sql.
  • Blocking tree — who is blocking whom, with wait times, straight from the live instance.
  • Top SQL — the heaviest statements in the shared pool, with elapsed, CPU, buffer gets and per-execution cost.

The visual explain plan beside the SQL: sort and hash join nodes with row counts, and advisors ranking where the cost is

The session monitor over v-dollar views, connected as an account with only CREATE SESSION and SELECT_CATALOG_ROLE

Top SQL: the heaviest statements with executions, buffer gets and per-execution cost

No Oracle Management Pack required — ever. Everything AuspexLens Pro reads comes from views that need no Diagnostics Pack and no Tuning Pack, so using it cannot put you out of compliance with your Oracle licence. Some features need GRANT SELECT_CATALOG_ROLE, and Pro tells you exactly that instead of showing an error.

Trying and buying

Installing AuspexLens Pro starts a 14-day trial of every paid feature — no card, no account. Afterwards:

  • Pro — USD 199 per person, per year: https://lensql.dev/auspexlens/buy
  • Team — USD 149 per seat, per year, five-seat minimum: https://lensql.dev/auspexlens/buy
  • Details and comparison: https://lensql.dev/auspexlens/pricing

Licences are sold through Polar (merchant of record). Run “AuspexLens Pro: Activate licence” and paste the key from your purchase email. Activation is one request; after that, verification is local and offline — Pro keeps working with no network at all, and a 14-day grace period after expiry means a renewal can never lock you out mid-flight. “AuspexLens Pro: Licence status” shows what this machine holds and releases the seat when you move machines.

Terms

This extension is commercial software under the AuspexLens EULA, which also ships inside this package as LICENSE.md. The free extension remains MIT and is unaffected.

Support: https://lensql.dev/auspexlens/support · support@lensql.dev


Oracle is a registered trademark of Oracle and/or its affiliates. AuspexLens is not affiliated with, endorsed by, or sponsored by Oracle Corporation; "for Oracle Database" is used descriptively.

  • Contact us
  • Jobs
  • Privacy
  • Manage cookies
  • Terms of use
  • Trademarks
© 2026 Microsoft