http://www.pythian.com/news/38159/temporary-tablespaces-to-bigfile-or-not-to-bigfile/
My Oracle Support note 465840.1 has some good information about addressing tempfile contention in RAC. It mentions that “buffer busy wait” events on the file header block can be encountered in RAC as each instance allocates space in the same tempfile. It recommends creating at least as many tempfiles as there are instances in the cluster. To accommodate multiple files in a tablespace, we must create a SMALLFILE tablespace, and work around the 32G file limit. In our case, it means creating a new temporary tablespace with 24 32G tempfiles for a total capacity of 768GB, changing the default temporary tablespace, and dropping the old one.
Flashback a Pluggable Database in RAC with Data Guard
-
I have published a new video Flashback PDB in RAC with DG.
Here are some important considerations / commands when you want to use
Flashback :
1. Ensur...
Acum 4 zile
Niciun comentariu:
Trimiteți un comentariu