UNLIMITED database clones ... ZERO additional fee

  Рет қаралды 633

SQL and Database explained!

SQL and Database explained!

Күн бұрын

Пікірлер: 7
@ashismohanty1958
@ashismohanty1958 4 жыл бұрын
Hey Connor ,bring some session/video on advance queueing in plsql with example and their usage
@berndeckenfels
@berndeckenfels 4 жыл бұрын
When you run the backup forward, you need to roll it forward in a new clone, I suspect changing the datafile structure with new segments won't work for the relying databases which also have a changed extends map?
@DatabaseDude
@DatabaseDude 4 жыл бұрын
I haven't tried it, but I suspect so. It is not as feature complete as the standard pluggable clone facilities we have (but it is free :-))
@berndeckenfels
@berndeckenfels 4 жыл бұрын
That thumbnail is supposed to show Dolly? I wonder how many people remember that ,)
@DatabaseDude
@DatabaseDude 4 жыл бұрын
she seemed to be the most successful one too ....
@VelikikhMikhail
@VelikikhMikhail 4 жыл бұрын
kzbin.info/www/bejne/jJu2qpKtgtR8otE "and the only space it's going to be consumed is deltas" I remember there was a ZFSSA system on which we created thin database copies using Oracle Enterprise Manager Snap Clone. There were probably around 100 of clones and I was asked to take a look why those thin clones occupy 3TB. It turns out the control file was not amended properly and each thin clone occupied 30GB after its creation - that was the size of the redo logs. I don't recall that there were any issues with temporary tablespaces though - probably they were changed in the cloning scripts. Control files are also pretty small usually.
@DatabaseDude
@DatabaseDude 4 жыл бұрын
True - each clone will be (at least) the size of its redo logs.
The virtual column mystery...
9:02
SQL and Database explained!
Рет қаралды 934
«Жат бауыр» телехикаясы І 30 - бөлім | Соңғы бөлім
52:59
Qazaqstan TV / Қазақстан Ұлттық Арнасы
Рет қаралды 340 М.
Непосредственно Каха: сумка
0:53
К-Media
Рет қаралды 12 МЛН
БАБУШКА ШАРИТ #shorts
0:16
Паша Осадчий
Рет қаралды 4,1 МЛН
What do I use Plan 9 for?
10:13
adventuresin9
Рет қаралды 9 М.
Simple steps to Faster Database Code
15:46
SQL and Database explained!
Рет қаралды 2,8 М.
OpenEdge RDBMS Storage Internals with Rob Fitzpatrick
52:04
White Star Software
Рет қаралды 29
Primary Key options for Partitioned Tables
16:40
SQL and Database explained!
Рет қаралды 1,5 М.
When IDLE sessions break your Application!
7:35
SQL and Database explained!
Рет қаралды 1,2 М.
Which rows are locked in my database?
7:15
SQL and Database explained!
Рет қаралды 1,4 М.
23ai for Developers in 90 seconds!
2:06
SQL and Database explained!
Рет қаралды 510
MONTH arithmetic is HARD! Even with ADD_MONTHS
6:58
SQL and Database explained!
Рет қаралды 613
5 Best Practices For Mastering Maintainable SQL!
15:03
The Data Engineering Channel
Рет қаралды 106
«Жат бауыр» телехикаясы І 30 - бөлім | Соңғы бөлім
52:59
Qazaqstan TV / Қазақстан Ұлттық Арнасы
Рет қаралды 340 М.