Re: IORM and DBMS_FILE_TRANSFER

OK, just if anyone else stumbles on this, I've just done some playing around, and it seems to come under the resource group of the session making the DBMS_FILE_TRANSFER call.
Not what I was expecting, but I guess that's the advantage of testing these things out to confirm or refute ones assumptions. P

On 6 February 2018 at 17:29, Patrick Jolliffe <jolliffe_at_gmail.com> wrote:

> I'm sure this is a dumb question but here goes: (Exadata 12.1)
>
> If we are copying a file from ASM storage to the compute note local
> filesystem by calling DBMS_FILE_TRANSFER.COPY_FILE from within one of the
> databases, then which IORM resource group does this task come under?
> The database that's making the call? ASM? Another?
> Is this different behavior than if I copy the file using ASMCMD?
> The file in question is an archived redo log from RECO (if it matters).
> Any ideas about how I can determine this myself, either by experimenting,
> or reading some relevant documentation also appreciated.
> Thanks in advance
> Patrick
>
>

--
http://www.freelists.org/webpage/oracle-l