2
votes
1answer
111 views

Does Windows Server File Compression slow Oracle DB performance?

I'm starting a new a new contract and I get to troubleshoot their Oracle instance... I'm more apps and sql, but I'll be trying to figure out their crashes and slow performance. Go figure. I can ...
1
vote
1answer
274 views

Alter table move taking long time

I'm currently trying to compress a table in Oracle with the following statements: ALTER TABLE MYTABLE COMPRESS FOR OLTP; ALTER TABLE MOVE; My question is: the MOVE operation is taking forever and ...
1
vote
1answer
269 views

Which Database to choose: MySQL or Oracle

I have an application generating time series data (32 channels, 22KHz, 6 secs) once a minute. These have to be stored in a database. At the moment I'm using MySQL with InnoDB tables ...
1
vote
1answer
110 views

Oracle SecureFile Compression

Where can I read database compression properties after the creation of an oracle database / tables? Is there a special view where the info is stored and can be retieved?