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
1
vote
2 answers

JDBC Driver & JDBC Connection string for Exadata

I have developed a code which connects to Oracle DB using the JDBC connection string oracle.jdbc.OracleDriver & respective jar for the same. However my customer moved to a different DB called 'Exadata' recently. My question is since they are from…
sreejith sasidharan
  • 11
  • 4
1
vote
0 answers

Using dbms_scheduler.create_credential on a exedata

I want to setup a file_watcher for file created in a location in the OS. We are currently using Jobs that access the files through utl_file.fopen to access the files using a directory entry. I ask my DBA to setup a credential so I can establish the…
Stephen Brower
  • 11
  • 1
1
vote
1 answer

Spring Boot Oracle Exadata | Connection Reset error

below is the application.properties file: spring.datasource.url=jdbc:oracle:thin:@asdf:1521/asdf spring.datasource.username=asdf spring.datasource.password=asdf spring.datasource.driver-class=oracle.jdbc.driver.OracleDriver I am getting below…
Guru
  • 2,739
  • 1
  • 25
  • 27
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
  • 802
  • 7
  • 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
  • 95
  • 11
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,918
  • 10
  • 53
  • 90
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
  • 303
  • 6
  • 20
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,818
  • 2
  • 22
  • 45
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
  • 259
  • 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

Oracle JDBC Clob insert issue ORA-00942

I am reading a set of fields from an Oracle source and insert retrieved data into another Oracle Source, when I attempt to insert into clob area, I happen to experience "java.sql.SQLException: ORA-00942: table or view does not exist" exception, all…
Tugrul ASLAN
  • 354
  • 1
  • 3
  • 16
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
  • 3,460
  • 6
  • 33
  • 55
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
  • 9
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
  • 33
  • 1
  • 1
  • 11
0
votes
1 answer

Oracle EXADATA Optimization

I am working on Oracle EXADATA data server with 52 CPU, but when I query a table with 9 million records on a full table scan with parallel hint of 128, the output of the query takes more than 20 minutes to fetch the data with no utilization in the…
Nivas S
  • 1
  • 1
1
2
3 4 5