Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: datafile

How to refresh Oracle data dictionary to remove deleted tablespace and datafiles?

By adminPosted on September 21, 2023

Question : Long story short we have a server with two Oracle instances running on it: ora1 and ora2. Somebody […]

Two SQL Server databases share the same MDF and LDF files but have different data [closed]

By adminPosted on July 15, 2023

Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]

Where/how does innodb store tables in files?

By adminPosted on July 8, 2023

Question : I read somewhere that InnoDB can store all the tables in a single file or in separate files. […]

How to Move TempDB Files to a Different Drive or Folder? [duplicate]

By adminPosted on July 3, 2023

Question : This question already has answers here: Safely moving and creating new tempdb files (3 answers) Closed 4 years […]

How can I set block size on Oracle 11 when creating a database instance

By adminPosted on May 9, 2023

Question : Is there any way to configure Oracle 11g’s default block size on installation? I have tried Oracle 11g […]

What’s better/faster? MySql or FileSystem?

By adminPosted on March 27, 2023

Question : Let’s imagine a web site that is a directory of people. For each person there may be a […]

What is a good practice for storing unstructured tables as a field in mongodb

By adminPosted on March 12, 2023

Question : Context: I am developing an application that requires handling tables that do not necessarily have an uniform structure […]

Removing secondary data files. DBCC SHRINKFILE: Page could not be moved because it is a work table page

By adminPosted on March 11, 2023

Question : I have too many secondary data files (.ndf) created for tempdb. To remove the excess files, I need […]

Why is MySQL database data-files deployed under /var/lib/mysql?

By adminPosted on January 28, 2023

Question : I was wondering why do we deploy data files under /var/lib/mysql/. Is there a logical reason for that, […]

DBCC ShrinkFile EmptyFile fails due to system table SYSFILES1

By adminPosted on December 16, 2022

Question : In following a recommendation from our new storage vendor, I’m trying to split up some large & busy […]

  • 1
  • 2
  • 3
  • …
  • 8

Recent Posts

  • SQL Server Full-text population deadlock
  • Can sp_executesql be configured / used by default?
  • SQL Server Query Store – why does it not always use the forced plan? [duplicate]
  • Multiple query to columns indexed in MySql
  • cluster_database TRUE/FALSE what does it mean in Oracle RAC?
  • mysql – How to repair & backup archive table, also stop growing .ARN extension file?
  • How does the transactions interact if you set a different isolation level per connection?
  • Autovacuum in Postgresql database
  • MySQL Server 5.7.33 or upgrade
  • What are the performance implications of using uuid as primary key in Postgres 10.12? (need canonical answer) [duplicate]
  • How do I use subquery on the same table in MySQL?
  • Error on updating a field with binary values
  • Feasibility of a MSSQL Read Only Replicas as ephermal containers?
  • How to represent directed graph with multiple parents?
  • Promoting MySQL slave with unknown replication delay
  • Rules for Decomposition to 2 NF
  • Index with ops for `LIKE` and `=` queries
  • How many cores are used for serial plans in SQL Server?
  • MySQL read-write Master with many read-only Slaves over shared storage?
  • How to reference categories table in products table?

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding