Sign in or 
Location: OLAP option - DBA Sample Scripts
Page Threads
Showing 1 thread
| Started By | Thread Subject | Replies | Last Post | ||
|---|---|---|---|---|---|
| olapdba | Additional Scripts | 8 | Jul 20 2008, 5:32 PM EDT by ashamide | ||
- Home
- Rules of Conduct
- FAQ
- Oracle OpenWorld
- Oracle Technology Network
- Oracle Magazine
- Applications
- E Business Suite 11i/R12
- Business Intelligence
- Database
- Editions
- Administration
- Data Access APIs
- Data Cartridge
- Data Import and Export
- Database Benchmarking
- Database Error Codes
- Database Releases
- Database Security
- Database Troubleshooting
- Embedded SQL Precompilers
- Materialized View Log
- Oracle Data Guard
- Oracle Data Mining
- Oracle Questions & Solutions
- Oracle OLAP Option
- Oracle OLAP Option Background
- Oracle OLAP Versions
- Oracle Olap Terminology
- OLAP option - DBA Sample Scripts
- Determine Existence and ReWriteability of Cube Organized Materialized Views (11.1.0)
- Determine Dimensional Hierarchy Levels Information (11.1.0)
- Determine OLAP Cube Dimensions Information (11.1.0)
- Determine OLAP Cube Information (11.1.0)
- Determine Cube Derived Measures Information (11.1.0)
- Determine Who is Accessing OLAP option Multidimensional Datatypes
- Determine "On Disk" Size of OLAP option Multidimensional Datatypes
- Performance Snapshot for Sessions Accessing OLAP option Multidimensional Datatypes
- Verify Physical Properties of OLAP option Multidimensional Datatypes (11.1.0)
- Determine Space OLAP option Schemas are Occupying on a Database
- Display Tables and Corresponding Information on Indices
- Determine Object Dependencies
- Determine Roles and System/Table Privileges Granted to Roles
- Determine Process/PGA Memory in use by Process
- Monitor Per Session UGA, PGA and Cursor Usage
- Comprehensive Tablespace Report with Oracle OLAP Multidimensional Datatype Information
- Determine OLAP options Components and Version
- Verify OLAP option Multidimensional Datatype State (Generations, Pagespaces, etc.) (11.1.0)
- Discover DBA Scheduler Running Jobs (for Analytic Workspace Manager)
- Determine Tablespace and Datafile I/O Activity
- Determine All OLAP Catalogue Objects Visible to a Schema (10.2.0)
- Determine OLAP Cube and Dimension Views (11.1.0)
- Determine Oracle Instance Status
- Determine Platform Information from SQL*Plus
- Statistics Collection for Oracle OLAP Sessions attached to Multidimensional Datatypes
- Monitor Session Information for Multidimensional Datatype Access (11.1.0)
- Simple Space Report with OLAP Multidimensional Datatype Information
- Free a Session of Allocated OLAP Page Memory
- Determine Wait Events for Sessions Attached to OLAP Multidimensional Datatypes
- Determine Roles and System/Table Privileges Granted to Users
- Determine Amount of PGA occupied by OLAP option Sessions
- Determine OLAP option Multidimensional Datatypes in the Buffer Cache
- Monitor OLAP option Multidimensional Datatype TEMP & LOB Reads, Cache Writes and Rows Processed
- Determine Version, Amount of Pagespaces and Generations in OLAP option Multidimensional Datatypes
- Monitor Free Memory in SGA
- Monitor Index Usage
- Analyzing Olap Objects Scripts
- Determine SQL Text for Users attached to OLAP Multidimensional Datatypes
- 11.Statistics Collection for Oracle OLAP Sessions attached to Multidimensional Datatypes (11.1.0)
- Gather Statistics on Dependent SYS Tables for OLAP Cubes
- OLAP option - Diagnostic Techniques
- OLAP option - Did You Know?
- Oracle OLAP How To
- Getting Started With Oracle OLAP Option
- OLAP Newsletter
- OLAP option - RAC & GRID
- OLAP Option Documentation
- Oracle Statistical Functions
- Oracle Warehouse Builder
- Performance Tuning
- PL/SQL
- Real Application Clusters
- Real Application Testing
- scott/tiger
- Shared Pool Memory Structures
- Spatial
- SQL
- Virtualization
- Real World Performance
- Oracle 11g Database Features
- Oracle Database Hosting Companies
- Messaging Gateway
- FlashBack
- Parameters
- Events
- Dumping data
- Hanganalyze
- Tracing
- Oracle Dictionary
- How ORACLE CBO Calculate Join Cardinality with Join Elimination Filter?
- Database Tools
- Ronald_Vargas_CR
- Oracle XMLDB
- Query Parsing
- Oracle DB notes-tricks-techniques
- Developer Tools
- Embedded
- Enterprise Manager
- Fusion Middleware
- Grid Computing
- Java
- Linux
- Oracle and FOSS
- Oracle Secure Enterprise Search
- Windows and .NET
- TimesTen
- Oracle On Demand
- Oracle VM
- Semantic Web
- Installation Guides
- Security & Compliance
- Scripting Languages
- Oracle Certification
- Acronyms
- Oracle Community
- Spanish Wiki
- Web 2.0 Resource Library
- Architect / Architecture Resources
- QuestionsOnSOA
- Japanese Wiki (日本語)
- ISV Guideline DBA friendly Software
- Fusion
- Oracle Cloud Computing
- Oracle Italy Technology Insight Program
- SOA Events Calendar
- Jobs for Architects
- France Communauté Partenaires Database
- Polskie Portale
- Desmistifying SOA
- High availability with RAC or Fail Safe
- Scripts Shell desde Procedimiento BD Oracle
- Communauté E2.0 France
- E2.0 česká wiki
- Oracle Mix sandbox
- ERP 2.0
- Nuove norme del Garante della Privacy
- Debugging Siebel EIM
- Improving Siebel Configuration Efficiency
- Enterprise Tool
- enterprise20spain
- Blurbs
- Prime People
- Primavera
- Job Oracle Transportation Management
- PL Wiki ORACLE
- SOA Governance Cookbook
- Oracle Support
- OPN Portugal
- RAC Assurance Team
- Why do you need 11g
- Oracle Certifications
- Weblogic Integration ( WLI )
- Specialized OPN Program your questions
- Patching Hints and Tips
- Nordics Wiki
- Oracle Direct Iberia
- Migration tools to Oracle solutions
- SQL COMMANDS
- Sierra Atlantic, Inc.
