Groups
Groups
Sign in
Groups
Groups
olapdba
Conversations
About
Send feedback
Help
olapdba
1–7 of 7
Mark all as read
Report group
0 selected
ola...@gmail.com
2/27/06
Analytic Workspaces and the Oracle Database 10g RECYCLEBIN
----------------------------- EXAMPLE 1 : Purge Objects from Recyclebin -----------------------------
unread,
Analytic Workspaces and the Oracle Database 10g RECYCLEBIN
----------------------------- EXAMPLE 1 : Purge Objects from Recyclebin -----------------------------
2/27/06
ola...@gmail.com
2/22/06
Determine Size and Owner of AWs in your Database
This is the actual on-disk size of your Analytic Workspace. This does not subtract the reusable space
unread,
Determine Size and Owner of AWs in your Database
This is the actual on-disk size of your Analytic Workspace. This does not subtract the reusable space
2/22/06
ola...@gmail.com
2/22/06
Overall PGA and OLAP Page Pool Consumption
This script will work in 10g and later instances to determine the amount of PGA that the OLAP Page
unread,
Overall PGA and OLAP Page Pool Consumption
This script will work in 10g and later instances to determine the amount of PGA that the OLAP Page
2/22/06
ola...@gmail.com
2/22/06
Determine which sessions are attached to an AWs
------------------------- -- NON RAC -- STANDALONE -------------------------- set pages 500 lines 110
unread,
Determine which sessions are attached to an AWs
------------------------- -- NON RAC -- STANDALONE -------------------------- set pages 500 lines 110
2/22/06
ola...@gmail.com
2/22/06
PGA UGA OLAP Page Pool Hit Miss Ratio and Size by User
------------------------- -- NON RAC -- STANDALONE -------------------------- set lines 110 pages 500
unread,
PGA UGA OLAP Page Pool Hit Miss Ratio and Size by User
------------------------- -- NON RAC -- STANDALONE -------------------------- set lines 110 pages 500
2/22/06
ola...@gmail.com
10/12/05
Determine Analytic Workspace Creation Date
This script will show you the creation date for Analytic Workspaces in your instance. select owner||
unread,
Determine Analytic Workspace Creation Date
This script will show you the creation date for Analytic Workspaces in your instance. select owner||
10/12/05
ola...@gmail.com
3
10/6/05
Tablespace Report with Analytic Workspace Information
Run this script in SQL*Plus/iSQL*Plus to generate a report that even includes AW information: set
unread,
Tablespace Report with Analytic Workspace Information
Run this script in SQL*Plus/iSQL*Plus to generate a report that even includes AW information: set
10/6/05
