Skip to main content
Stack Overflow
  1. About
  3. For Teams
Filter by
Sorted by
Tagged with
-3 votes
0 answers
24 views

I am experiencing an issue with Azure SQL Managed Instance where some of the long-running queries in Query Store are displayed as "Restricted Text" instead of the actual query text. Details: ...
Advice
0 votes
3 replies
49 views

I was wondering if there is any privilege or work around that allows a read-only user I created on Oracle to see the DDL of procedure/view/function from third party apps like SQL Developer. Currently ...
1 vote
1 answer
59 views

I would like to decode DATE value written as varchar2 in DBA_HIST_SQLBIND, but unsure where to look for the mask required to decode it properly, SYS> select value_string from DBA_HIST_SQLBIND where ...
0 votes
1 answer
458 views

We've observed a significant number of temporary schemas with names like pg_temp_* and pg_toast_temp_* accumulating in both the Sandbox and Dev environments. Why do the pg_temp_### and pg_toast_temp_##...
0 votes
0 answers
96 views

I have a specific stored procedure that executes in a SQL Server in about 0.250 seconds, when executed from SQL Server Management Studio, although it takes half a minute to display the resulting ...
0 votes
0 answers
312 views

I'm using variables in Grafana queries with ClickHouse, but the variable ${var_name:raw} isn't recognized in the results. The query runs without errors, but no data shows up in the graph. Here’s the ...
0 votes
0 answers
58 views

I've enable DDL audits on few of our servers. The past two months I've seen a weird behavior on a server where we host our reportserver database. I'm seeing lots of drop procedures/view followed by ...
0 votes
0 answers
25 views

Where can I find statistics for specific table column scans? I have a very large table (near 10^9 rows) which has a few indexes however not on all fields. The non-indexed fields are mostly foreign ...
0 votes
1 answer
662 views

I have 2 database links that have the same db link name, but different service name. As sys dba, I try to drop the one with the wrong TNS info, but I keep getting the "database link not found,&...
1 vote
1 answer
744 views

I am a Developer who is also responsible for Database Administration at my company. We have several Microsoft SQL servers including one Azure Managed Instance SQL server. Recently and at random ...
1 vote
0 answers
16 views

I'm working with GridDB and attempting to create a new user and grant it privileges on a specific database. However, I keep encountering the following error: 10090 TXN_OTHER_PRIVILEGE_EXISTS ERROR ...
0 votes
0 answers
123 views

Is there a way to instruct dmbs_stats.gather_table_stats() to ignore a particular column? Context: I have a table that has a virtual column that performs a standard_hash() of the concatenation of ...
1 vote
0 answers
46 views

Thanks for taking the time to look into my issue. I currently have a MongoDB Atlas global write cluster with three region-specific shards in UK, US, and HK. The unsharded collections are located ...
0 votes
0 answers
300 views

I am encountering an issue in PostgreSQL where a specific user cannot see all the tables in information_schema.tables, even though all tables belong to the same database and schema. Context: ...
1 vote
0 answers
120 views

How does one specify the IMMEDIATE option when invoking the DBMS_AUTO_TASK_ADMIN.ENABLE() subprogram? For reference: Oracle 19 PL/SQL Packages and Types Reference Specifying the DEFERRED option ...

15 30 50 per page
1
2 3 4 5
...
142

AltStyle によって変換されたページ (->オリジナル) /