Monitoring tool

[leandrolinof]

Environment information:
* Oracle version: 10g
* Operating system: Win7

Good afternoon!

I would like to know if you know some Oracle Bank monitoring tool that shows the section, user and which table he is allocating on the bank.

I am waiting,

helps.

[diegolenhardt]

Enterprise Manager has all this information,

Views,

v $ session ev $ locked_object show you this too ...

99]] falows

[leandrolinof]

I forgot to talk, would have to be free ....

[diegopedrao]

OEM has this as Diego spoke and also has the paid as the spotlight I think is very good.

ATT,

Diego Monteiro

[leandrolinof]

Which version of Oracle Enterprise Manager that is free ???

Does 10G for Win 32 bits?

[diegolenhardt]

In 10g Enterprise Manager comes together, since in the creation of your bank you check the Enterprise Manager Repository option,

after that, EmcTL Start DBConsole and then
EmcTL Status DBConsole You will see the link to access in the browser,

is free yes,

There is a more complete version that is paid, but this free has a lot resource,

[leandrolinof]

Staff can not access the bank by Oracle Manager.

The ORA-12514 error: TNS: Listener has no knowledge about the service currently requested in the connection descriptor.

I do not know if I did something wrong ...

[diegopedrao]

See if the Listener service is started.

ATT,

Diego Monteiro

[leandrolinof]

Diego sorry for my ignorance but where do I check the Lister?

[diegolenhardt]

Start >> Run >> CMD
LSNRCTL Status
http://www.google.com.br/#hl=pt-BR&q=li ... deb6ac12e5

[RodrigoValentim]

Continuing the subject ... For these days I went through a problem that was the following.

We had an accelerated growth of Archives and the company that takes care of our bank was not able to really identify who was the villain ... So I thought about researching ... But I already did a lot thing and so far do not gain such information ... Is it possible via query, scripts or only in Manager? My user is DBA but I do not have access to the Enterprise ...

Does anyone know how I can get this information?

[diegolenhardt]

Interesting, I'll take a look if I find something,

if you have audit on the bank,. Through Audit_Trail, could make some counts by grouping by Object_ID, to try to see ...

Probably you no longer have the ulings, outreach Shape would be to read the ulites, maybe even with LogMNR, and then count, but I do not know how to know what is inside the archive,

if you find something put here, =]