Questions tagged [oracle-21c]
Oracle database version 21c. Please also tag [oracle] for search purposes.
10
questions
1
vote
0
answers
25
views
Possible explanation for why "SELECT" query executed from JDBC returning just the first row in the table
I installed OracleDB(XE - free version) and I tried to use it in Java. I have this code:
static final String DB_URL = "jdbc:oracle:thin:@localhost:1521/XE";
static final String ...
- 111
2
votes
1
answer
248
views
How to know how much memory is used by each DB user in the cache buffer?
Using this query:
SELECT
A.CACHE_BUFFER_TOTAL,
B.CACHE_BUFFER_USED,
A.CACHE_BUFFER_TOTAL - B.CACHE_BUFFER_USED AS CACHE_BUFFER_FREE
FROM
(SELECT BYTES / 1024 / 1024 ...
- 23
0
votes
0
answers
102
views
What’s wrong with provided apex instance administrator password
1
I have installed Oracle Database 21c Enterprise Edition on Oracle windows 10 I am now trying to install Apex 22.2 .
Got to the chapter "5.4.2.3 Running apxchpwd.sql" to set the instance ...
0
votes
1
answer
473
views
Connect to remote Oracle database from local SQL Developer client
I installed Oracle Linux 21c on the remote machine, tested it in Linux shell, and it worked as expected (I can query the testing table I created). But I am stuck when trying to connect to the database ...
- 3
0
votes
0
answers
934
views
Set lsnrctl on Oracle XE 21C to listener.ora in file
I installed Oracle XE 21C on an old laptop running Oracle Linux 8.6. I followed the official documentation without getting any errors. I am trying to set the lsnrctl to the one located in /opt/oracle/...
0
votes
1
answer
39
views
Oracle CACHE and STORAGE IN ROW behaviour
We have a Java Spring boot application that writes 20 million plus rows in a table with 2 blob columns in a batched manner into an Oracle 21c DB.
We are using JDBC batch insert for fast inserts.
...
- 101
0
votes
1
answer
1k
views
On Oracle 21c XE, what should ORACLE_HOME and TNS_ADMIN be set to?
In my Windows Oracle 21c XE installation I have the product installed under:
C:\Oracle\product\21c
Below that there is:
dbhomeXE
which contains the bin directory and also network.
However, I also ...
- 131
1
vote
2
answers
126
views
db<>fiddle (Oracle): Query works in 18c, but not 21c
I have a Oracle query that I use to analyze the vertices of SDO_GEOMETRY polylines:
WITH lines AS
(SELECT SDO_UTIL.FROM_WKTGEOMETRY('MULTILINESTRING ((0 5 0, 10 10 10, 30 0 33.54),(50 10 33.54, 60 10 ...
- 1,447
2
votes
1
answer
666
views
Return a resultset as JSON text—using pretty formatting
In Oracle 21c, it looks like we can return a resultset as JSON text:
SELECT json_object(*)
from dual;
result:
{"DUMMY":"X"}
That works in db<>fiddle:
Question:
Is there a ...
- 1,447
0
votes
1
answer
877
views
Does Oracle Database support nested transactions?
Does current version of Oracle Database (21c) support nested transactions?
I'm aware of Oracle DB supporting savepoints. However I'm looking for a way to make COMMINT not to write to disk for purpose ...
- 523