TransWikia.com
  1. All Categories
  2. Database Administrators

Database Administrators : Recent Questions and Answers (Page 11)

Find answers to your questions about Database Administrators or help others by answering their Database Administrators questions.

How to increase size of temp tablespace in Oracle 12C RAC with ASM?

I have an Oracle 12c RAC consisting of two nodes (OL6) and ASM. I use it for learning. For some reason I want to increase its temporary tablespace size. It's...

Asked on 12/06/2021 by Gryu

2 answer

Oracle goldengate service is not starting: Failed to retrieve the name of a missing Oracle redo log

I am trying to start GG service, when try 'start my_service' then starting but it didn't start, status is changed always starting to stopped.I need to start goldengate service.....

Asked on 12/06/2021 by J.Col

1 answer

Why does MYSQL use blocking locks instead of optimistic attempts that fail immediately?

Why isn't optimistic concurrency control more commonly supported at the database layer? It is a valid alternative and can completely do away with any blocking locks. For certain usage patterns,...

Asked on 12/06/2021 by Dark Nebula

1 answer

Error: Unable to write inside TEMP environment variable path

I am installing PostgreSQL 9.2.4-1-windows.exe on Windows 7 64 with Service Pack 1. I get the following, rather famous it seems, error:There has been an error. Unable to write inside...

Asked on 12/04/2021 by crthompson

3 answer

Unistalled MySQL 5.6 and installed MySQL 5.7 - Restore Database and Tables

All of the data resides in "C:ProgramDataMySQLMySQL Server 5.6data". There are 46 folders inside of this folder. There is one folder for every old database I had. ...

Asked on 12/04/2021 by geeves

1 answer

Read after write in Galera

I am facing a issue with 3 node galera cluster where the read doesn't return any records even when the write has been commited. Below are the steps which can...

Asked on 12/04/2021

3 answer

Generate SQL Table DDL from a View

How do I generate table structure from a view, in one script? Will only need data types, I am seeking a Table Create Script with some type of dynamic sql...

Asked on 12/04/2021 by user162241

2 answer

Returning values for Stored Procedures in PostgreSQL

I was reading this on PostgreSQL Tutorials:In case you want to return a value from a stored procedure, you can use output parameters. The final values of...

Asked on 12/04/2021 by purav desai

2 answer

GROUPING SETS query with many-to-many relationships

I'm writing a query that is mostly based on a GROUPING SET. A very simplified version of the query is the following:SELECT GROUPING(a,b) as grouping, a,...

Asked on 12/04/2021

1 answer

MySQL taking up 400% CPU

LEMP stack on DigitalOcean (48GB ram, 960GB SSD, 12 vCPU) with WordPress on it. Added a new theme and mysql went through the roof. 400% CPU usage taken up by...

Asked on 12/04/2021 by LittleLebowski

2 answer

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP