Deep AWR (Automatic Workload Repository) analysis for performance tuning. Use this skill when the user asks about: AWR reports and metrics Database wait events over time System statistics and trends CPU usage patterns Parameter changes This skill provides detailed AWR-based performance analysis.
Forecast resource utilization and plan capacity for databases and hosts. Use this skill when the user asks about: CPU, memory, storage, or I/O forecasts Capacity trends and predictions When resources will run out Right-sizing recommendations Historical utilization trends This skill uses OCI's ML-based forecasting for…
Diagnose database issues, analyze ADDM findings, and troubleshoot performance. Use this skill when the user asks about: Database performance problems ADDM recommendations AWR report analysis Wait events and bottlenecks Alert log issues Permission or configuration problems This skill helps identify and resolve database…
The master DBA assistant skill that provides comprehensive guidance for all database administration tasks. Use this skill when: Starting a new DBA session User needs general DBA help Multiple task types might be involved You need to decide which specialized skill to use This skill acts as a router to specialized…
Monitor Oracle Exadata systems including rack topology and resource usage. Use this skill when the user asks about: Exadata system inventory Rack topology and configuration Exadata resource utilization Compute and storage server status This skill provides Exadata-specific monitoring capabilities.
Get instant database fleet overview and statistics without API calls. Use this skill when the user asks about: How many databases are in the fleet Database inventory or fleet summary Databases by compartment or type Quick fleet statistics This skill uses cached data for instant responses with minimal token usage.
Monitor host infrastructure including CPU, memory, storage, and network. Use this skill when the user asks about: Host resource utilization Top processes consuming resources Disk and I/O statistics Network usage patterns Host capacity planning This skill provides host-level observability for database servers.
Manage multiple OCI tenancies and profiles for cross-tenancy operations. Use this skill when the user asks about: Switching between OCI profiles/tenancies Comparing configurations across tenancies Validating profile configurations Cross-tenancy inventory This skill enables DBA operations across multiple OCI…
Audit database users, roles, privileges, and security configuration. Use this skill when the user asks about: Database users and accounts Role assignments System privileges Proxy user configuration Security compliance checks This skill helps DBAs maintain database security posture.
Analyze SQL performance, identify problematic queries, and get tuning insights. Use this skill when the user asks about: Top SQL queries by CPU, elapsed time, or I/O SQL performance degradation or anomalies SQL plan changes or execution plan analysis SQL tuning recommendations ADDM findings for SQL issues This skill…
Manage SQL Plan Baselines for execution plan stability and performance. Use this skill when the user asks about: SQL plan baseline management Execution plan stability Plan regression prevention Automatic plan capture SPM (SQL Plan Management) configuration This skill helps DBAs maintain consistent SQL performance.
Enable, disable, and manage SQL Watch for detailed SQL monitoring. Use this skill when the user asks about: Enabling SQL Watch on databases Checking SQL Watch status Bulk SQL Watch operations SQL monitoring configuration SQL Watch is required for SQL-level insights in Operations Insights.
Manage and monitor database storage including tablespaces and data files. Use this skill when the user asks about: Tablespace usage and availability Storage alerts and warnings Data file management Storage growth and trends Database resource utilization This skill helps DBAs manage storage proactively.
★not rated 1 8mo agoA62 tokens
At most 3 mods per repository are shown here, and a mod shipped inside a plugin is left to that plugin's page — the rest are on their repository pages: