Thank you Jeremiah again :) I have the impression you work for amazon, my
opinion is the following:
I think you should have something like an Ask Tom, the reason because we
continued with Oracle, was because Tom really loved his work and
compromised in answering the question, in a time where some topics like
session_cached_cursors, statistics, etc. was not really clear.
We was in a hole where we couldn't solve performance problems (in oracle
9i) and he solved them, of course now the situation is completely different
in the database.
But thanks to him we stay in Oracle, most of the performance problems were
idiots problems, once we understand them, but in that time we really didn't
have a clue to solve them, and one of the reason was too the limitation of
oracle developer.
I'm going to share what I send to my chief, about my position aws, based on
the experience of sudden bugs we have and the way we need to test to fix
them. I'm not a real dba, I'm better than some dba and worst than others
I'm a developer-dba, but when there is a problem I must find a solution in
one or in other way, we couldn't se sr to oracle, so we need some freedom
to find fast solution; i.e. suddenly temporary tablespace starts to grows
and can't stop it; or a view can't compile and we need to see what can be
done, or one time every decade something weird happens.
-- The mail I sent:
The database compile, but there are many question in aws without answers,
in example about dblinks there are suggestion, but not a definitive solution
<https://forums.aws.amazon.com/message.jspa?messageID=476671>
https://forums.aws.amazon.com/message.jspa?messageID=476671
This says something we could see with ***
https://forums.aws.amazon.com/message.jspa?messageID=382386
"My problem was that I had one of the RDS instances set to be publicly
accessible and one was not. When I set them both to not be publicly
accessible, the link worked. It was based on the answer that Wanderley gave
about limitations on outbound connections. Almost 4 years later, but this
was the only thread that I found that was remotely close to my problem. I
hope it helps somebody. "
My impression based on what I had found in the aws forum is more like a
help between users, not is liek amazon has set of professional ready to
solve and see the customers are satisfied, is more like amazon made a
software and let their customer find a solution between them, and if they
don't they don't care.
I even found a comment from a user complaining that she didn't received
answer from the payed support.
The database that had been useful to upload files to imporat, doesn't works
to query, that means that the problem is not in the creation of the link.
In the other hand there are limitation , like you can't download files,
really I'm not sure if aws of amazon deserves the effort to migrate there,
and the only one reason is support.
if we don't have the sureness that we are going to receive an answer, and
without the option to take emergency tasks, I think the only one solution
will be to download the database to make it work locally.
But if the customer accepts that possibility that if there is some problem
they will have to download to a local serve, with all the implications it
has, maybe we coud do.
I strongly suggest to see other service out than amazon, that gives us more
control in emergies and bugs, that doesn't happens all the time, but
happens, and whtn they happens we must find the solution the fastest we can.
---
Hope be useful and thank you :)
Jeremiah
2017-09-22 17:45 GMT-04:00 Jeremiah Cetlin Wilton <jcwilton93@xxxxxxxxxxx>:
Hi Juan Carlos,
If you see something not answered on the forums, please let me know, and
I'll make sure someone addresses it. If you need to speak to someone on the
service team, I can help with that too.
I'm in the belly of the beast, and we're all old Oracle-heads here. We
don't want any customer unhappy.
For critical systems, you can see the response times here:
https://aws.amazon.com/premiumsupport/enterprise-support/
Are there any specific questions you need answered right away?
Regards,
Jeremiah
------------------------------
*From: *"Juan Carlos Reyes Pacheco" <jcdrpllist@xxxxxxxxx>
*To: *"Oracle Mailing List" <oracle-l@xxxxxxxxxxxxx>
*Sent: *Friday, September 22, 2017 2:09:37 PM
*Subject: *Is the AWS support for Oracle enough good?
I had been moving a database to aws amazon, and I found a lot of questions
without answers,
I expected something special
A very rpotected databases
and a real good support like asktom
But I see there are some questions not answers more than one year ago.
Some people says he had found after long time of research and shared that
knowledge.
I got the impression that is not really as good as it seems.
And in a emergency you are not going to receive the support as soon as you
need, or not enough qualified.
Or I'm wrong and is only my impression?
Thank you :)
