FILESYSTEM_LIKE_LOGGING option in secure files
Hi all,
I got a question: what kind of info Oracle database stores when using secure files with "filesystem_like_logging" in order to restore data?
Don't know how exactly this feature works but I'm really surprised about the disk space saved. I read "filesystem_like_logging" has to do with metadata.
Let's say we got a table with 10 million rows including a CLOB field. That field is stored as SECUREFILE "filesystem_like_logging" option in a ASSM tablespace
locally uniform 16MB extension. We have inserted 10 million rows with a CLOB size of 1kb. Here are the main stats:
Rows: 10 M
I got a question: what kind of info Oracle database stores when using secure files with "filesystem_like_logging" in order to restore data?
Don't know how exactly this feature works but I'm really surprised about the disk space saved. I read "filesystem_like_logging" has to do with metadata.
Let's say we got a table with 10 million rows including a CLOB field. That field is stored as SECUREFILE "filesystem_like_logging" option in a ASSM tablespace
locally uniform 16MB extension. We have inserted 10 million rows with a CLOB size of 1kb. Here are the main stats:
Rows: 10 M
0