2,122 questions
1
vote
1
answer
46
views
Decoding DBA_HIST_SQLBIND.value_string for the DATE type
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 ...
- 50.7k
0
votes
1
answer
272
views
Why do the pg_temp_### and pg_toast_temp_### schemas keep growing, and why are they not being dropped or released automatically?
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
85
views
Exact arrival time of a stored procedure on SQL Server
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 ...
- 1
0
votes
0
answers
209
views
Grafana: Variables Not Recognized in Query Results Despite Using Lowercase (ClickHouse)
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 ...
- 53
0
votes
0
answers
58
views
SQL SSRS ReportServer db DROP/Create Objects
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 ...
- 39
0
votes
0
answers
22
views
Postgres Statistics for Column Scans
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 ...
- 141
0
votes
1
answer
495
views
Unable to drop database link
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,&...
- 396
1
vote
1
answer
606
views
Azure SQL Managed Instance randomly freezes/locks up and must be Stopped/Restarted
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 ...
- 55
1
vote
0
answers
16
views
10090 TXN_OTHER_PRIVILEGE_EXISTS ERROR in GridDB – User/DB Administration Issue
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
108
views
How to have DBMS_STATS.GATHER_TABLE_STATS() Ignore a Virtual Column?
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 ...
- 550
1
vote
0
answers
35
views
Best Approach to Handle Unsharded Collections in a MongoDB Global Write Cluster?
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
248
views
PostgreSQL: User cannot see some tables in information_schema.tables despite permissions
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:
...
- 77
1
vote
0
answers
114
views
How to specify DBMS_AUTO_TASK_ADMIN.ENABLE's IMMEDIATE Option?
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 ...
- 550
1
vote
0
answers
60
views
Oracle Automated Maintenance Tasks (autotask): client_name vs. operation?
What is the difference in purpose between Oracle's Automated Maintenance Tasks (autotask) client_name and operation?
I am aware that they can be identified with DBA_AUTOTASK_CLIENT and ...
- 550
0
votes
0
answers
170
views
How can I get Redshift query execution time
I want to find out the total amount of time the queries are running in Redshift.
Is there any query with which I can get this information?.
I tried to get this data using stl_query but because there ...