Good day to all, help to figure out what is happening with the database, when prompted:

select sum (number) from energy where datetime between to_date ('7.03.17 9:00:00','d.mm.yy hh24:mi:ss') and to_date ('7.03.17 9:01:00','d.mm.yy hh24:mi:ss')

The time is from 7 to 15 seconds, but this is not the end, when you try to restart the database with the commands shutdown normal - the command just hangs and nothing happens, once the truth stopped but did not start after reporting the ora-27100 error. Restarting the server solved the problem for a maximum of 30 minutes. Thank you all for your help.

  • Are you saying that Oracle agreed to a SUM () query without GROUP BY? - Akina
  • one
    1. From the information it is unclear how many rows should be sampled - maybe from millions. It is unclear whether there is an index on the datetime column. 2. Shutdown, he also waits for shutdown normal until all current sessions are disconnected. 3. GROUP BY, of course, is not needed, if only analytical / group functions as a result of the sample. - hinotf
  • @hinotf 1 - for a period of 1 minute, it should upload 60 values, that is, a record in the database every second. 2- no index. How to stop the database immediately? - Ethernets
  • one
    Try creating an index. Shutdown immediate breaks all sessions and stops the database. Here read docs.oracle.com/cd/B28359_01/server.111/b28310/… - hinotf
  • @hinotf created an index time reduced by 2 seconds. In another database, I have 2 seconds of waiting for the year of unloading. What could be the problem? - Ethernets

0