SQL unknown appearing on the bank

[natanjr]

Environmentally information:
. There are some as kind so

Select all

SELECT * FROM CARROS

only in my car table of a 50,000.00 record and a lot of things, in my system there is no nunhum select * from cars From where Oracle is taking this SQL and how to solve this problem ..

Thanks.

[Trevisolli]

Brother, beleza?

reached if there is no job being processing at the base?

You can consult ALL_JOBS.

Select all

 
SELECT * 
  FROM all_jobs; 

[natanjr]

I do not think so and the case because there are no Jobs in the registered bank.

I think it has to do with the execution plan that Oracle is choosing to run SQL

[ruevers]

I find it impossible not to exist this select, someone or some program runs this, sure ...

has to monitor the session and the SQL text to know who is doing this.

[natanjr]

Yes I already do this monitoring .... lasting the day appears several sql so

select * from table without WHERE I already made find in all my project and do not meet nada similar .... when monitoring It appears that the application that is running SQL and the dllhost.exe that I think would be the COM + that runs my application in the I do not have those type of SQL in the application.

Oracle could from dividing this select to execute Optimize Mode is already at cost ...

[gilbertoca]

Select * From table without WHERE I already did find all my project and do not meet anything like .... When monitoring appears that the application that is running SQL and DllHost.exe That I think it would be the COM + that runs my application in the I do not have these type of SQL in the application.

Check which user this SQL belongs to. Isolate it, preferably removes all permissions and then if necessary, grant them gradually.

Gilberto

[natanjr]

Yes I know that user is coming to SQL and the user of my system .. I do not understand what has to have his permissions with these select that appears in the bank.

[gilbertoca]

yes I know that user is coming the sql and the user of my system .. more I did not understand what has to have his permissions with these select that appears in the bank.

Now, if you are the problem, you can identify - granting them (permissions) in a gradual way - what is the source.

Gilberto

[natanjr]

Good for what I tested here there is no need for permissions.

I think it could be happening and that my SQL brings many records I'm going through the table index and the bank thinks the cost of going there is every record on the bank and bigger than bringing the table Everything and reading her ???
Complicated because I'm not a DBA I'm just a developer who's listening has Select * from cars running on the bench more on my system there is no this ..

[natanjr]

Someone has something to help me or has passed through anything

[eliasexner]

Exactly.

I have already passed through this and the bank generates SQL's that are not in the application if you do not have an index suitable for the query you are performing.

Try to parse if the index columns are being used in your filter.

In my case there was no appropriate index and after creating the same the problem is over.

vlw

[natanjr]

Thank you ... I knew that in so many companies that have Oracle only here this happened ... I'll do some test after put here t +