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

Concatenate field from multiple rows into single 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. I have a SELECT query that returns 3 rows: Date IDKey EVENT for each Date,…
mf.cummings
  • 303
  • 6
  • 20
0
votes
1 answer

Need SQL with date chain logic

I want to write a SQL (not a procedure but SQL) to produce the output as in table t2 from table t1. This is needed to do some data validation between between table t1 and t2. I want to extract the data from table t1 based on this logic and want to…
aakash
  • 11
  • 1
0
votes
1 answer

Oracle/ExaData RowNum Range returns duplicate rows

I am executing this query on exadata in a for loop of a java program select a, b, c, d from ( select rownum r, a, b, c, d from foo order by c asc ) where r >= 40001 and r < 50001 Here i keep incrementing the numbers by 10000, so in the next…
Knows Not Much
  • 30,395
  • 60
  • 197
  • 373
0
votes
2 answers

Delete 1Bn records from a oracle warehouse table

I have a huge table created from another table by someone and want to delete it. I do not have truncate/drop table right. What would be the best solution. it is in oracle. Right now i plan to give a simple Delete * from table
kten
  • 445
  • 4
  • 13
  • 26
0
votes
0 answers

How does partitioning is generated on oracle Exadata?

I want to know how oracle created it because i want to be able to have all month partition in single TBS for back-up purposes ,example of partition name oracle automatically generated is 'SYS_P321847'
Ayman Alnsery
  • 5
  • 1
0
votes
0 answers

Teradata to Oracle migration Primary Keys and Indexes

I am moving from Teradata to Oracle and I have a question regarding Primary Keys and Indexes in the DDLs. Here are several scenarios and what I am doing: 1) In Teradata there is: Primary Key("X","Y") then in Exadata I use: constraint "PK" PRIMARY…
Simon Harper
  • 1
  • 4
0
votes
3 answers

Increase speed of Oracle query running on ExaData

I am working on an Oracle query and I badly need to make it go faster. I would greatly appreciate any advice. The database is Oracle, running on an ExaData cluster. Oracle version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 -…
Steve
  • 541
  • 7
  • 12
0
votes
1 answer

Query creates different execution plan from app server than toad

Just to preface, I've seen a dozen similar SO Q/As and they appear to be a bit different (different server, different parameters etc). Basic problem Here's my question, we're running a select statement from the web server against our exadata 11g…
Kingpin2k
  • 47,277
  • 10
  • 78
  • 96
0
votes
1 answer

oracle exadata processing after reading from disk

I'm trying to figure out where the data gets processed in an Oracle Exadata system after the data is pulled off of the disk. From my understanding, when you run a query, the data(rows) has to get fetched from disk, but where is it putting this data…
lightweight
  • 3,227
  • 14
  • 79
  • 142
0
votes
1 answer

Oracle Exadata - Compressing subpartition for query high and pctfree

How to compress only few subpartitions in partition, with FOR QUERY HIGH and PCTFREE option My statement looks this: alter table table_name move subpartition subpartition_name PCTFREE 10 compress for query high; And this errors occurs after…
Cugar
  • 79
  • 1
  • 3
  • 14
-1
votes
1 answer

What is the correct way of counting every column by itself in Oracle

I have a table which has several columns. Except customer column, I want to count them all by themselves. I need to see how many transactions done on "value1" by "customer:100" in segment "1". Which is in this scenario at the bottom, answer is…
süleyman
  • 93
  • 10
-1
votes
1 answer

How to migrate from Oracle Exadata X4-2 database to BigQuery?

What are the migration considerations that should be taken? Is it better to have a new data model prepared beforehand fo BigQuery? Or move the data As-Is data model to bigquery first and then change the data model Any key considerations to make Any…
BabaYaga
  • 1
  • 1
-1
votes
1 answer

Oracle EXAData 19c - Shared pool memory utilization is not going down even no process are running

Using Oracle Exadata 19c for RDS database. We are running numerous queries from java application and also calling many stored procedures. We identified that as the number of processes/sessions are increasing , shared memory pool utilization is…
upadhyayRakes
  • 152
  • 1
  • 2
  • 9
-1
votes
1 answer

Execute a DB query every 30 mins in the database

As part of my job I have to periodically check for failed items in the database. I have the query with me. Instead of manually executing the query every now and then I want to execute it in a predefined interval automatically and capture those items…
Nawin SS
  • 9
  • 1
  • 6
-1
votes
1 answer

Issue accessing external exadata database from docker

I am having a problem accessing external exadata database from docker. Docker File: FROM centos:7.3.1611 WORKDIR /tmp ADD . /tmp ENV http_proxy= ENV https_proxy= ENV RHEL_FRONTEND=noninteractive ENV…
TJJ
  • 31
  • 1
  • 7
1 2 3
4
5