CODEWITHSUNDEEP
sqloracle-databasedatabase-administrationrollback
Sourav Deb
Sourav Deb

Reputation: 119

Where does oracle store undo data? In memory or in hard disk

I know about undo tablespace which is permanent. Does that mean oracle stores undo data in hard disk?

Upvotes: 1

Views: 496

Answers (1)

Hooman Bahreini
Hooman Bahreini

Reputation: 15569

data files are stored on disk Source

A data file is a physical file on disk that was created by Oracle Database and contains data structures such as tables and indexes. A temp file is a data file that belongs to a temporary tablespace. The data is written to these files in an Oracle proprietary format that cannot be read by other programs.

And tablespaces are stored in data files Source

Oracle stores data logically in tablespaces and physically in datafiles associated with the corresponding tablespace.

This means undo tablespace is stored on disk.

Upvotes: 1

Related Questions