Which indexes to choose for complex filtering?

Question

Oracle

There is a large table with the statuses of operations. The table has tens of millions of records. The table has many fields by which the user can filter data through the interface. For example, dates from/to, replication attribute (0 or 1), plugin ID (string), zone (string), creation mode (0 or 1), etc.
Date filter is required. No other fields. Multiple values ​​can be selected across fields such as a plugin, i.e. IN required. What are the best indexes to choose for such filters?

Answer 1

Moreover, a single request is executed in 500ms, but as soon as the request is run in several threads, the execution speed grows to, sometimes, two minutes.