Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Snapshot Questions

user11972929Jan 8 2016 — edited Jan 8 2016

We are planning to implement snapshots in Oracle.

I am looking for following :

1. Can we write to snapshot?

2. Can we create snapshot on the snapshot?

3. How many snapshots can we create on a table?

4. How does the optimizer works for snapshot? Do we need take stats on them as well?

5. do we see any issues with snapshots in daily usage? ( performance on database / any additional maintenance required other than space?)

Comments

JeffJon
Have you tried updating the configuration setting for the amount of time that the message is displayed?
LarryR
James, I don't know if thiere is a way to promote your Info Bar message, but given that it may not be possible, would a pop-up window work better in this situation?
783124
Yes this is a good solution, or at least it would be if the message window were left on top, instead of the modal popup and the main window taking centre-stage again a split second later! Is there a way to keep this message window on top?

Another possible solution - do you know if it would be possible to add the message to the "LoadOptMethodVal" Option of the adapter, by passing in the message string? It would be great if the message could feature in the Target System Load modal popup. I suspect not, but it would be ideal, since this would then give the user the option of whether to proceed with the data load or not. I tried modifying the Description field, but this does not appear to feature in the modal popup.
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 5 2016
Added on Jan 8 2016
#sql-developer
1 comment
490 views