2,123 questions
Advice
0
votes
3
replies
46
views
Permission to view the body of a procedure/view/function from a read-only user on Oracle Database
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 ...
- 67
1
vote
1
answer
53
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
416
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
94
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
280
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
24
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
627
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
712
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
119
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
46
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
288
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
120
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
62
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
190
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 ...
0
votes
1
answer
34
views
is there any way to combine below update statements
I am looking for best way to combine these 2 update statements or at least if first failes, is there a best way to report 2nd update as well failure instead of blindly running and completing of 2nd ...
- 1
0
votes
1
answer
84
views
How do I give a postgreSQL user read-only permissions on all schemata programmatically?
In a multi-tenanted application, each customer's data is stored in a separate schema of a postgreSQL database.
I want to grant certain permissions (read-only in my case, but I don't think that's ...
- 1,336
0
votes
1
answer
57
views
Is identical token range mandatory for snapshot restore using refresh in Cassandra?
According to the documentation, when restoring data using the refresh method, both the source and destination clusters must have the same token ranges; otherwise, it can cause issues.
Is this ...
0
votes
1
answer
69
views
Restored snapshot, seeing zero rows in the tables after restart or repair
I’m encountering an issue during snapshot restoration in Cassandra.
Scenario:
Backup taken from: 3-node cluster (A)
Restored on: 3-node cluster (B)
After successfully restoring the snapshot, the ...
-1
votes
2
answers
179
views
Postgres settings to maximize compute resources for a single local connection [closed]
I have a local PG instance populated with 10's of millions of rows of data and need to run some relatively complex queries for some data analysis work.
These queries are currently taking 10+ minutes ...
- 12.4k
2
votes
0
answers
28
views
Why am I getting a "TXN_ERROR_NOT_EXIST ERROR" in GridDB when performing a user or database administration operation?
I'm working with GridDB for managing a distributed database system and recently encountered the following error while trying to perform a user or database administration operation:
10086 ...
0
votes
1
answer
87
views
My oracle 12c database trace only shows parameter names - how do I see actual parameter values?
I have a database that is already designed. I made a tracer in order to read the queries that I have run from application against the database, the queries are logging to the trace file but there is a ...
2
votes
1
answer
56
views
Oracle LogMiner reconstructs Extended String value incorrectly
I have an Oracle EE 19.3 environment setup where MAX_STRING_SIZE is set to EXTENDED, supporting up to 32k length strings. In this environment, I have two very simplistic tables
CREATE TABLE test_a (id ...
- 21.3k
0
votes
1
answer
78
views
Is my TEMP tablespaces monitoring correct? [closed]
I've developed this TEMP tablespaces Monitor via DBLINKS in ORACLE it sends an email if any temp tablespace reaches any percentage called by v_used:
CREATE OR REPLACE PROCEDURE SP_TEMP_MON(
v_used ...
- 27
0
votes
0
answers
44
views
Postgres query duration peaks
We have docker containers (12) running on-prem machines, one of them is a postgres DB, on the same query we sometimes get peaks of 30+ seconds for a query that most of the time takes 2 seconds.
The ...
- 1,722
0
votes
1
answer
118
views
At MariaDB database suddenly huge number of bin log file generated
I found almost 13830 update rows found like below in each bin logs files. But there are only a few update queries at each log.
This command shows only 85 update query
mysqlbinlog mysql-bin.005400 | ...
0
votes
0
answers
25
views
1:Many join question for condensing the many set by a value and ordering it [duplicate]
Trying to write a query to join to tables 1:Many and order by the date column descending so we only get a 1:1 record, with the latest many record sorted by date.
Table 1
Id
Name
Table 2
Id
Value
Id, ...
- 191
0
votes
1
answer
120
views
Trouble with only read user in Postgresql
I have a cluster where running around 20 postgres databases. I need to create read only user for every db.
On this server i have service user e.g. service_user that do automaticly all operations in ...
- 1
0
votes
2
answers
331
views
How to Determine the Low High Water Mark (LHWM) in Oracle DB? [closed]
How could one determine the position of the Low High Water Mark (LHWM) for a non-partitioned heap table segment in Oracle?
Note: Using Locally Managed Tablespaces (LMT) and Automatic Segment Space ...
- 550
0
votes
1
answer
93
views
export & import database [closed]
I need to export and import database from the old user to the new user through oracle apex or another Methode, how I can do that with detail please
I tried to make export database via cmd file, but I ...
- 1
-1
votes
2
answers
1k
views
Can't drop role due to dependencies
I'm new to Postgres, and I want to delete a role named rp_ts04, but it complains about dependencies. I don't know how to check for these dependencies.
I've checked information_schema but it doesn't ...
- 511
0
votes
1
answer
371
views
oracle TEMP usage after "set current_session"
In my DB I have:
USER_1 with default temp ts TEMP_1;
USER_2 with default temp ts TEMP_2.
USER_1 issues "alter session set current_schema = USER_2". After that the USER_1's queries in that ...
- 1
1
vote
0
answers
70
views
How does Forced Parameterization impact queries when using SET options such as quoted identifier?
When using Simple Parameterization in the AdventureWorks database, you can execute the following query:
USE [AdventureWorks2022]
GO
SET QUOTED_IDENTIFIER OFF
SELECT "True" FROM Person....
- 11
0
votes
1
answer
218
views
Non-clustered index bigger than clustered index in SQL Server
I have a question regarding an issue I am having.
I have a table that has 2 indexes - a clustered index and one non-clustered index.
The clustered index key column is of type INT
The non-clustered is ...
- 1
0
votes
0
answers
62
views
Execute a stored procedure for a list of values using while loop from a query resultset in SQL Server 2008 R2
I am trying to execute a stored procedure for the list of values from a query using a while loop but the while loop is taking forever to complete.
CREATE PROCEDURE ItemsToBeCleared
@BatchDays INT
...
- 37
0
votes
1
answer
156
views
Oracle Database pfile parameter value discrepancy
I generated a pfile from the spfile of my Oracle database and noticed that some parameters appear twice in it with different values.
For example:
MYDBNAME.__shared_pool_size=16642998272 #which means ...
- 3
0
votes
1
answer
1k
views
Is it safe to drop a partition just after detaching it concurrently?
I am trying to automate partition management on my psql (version 15) DB.
I would like to delete old partitions to free some space in the db. To do so, i plan to detach it using CONCURRENTLY keyword so ...
- 13
0
votes
1
answer
165
views
How use KeyCloak to assign access to once record of application database table based on postgres?
I have two DB.
KeyCloak DB which stores users, realm, roles and other info of AuthServer.
Application DB which swores data of my application (for example, list of notes, posts and so on).
My ...
0
votes
1
answer
330
views
Moving LOB size more than actual size [closed]
SELECT BYTES/ (1024*1024*1024) GB
FROM DBA_SEGMENTS D
JOIN DBA_LOBS L ON L.SEGMENT_NAME = D.SEGMENT_NAME
WHERE D.OWNER = 'SCHEMA_NAME' AND SEGMENT_NAME = 'MY_LOB'
GB
100
Actual LOB object size = 100 ...
- 51
0
votes
1
answer
984
views
import dump in oracle database
I need to import a dump-file into an Oracle Database.
I set myself up with a test VM and installed the latest Oracle Database 21c Express Edition and used:
impdp system/123 directory=C:/dump dumpfile=...
- 103
0
votes
0
answers
72
views
Create a one computer/one user relationship to permissions on a database
Backstory: We have an app that connects to a SQL Server database using a clients app on a user's PC. We got the app working through normal channels (whitelisting machine IP, creating a login for the ...
-3
votes
1
answer
228
views
Grant Alter to Only to All Functions on SQL Server [closed]
Need help to GRANT ALTER only to all the SQL Server Functions.
Below is mycode:
GRANT ALTER ON FUNCTION::dbo TO [username]
- 27
0
votes
1
answer
736
views
Oracle database Undo size not clearing after the dml operation
Trying to understand the Undo size behaviour . I ran below query initially and noted down the values . Actual undo is 2500 , undo retention 900 and needed Undo size was 430 . Then I performed stress ...
0
votes
0
answers
70
views
How to create specific user security for schemas?
I am a Junior DBA trying to figure out how to add specific security to specific accounts.
So we have a database that allows analysts to create their own tables/views and mess around with data in with ...
- 9
-1
votes
1
answer
340
views
How to change the password for all Oracle database users?
Oracle database 19c is used for development and testing purposes only.
All users (including sys, system and all others created by default during installation) have the same password.
For example, ...
- 197
0
votes
2
answers
2k
views
OS User on Oracle DBA History views
We need to monitor all SQL-s coming from a certain Application Server to an Oracle DB.
For this, we are running the following query:
SELECT
h.sample_time,
u.username,
h.program,
h.module,
...
- 375
2
votes
0
answers
436
views
How Oracle calculates the db block changes segment metric?
This week I came across an interesting point. It was necessary to calculate in which segments of the database the greatest changes were occurring. I first accessed view dba_hist_seg_stat. However, I ...
2
votes
2
answers
103
views
Is there a way to update 2 values each time calculating data on each row?
I have the following table:
CREATE TABLE IF NOT EXISTS import.dre
(
idmov integer,
companynumber integer,
idproduct integer,
dtdate date,
nrtank integer,
dailybalance numeric,
...
0
votes
1
answer
194
views
Views Creation Permissions without table Creation Permissions in POSTGRESQL
I have a use case where I want to create a user which should have access on select for public schema and Views Creation On public schema but not table creation User can create a new view but not table
...
- 5