I'll try to answer you from what I think you are trying to ask. If you are asking if Oracle is the only place where incidents are stored. Answer No. Each detection server including the client the agent is on has an agent store, or an incident store. If there is ever a disconnect between any detection server or the enforce server and the oracle db, then incidents are stored on that server until the connection is available.
With the endpoint agent, you specify a default size of the store to be a % of the client disk space, default is 5%. Does that help?