Stack Overflow
Stack Overflow

Questions tagged [exadata]

Oracle Exadata is a database appliance with support for both OLTP (transactional) and OLAP (analytical) database systems.

Oracle Exadata is a database appliance with support for both OLTP (transactional) and OLAP (analytical) database systems.

It was initially designed in collaboration between Oracle Corporation and Hewlett Packard, where Oracle designed the database, operating system (based on the Oracle Linux distribution), and storage software whereas HP designed the hardware for it.

61 questions
0
votes
1 answer

Oracle Apex application and database

Can I run Oracle Apex application on window's server and connected database to linux server? More info, I want to run my oracle apex application on windows platform, and i want to have conected database on exadata on linux server. Is it possible to…
Yash Patel
  • 1
0
votes
0 answers

Evening_package is inconsistent in running

We have evening package that is scheduled to run during evening and usually completes by midnight. We recently migrated our Oracle ODA's to Exadata cloud and did containerization and oracle patching. After our database migration it stopped the next…
Khush11
  • 1
0
votes
0 answers

Data Connectivity and Performance

I have a Tableau Data Extract that refreshes on a schedule. Our Tableau Production Server is on-promise, and when I run this extract on the Tableau Production Server, it takes forever to finish. There is another server VM (let's call VM 'X') which…
Nikhil
  • 621
  • 1
  • 13
  • 25
0
votes
1 answer

The data returned by the query on the first run differs from the data on the second and subsequent runs

Yesterday the new oracle server was installed. DB was migrated to exadata. Query that before was working fine suddenly started to show different results for the first run and for subsequent runs. SELECT CASE WHEN…
kinderproc
  • 198
  • 3
  • 9
0
votes
1 answer

cross region oracle exadata active active cluster on OCI

Does Anybody have prior experience to set up Oracle Exadata Active-Active Cluster across OCI regions yet? If yes, can you share possible best practices and guiding principles if possible. The goal is to set up an Active-Active Oracle Exadata cluster…
Dhrubo
  • 705
  • 1
  • 14
  • 33
0
votes
2 answers

Oracle SQL: Check whether a set of variables uniquely identify observations in the table

I am trying to find out whether a set of columns uniquely identifies observations in a HUGE table using Oracle SQL. I am accessing an Orcacle Exadata platform through Python using cx_Oracle. Background: I am new to SQL (Oracle SQL) and my…
safex
  • 2,398
  • 17
  • 40
0
votes
0 answers

Oracle Exadata performance issue with simple select query

I am using Oracle Exadata cloud environment. I have a table which I am using to store raw data from excel import through an application. All the columns are VARCHAR2(100 CHAR). I have a simple select statement which returns all the records which are…
Jay
  • 408
  • 2
  • 6
  • 27
0
votes
0 answers

How to build a history table from multiple tables in Exadata Oracle?

We have multiple dimensional and fact tables in Exadata. The requirement is to perform CDC on certain attributes from these 5 different dimensional and fact tables. So basically, we will have to collate all the required attributes from 5 different…
Pramod Kalvala
  • 1
0
votes
0 answers

How to connect RobotFramework with Exadata DB?

i am trying to connect to an Exadata DB via Robot Framework with cx_Oracle component and not jdbc. My attempts fail miserably. The configuration i have used is the proper one, meaning username, pwd and host but the error message probably sent by Exa…
Efi
  • 1
0
votes
2 answers

How can we improve Insert and updates in Oracle Exadata?

Insert and update queries are taking long time as compared to select queries. Here are some stats for the table - Table is storing monthly data. For current month it is MTD. The data for current month is getting deleted and loaded every day.…
v83rahul
  • 283
  • 2
  • 7
  • 20
0
votes
1 answer

Oracle application - migration to Exadata server

We have an upcoming migration of our Oracle database to an Exadata server. I want to clarify some issues I have thought of: Will there be any issues with the code - performance issues? Exadata has another type of optimizer, it doesn’t uses…
Iulian
  • 15
  • 2
0
votes
1 answer

Exadata - Query with join between 2 databases

In Exadata, I have two different databases. Is it possible to perform a join between a table that is in database A, to a table that is in database B? On the standard Oracle database engine, I know this is not possible except via a db-link but I have…
Xire
  • 166
  • 7
0
votes
2 answers

Which are the useful metrics to monitor in a Oracle database

I am looking to monitor an Oracle database. Do you have an idea about the metrics useful that I have to monitor? Thank you in advance for your help.
Kohan95
  • 10,019
  • 5
  • 20
  • 21
0
votes
0 answers

does oracle capture ROWID of rows returned for SELECT statements being run on a table?

We have data in Oracle (Exadata) table identified by PK (say id). I have to figure out which users are accessing which rows in this Oracle table. I know that there is way to have Oracle capture information about "which users has accessed a table".…
rp1
  • 159
  • 2
  • 10
0
votes
1 answer

Oracle 12c - Table with size larger than 5 terabytes

In our database(Oracle 12c, Exadata) we plan to store sales data. Input text files containing sales data comes daily basis(~1000 files every day each containing ~20000 rows). Text files are read and transfered to db asap. Acccording to our…
fatihn
  • 137
  • 1
  • 8
1 2
3
4 5