How I obtains this information?

The company where work has one database that it is not managed internally, was passed the administration to great multi national with three letters only in the name, the problem is that this database was unavailable in last the two months 3 times and me was requested that raised the following information: in the dates where database was unavailable how much down time of this database had? Detail I do not have access to the alert(sid).ora.

How I obtains this information?
With one it prays for GOD?
Crying?
Cursing the Larry?
Saying with the Boss
that of the one not
to make?

When your company is not worrying about the DB, why should you bother?

Tamil

three letters

EDS, DMR or CSC?

Pando, You forgot the IBM, but is EDS.

Because it is my function to verify if to another company this correctly making everything....

Tell the great multinational to send you the alert logs for the database?

Quote:

---

Originally posted by hhbrazil
Because it is my function to verify if to another company this correctly making everything....

---

I love it. You outsource your DB operations to another company but you have to hire people to monitor the uptime. Let me know the company, I want to short their stock :D

Already I asked for a time and them they had not only played rock in me because they estvam working remotely. They speak that not necessary to know what has in alert therefore I have that to trust the administration of them.... BLA BLA BLA BLA.... Bulsheet (Besteira in portuguese). I know that they mask many things...

Quote:

---

Originally posted by slimdave
Tell the great multinational to send you the alert logs for the database?

---

Nah, they'll just edit out the shutdow/startup commands.

If this were me, I would make sure auditing is turned on and then I would audit the connect/disconnects. This would give me a database perspective of what is going on during all times.

Also, I would create a DDL trigger that would capture the shutdown/startup of the database so I have proof of when this beast was down.

I would also write a script that tried to connect to the database every X minutes and record when I couldn't connect.

Oh wait, I already do this, forget it.

I agree to you that it is a strange situation, but... OPS waits a litle was not I who made outsource, and I do not believe outsource, only complicates the things... Who enters finds the maximum and who inside you always leaves... And still has the problem of the information in the alerts that evaporate... and a detail of this, has a some companys here in the ones Brazil.. that they make you well worse orders to compile proceduress and they nor if give to the work to verify if other objects had not been invalid....

There ought to be some form of service level agreement document that states what you can get from them. Might be worth checking that to see what you can use it for.

I made this today, now to each 15 minutes, I, of a base that I created in mine machine, that it is a server NT, searched in all the 150 bases of the company which are answering un select instance from v$thread; therefore the competent one that it made outsource only left me with Grant of create session and select any table.....

That sounds like it would work ... are you just pinging each instance with a "SELECT COUNT(*) FROM DUAL;"

"There ought to be some form of service level agreement document that states what you can get from them. Might be worth checking that to see what you can use it for."
I know of this, we I have the SLAs here defined well, but who said that they fulfill, and if you find bad... Its head finds that you this being very hard...