Oralce requires that you periodically gather statistics on the queries you are running. The following command will do that for your local schema. It can be run as the schema owner or sysdba
exec dbms_stats.gather_schema_stats(ownname=> '<schema name, upper case>', cascade => true)
