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.

53 questions
1
vote
0 answers

Oracle Insert Performance

I insert data from external table to my table that is range partitioned and have two local indexes. My case, I have to insert records under 60 seconds for each flat file because new one comes. A flat file consists +5 M records and 2 GB.(volume :…
mehmet sahin
  • 782
  • 6
  • 21
1
vote
1 answer

oracle compression AVG_ROW_LEN

Im trying to calculate the size of the table(Exadata database table). I used the AVG_ROW_LEN from ALL_TAB_PARTITIONS and took Actual row count from table then did AVG_ROW_LEN * count(*). Our table is partitioned and sub-partitioned. (and…
Laks
  • 79
  • 8
1
vote
3 answers

to index or not in Oracle Exadata

I am new to Oracle Exadata. My question is, to Index or not to Index in Exadata? Found some of the blogs which says not to Index database Index and only to storage indexes which are temporary, but there are no official documentation from Oracle…
AKB
  • 5,714
  • 9
  • 47
  • 84
1
vote
1 answer

Optional Bind Variables to match against same field

Barriers: I can't CREATE anything. No GTT's, PROCs, etc. I'm querying an Exadata data lake and whatever script I create will be executed from Toad or SQL Developer. The platform is Oracle 11g. I'm creating a self-serve report that relies on two…
mf.cummings
  • 173
  • 3
  • 16
1
vote
3 answers

Performance optimization with EXISTS

I'm working on a DWH supplying script, that deal with ~40M lines on an Oracle Exadata server. I've got the following tables : CREATE TABLE P.ARCHIVED_ID ( ID_ARCHIVED VARCHAR2(31 BYTE) NOT NULL, -- CONSTRAINT UNIQUE / PRIMARY KEY IS_DELETE…
Blag
  • 5,394
  • 2
  • 18
  • 43
1
vote
1 answer

In Oracle Trace file, how to interpret multiple PARSE / EXEC / CLOSE for single cursor?

I'm trying to decipher some Oracle trace files and I'm unsure how to interpret multiple PARSE / EXEC / CLOSE statements for what looks like a single cursor. Something like the following: PARSING IN CURSOR #1 *statement* END OF STMT PARSE #1 BINDS…
Neil McF
  • 249
  • 1
  • 15
1
vote
0 answers

Getting error while loading data from Netsuite to Exadata throgh informatica

While loading data from Netsuite to exadata, I am getting following error for one table as below FnName: Fetch Optimize -- [NetSuite][ODBC 64 bit driver]Error in row. FnName: Fetch Optimize -- [NetSuite][ODBC 64 bit driver][OpenAccess SDK SQL…
Amogh
  • 11
  • 2
1
vote
1 answer

Running Chef cookbooks on ExaData

I am trying to run a Chef Cookbook on an ExaData server and I'm running into issues. I was able to bootstrap my ExaData servers. However when I run chef-client on the target nodes, I get an error like this. Then I went back and did a verbose output…
FilBot3
  • 2,773
  • 5
  • 23
  • 45
1
vote
1 answer

Oracle Exalogic/Exadata Performance tracker

Recently we have migrated our application to Oracle Engineered Systems- EXALOGIC and EXADATA. Performance of our application since then is appreciable. However we would like to benchmark the performance of our application on Exalogic stack. It will…
Avinash KP
  • 67
  • 8
1
vote
1 answer

Oracle Exadata Error: CellCli not Found Error

I am trying to run cellcli on my one of the Exadata Cell Server. When I login to the Server, I am able to see all the files as expected. (Like: all_group all_nodelist_group cell_group all_ib_group etc) When I issue command to start…
Piyush
  • 35
  • 1
  • 1
  • 11
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
  • 108
  • 7
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
  • 634
  • 11
  • 29
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
  • 1,441
  • 7
  • 21
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
  • 344
  • 5
  • 17
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
1
2
3 4