Search code examples
ORA-01219: database not open: queries allowed on fixed tables/views only...


databasesqloracle-databasedatabase-administration

Read More
How to imporve performace of an insert when a table has so many indexes in Oracle?...


oracle-databasequery-optimizationoracle12cdatabase-performancedatabase-administration

Read More
Database Size in GB with use space and free space Oracle DB...


oracle-databaseplsqldatabase-administration

Read More
What is autovacuum_vacuum_cost_delay in autovacuum in PostgreSQL?...


postgresqldatabase-administrationautovacuum

Read More
Lost server admin user access for azure database for MySql server...


mysqldatabaseazuredatabase-administrationazure-mysql-database

Read More
List all indexes that not in use anymore in database, PostgreSQL...


postgresqldatabase-administration

Read More
Query to find the tables size occupied in GB in Oracle SQL for various SCHEMAS...


sqloracle-databasesumdatabase-administration

Read More
What Phenomena does MySQL try to prevent by locking the whole table upon executing Delete statement ...


mysqldatabaselockingrelational-databasedatabase-administration

Read More
DBA/ BI workflows with Azure operations...


azurepowerbidatabase-administration

Read More
Getting 404-Not Found Error on running Oracle APE X Application...


databaseoracle-databaseoracle-apexdatabase-administration

Read More
generating sql trace file from sql developer in Oracle Database...


oracle-databaseoracle11goracle-sqldeveloperdatabase-administration

Read More
I am trying to run a dba_hist_plan query to look for specific schema objects...


sqloracle-databasedatabase-administration

Read More
Is there a way to replace empty string into NULL value in MariaDB?...


mysqlmariadbdatabase-administration

Read More
How can I detect broken stored procedures after a schema change?...


sql-serverdatabase-administration

Read More
Optimize Performance of SQL Server (a lot of waiting tasks)...


sql-serverentity-frameworkado.netload-balancingdatabase-administration

Read More
Case Statement Variable Declaration and use IN MS SQL SERVER...


mysqlsql-serverdatabasedatabase-administration

Read More
Notify Operator if ANY step in job fails...


sql-servernotificationsdatabase-administrationsql-server-agentserver-administration

Read More
How can I take "hot" database backups for mysql without affecting application transactions...


mysqldatabase-administration

Read More
Can we use FIND_IN_SET() function for multiple column in same table...


mysqlsqldatabase-administrationfind-in-set

Read More
Performance issue - max_elapsed_time...


sql-servert-sqldatabase-performancedatabase-administrationdatabase-tuning

Read More
Is there a way to drop a unique constraint in postgres 10.6 without an exclusive lock?...


postgresqldatabase-administration

Read More
Oracle RAC RMAN Backup not writing to NFS Share...


oracle-databasedatabase-administrationnfsrman

Read More
How to enable Identity_insert on SQL Server Level...


sql-serverdatabasedatabase-administration

Read More
Task Automation on Toad for Oracle...


sqloracle-databaseplsqldatabase-administration

Read More
Alternatives in sharing tables in oracle db...


sqloracle-databasedatabase-administration

Read More
select top N records for each entity...


sqlsql-serversql-server-2008-r2database-administration

Read More
How can a SQL Server contained user get all active user connections to this contained database?(sys....


sql-serverdatabase-administration

Read More
indexed view update is table scanning 110 million rows for 6 actual rows found out of histogram key ...


sql-serverhistogramdatabase-administrationindexed-viewfull-table-scan

Read More
Update using join on big table - performance tips?...


sqlpostgresqldatabase-performancedatabase-administration

Read More
Enabling CDC in SQL Server 2005 won't work?...


sqlsql-serveramazon-rdsdatabase-administration

Read More
BackNext