Tagged Questions
4
votes
3answers
160 views
What methods are available to create a snapshot of an oracle database for testing purposes?
I am new to databases and have just been assigned to work with Oracle. We want to create a snapshot of the database for testing purposes that will allow us to revert back once we're done.
I'm a bit ...
1
vote
1answer
265 views
Oracle Materialized View
I need your help with a issue on Oracle Materialized View.
I created the Materialized View using the following command:
CREATE MATERIALIZED VIEW SNAP_TEST
TABLESPACE tbs
NOCACHE
LOGGING
NOPARALLEL
...
0
votes
1answer
235 views
ADDM report dba_hist_snapshot
How does ADDM report work? When I take two snapshots
one for
START: 05-OCT-2011 09:00:00,
END : 05-OCT-2011 10:00:00
and another one for
START: 06-OCT-2011 09:00:00,
END : 06-OCT-2011 ...
