the gruffdba

when you just want this Oracle @&$! to work…

Menu

Skip to content
  • About
  • ASM
  • Database Corruption
  • Linux
  • RAC & Clusters
  • RMAN & Backups
  • Video
  • VMware
  • Windows
the gruffdba

Daily Archives: February 22, 2017

Convert your database to use a BIGFILE tempfile

Posted on February 22, 2017 by gruffdba • Posted in Oracle • Tagged bigfile, temp, tempfile • Leave a comment

The following commands may be used to convert an 11g or 12c database to use a BIGFILE temporary tablespace datafile instead of the default regular file, which is limited to 32GB. BIGFILEs can grow to 32TB.

This can be useful when loading very large amounts of data into a database, for example for a POC test.

Continue reading →

Post navigation

Recent Posts

  • Monitoring Oracle Database Performance with Grafana – Part II
  • Monitoring Oracle Database Performance with Grafana – Part I
  • Calculating IOPS and Throughput from GV$FILESTAT and GV$IOSTAT_FILE
  • Calculating Host Utilization using V$OSSTAT
  • Delete a storage snapshot of an Oracle 19c RAC database using ASM diskgroups with Dell PowerMax.

Archives

  • December 2023 (1)
  • November 2023 (2)
  • October 2023 (1)
  • February 2023 (3)
  • December 2022 (1)
  • November 2022 (1)
  • July 2022 (1)
  • June 2022 (2)
  • April 2022 (2)
  • February 2022 (1)
  • November 2021 (1)
  • October 2021 (1)
  • March 2020 (1)
  • August 2018 (1)
  • July 2017 (2)
  • March 2017 (6)
  • February 2017 (6)
  • January 2017 (1)
  • August 2016 (1)
  • June 2016 (2)
  • May 2016 (3)
  • April 2016 (1)
  • March 2016 (1)
  • August 2015 (5)
  • July 2015 (2)
  • July 2014 (1)
  • December 2013 (1)
  • July 2013 (25)
  • May 2013 (1)
  • March 2013 (1)
  • February 2013 (2)
  • January 2013 (5)
  • November 2012 (7)
  • October 2012 (27)

Categories

  • ASM (36)
  • ASMLib (5)
  • Corruption (4)
  • DSSD (1)
  • Filter Driver, ASMFD, Filter Drivers, (6)
  • Hacking (11)
  • Linux (71)
  • Oracle (106)
  • RAC (48)
  • Recovery (5)
  • RMAN (11)
  • Scripts (1)
  • Solaris (1)
  • Uncategorized (13)
  • Video (8)
  • VMware (50)
  • Windows (11)
February 2017
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728  
« Jan   Mar »
Blog at WordPress.com.
  • Subscribe Subscribed
    • the gruffdba
    • Join 76 other subscribers
    • Already have a WordPress.com account? Log in now.
    • the gruffdba
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar