Tagged Questions
5
votes
2answers
149 views
Cardinality rule for bitmap indexes
The Oracle documentation includes the following advice:
A bitmap index should be built on each of the foreign key columns of
the fact table or tables
In that reference, there is even a bitmap ...
1
vote
1answer
101 views
Force chain to start immediately after completion instead of on a timer
Is it possible to force an Oracle chain to restart immediately after it finishes executing, instead of on a timer? I have only found ways to do a temporal restart, which doesn't really work for me as ...
5
votes
3answers
268 views
Partition pruning with multiple date columns
I have a large table in Oracle 11g database that holds historical data from several years, so I would like to partition it by year. The problem is that the table has multiple date columns and they are ...
0
votes
1answer
29 views
Oracle scheduler chain priority in data warehouse applications
The scenario is as follows:
We have a data warehouse type application that relies on the Oracle job scheduler and a Chain. This chain is responsible for generating materialized views (caches) that ...
0
votes
0answers
437 views
oracle database project ideas [closed]
I have to prepare three project ideas for my final year undergraduate project module. I like to work with databases and i want any challenging database design and implementation with various ...
0
votes
0answers
68 views
Oracle Change Data Control - how to use SOURCE_COLMAP$ and TARGET_COLMAP$
Has anyone successfully used the TARGET_COLMAP$ column in Oracle Change Data Control to identify which columns have changed? I'm trying to produce audit reports for users and identify for the user ...
7
votes
2answers
730 views
100 TeraBytes Capacity Database - Resources and Time Estimates
I am working on a 'back of the envelope' calculation for a 100TB reporting database setup. I am seeking out thoughts from the experts here. Proposed environment:
Storage Capacity ~ 100TB
Tables ~ ...
8
votes
1answer
2k views
Limit the degree of parallelism (DOP) available to any query
On Oracle Exadata (11gR2), we have a relatively beefy database.
cpu_count is 24
parallel_server_instances is 2
parallel_threads_per_cpu is 2
We noted, through observation in Oracle Enterprise ...
1
vote
1answer
219 views
Oracle Change Data Capture: Unsubscribed column results in change set record
I am using Oracle 11g's Change Data Capture to track changes on a database table. I am using synchronous mode to minimize latency. Here's an example to illustrate my problem:
Published_Table
...
2
votes
2answers
130 views
How to compare the database of a backup from another environment
Has anyone had any luck with taking a backup (approx 30 tables) from an Oracle database's live environment, then loading a test environment with this backup and doing a comparison between the test ...
5
votes
1answer
235 views
DBA's Scope in datawarehousing Projects
As a DBA trainee, what needs to be known in order to be part of datawarehousing projects?
I mean what resources are suggested to have an overview knowledge of how PL/SQL and other concepts are used ...
0
votes
2answers
1k views
Possible career paths for Oracle Certified Associate (OCA) [closed]
In order to be confident in databases as a entry level job candidate, I completed the OCA certification. Now I want to know what career paths follow this. Can one go into data-mining, BI, or ...
5
votes
1answer
553 views
Do I need to enumerate the columns used in a materialized view when creating the MV log?
I'm currently creating materialized view logs on a whole bunch of tables in order to support materialized views with FAST REFRESH. The materialized views we're creating contain approx 30 columns from ...
