Enterprise Manager Application Data Modelling question

[p***@westnet.com.au]

Yes, I know, it’s unlike me to be asking a question on EM instead
of answering one. 😊

This is one I’ve never seen before.  I’ve been setting up Data
Masking for a customer and we have a couple of different ADMs. 
Previously, the Referential Relationships screen showed no records, as
the referential integrity is not defined in the database (not ideal,
but that's how it is).  But now the screen is completely blank - no
buttons, no screen saying no records found, nothing.  Anyone seen
anything like that before?  Restarting the OMS didn't have any
impact.  Logged an SR, but no response on it yet and the customer
really wants to see some progress so trying all avenues to move this
forward.

EM 13.2 vanilla.

Thanks

Pete

[Chris Taylor]

Is the licensing option for data masking enabled?

seems a likely culprit but I can't remember where you navigate to in OEM to
view the options (and select) the ones you're licensed for.

Chris

Yes, I know, it’s unlike me to be asking a question on EM instead of
answering one. 😊
This is one I’ve never seen before. I’ve been setting up Data Masking
for a customer and we have a couple of different ADMs. Previously, the
Referential Relationships screen showed no records, as the referential
integrity is not defined in the database (not ideal, but that's how it
is). But now the screen is completely blank - no buttons, no screen saying
no records found, nothing. Anyone seen anything like that before?
Restarting the OMS didn't have any impact. Logged an SR, but no response
on it yet and the customer really wants to see some progress so trying all
avenues to move this forward.
EM 13.2 vanilla.
Thanks
Pete

[Tim Gorman]

In the end, all products are EOL, but some are closer to EOL than others.

With masking options from Informatica, IBM, Delphix, Red Gate, Dataveil,
and others to choose from, each of which mask data across most all
relational database platforms, as well as documents, it seems
short-sighted to invest licensing money, time, and effort on masking one
island of information within Oracle one way, and masking all other
database platforms using other methods.  Because all confidential data
in non-prod needs to be masked, not just Oracle.

Full disclosure: I work for Delphix, and we do data masking at-rest
across almost all databases and documents, including mainframe.

In the past 4+ years, I have only once come up against data masking
using the Oracle EM pack.  This company disliked their experiences
masking with the Oracle pack because it generated complex SQL and PL/SQL
to perform the masking within the database engine.  Masking algorithms
are computationally intensive (i.e. encryption, hashing,
list-processing, etc) and thus difficult to optimize in generated SQL
and PL/SQL, performing poorly as they chew up CPU expensively licensed
for database.  When you charge as much as Oracle does based on CPU, you
don't want that CPU doing anything but database workload.

By contrast, each and all of the other data masking packages retrieve
arrays of rows to an appserver, mask them in the appserver (typically a
generic Linux server), then either insert them forward or update them
back using ROWID, less reliance on the Oracle optimizer, and employing
less expensive CPU for the computationally-intense masking workload,
conserving the expensive database licensed CPUs for database workload.

So when your customers regroup to mask across the enterprise instead of
an island of Oracle, any of these masking vendors will be happy to solve
that.  Especially down under, on that super big island y'all have...  :)

Yes, I know, it’s unlike me to be asking a question on EM instead of
answering one. 😊
This is one I’ve never seen before.I’ve been setting up Data Masking
for a customer and we have a couple of different ADMs.  Previously,
the Referential Relationships screen showed no records, as the
referential integrity is not defined in the database (not ideal, but
that's how it is).  But now the screen is completely blank - no
buttons, no screen saying no records found, nothing. Anyone seen
anything like that before?  Restarting the OMS didn't have any
impact.  Logged an SR, but no response on it yet and the customer
really wants to see some progress so trying all avenues to move this
forward.
EM 13.2 vanilla.
Thanks
Pete

[p***@westnet.com.au]

It's off Setup -> Management Packs -> Management Pack Access, but yes,
it is enabled.  This screen did show information just a couple of
days ago, which is what confuses me most.  And since I'm the only one
that uses the environment, I can say with confidence that nothing
changed in the configuration etc since that time. :)
Pete

----- Original Message -----
From: ***@gmail.com
To:
Cc:"ORACLE-L"
Sent:Tue, 13 Nov 2018 18:23:49 -0500
Subject:Re: Enterprise Manager Application Data Modelling question

Is the licensing option for data masking enabled?
seems a likely culprit but I can't remember where you navigate to in
OEM to view the options (and select) the ones you're licensed for.
Chris

On Tue, Nov 13, 2018, 5:38 PM

Links:
------
[1] mailto:***@westnet.com.au

[p***@westnet.com.au]

Looking at other options is not on the table, Tim.
I make no comment about EOL for EM. :(
Pete

----- Original Message -----
From: ***@gmail.com
To:,
Cc:
Sent:Tue, 13 Nov 2018 15:56:05 -0800
Subject:Re: Enterprise Manager Application Data Modelling question

In the end, all products are EOL, but some are closer to EOL than
others.

With masking options from Informatica, IBM, Delphix, Red Gate,
Dataveil, and others to choose from, each of which mask data across
most all relational database platforms, as well as documents, it seems
short-sighted to invest licensing money, time, and effort on masking
one island of information within Oracle one way, and masking all other
database platforms using other methods.  Because all confidential
data in non-prod needs to be masked, not just Oracle.

Full disclosure: I work for Delphix, and we do data masking at-rest
across almost all databases and documents, including mainframe.

In the past 4+ years, I have only once come up against data masking
using the Oracle EM pack.  This company disliked their experiences
masking with the Oracle pack because it generated complex SQL and
PL/SQL to perform the masking within the database engine.  Masking
algorithms are computationally intensive (i.e. encryption, hashing,
list-processing, etc) and thus difficult to optimize in generated SQL
and PL/SQL, performing poorly as they chew up CPU expensively licensed
for database.  When you charge as much as Oracle does based on CPU,
you don't want that CPU doing anything but database workload.

By contrast, each and all of the other data masking packages retrieve
arrays of rows to an appserver, mask them in the appserver (typically
a generic Linux server), then either insert them forward or update
them back using ROWID, less reliance on the Oracle optimizer, and
employing less expensive CPU for the computationally-intense masking
workload, conserving the expensive database licensed CPUs for database
workload.

So when your customers regroup to mask across the enterprise instead
of an island of Oracle, any of these masking vendors will be happy to
solve that.  Especially down under, on that super big island y'all
have...  :)

On 11/13/18 14:36, ***@westnet.com.au [1] wrote:

Yes, I know, it’s unlike me to be asking a question on EM instead
of answering one. 😊

This is one I’ve never seen before.  I’ve been setting up Data
Masking for a customer and we have a couple of different ADMs. 
Previously, the Referential Relationships screen showed no records, as
the referential integrity is not defined in the database (not ideal,
but that's how it is).  But now the screen is completely blank - no
buttons, no screen saying no records found, nothing.  Anyone seen
anything like that before?  Restarting the OMS didn't have any
impact.  Logged an SR, but no response on it yet and the customer
really wants to see some progress so trying all avenues to move this
forward.

EM 13.2 vanilla.

Thanks

Pete



Links:
------
[1] mailto:***@westnet.com.au

[Chris Stephens]

this is the second oracle-l thread where the future of EM has been
questioned. is the product going away in the future? will it be replaced by
something else for shops that run their own databases?

Post by p***@westnet.com.au
Looking at other options is not on the table, Tim.
I make no comment about EOL for EM. :(
Pete
----- Original Message -----
Tue, 13 Nov 2018 15:56:05 -0800
Re: Enterprise Manager Application Data Modelling question
In the end, all products are EOL, but some are closer to EOL than others.
With masking options from Informatica, IBM, Delphix, Red Gate, Dataveil,
and others to choose from, each of which mask data across most all
relational database platforms, as well as documents, it seems short-sighted
to invest licensing money, time, and effort on masking one island of
information within Oracle one way, and masking all other database platforms
using other methods. Because all confidential data in non-prod needs to be
masked, not just Oracle.
Full disclosure: I work for Delphix, and we do data masking at-rest across
almost all databases and documents, including mainframe.
In the past 4+ years, I have only once come up against data masking using
the Oracle EM pack. This company disliked their experiences masking with
the Oracle pack because it generated complex SQL and PL/SQL to perform the
masking within the database engine. Masking algorithms are computationally
intensive (i.e. encryption, hashing, list-processing, etc) and thus
difficult to optimize in generated SQL and PL/SQL, performing poorly as
they chew up CPU expensively licensed for database. When you charge as
much as Oracle does based on CPU, you don't want that CPU doing anything
but database workload.
By contrast, each and all of the other data masking packages retrieve
arrays of rows to an appserver, mask them in the appserver (typically a
generic Linux server), then either insert them forward or update them back
using ROWID, less reliance on the Oracle optimizer, and employing less
expensive CPU for the computationally-intense masking workload, conserving
the expensive database licensed CPUs for database workload.
So when your customers regroup to mask across the enterprise instead of an
island of Oracle, any of these masking vendors will be happy to solve
that. Especially down under, on that super big island y'all have... :)
Yes, I know, it’s unlike me to be asking a question on EM instead of
answering one. 😊
This is one I’ve never seen before. I’ve been setting up Data Masking
for a customer and we have a couple of different ADMs. Previously, the
Referential Relationships screen showed no records, as the referential
integrity is not defined in the database (not ideal, but that's how it
is). But now the screen is completely blank - no buttons, no screen saying
no records found, nothing. Anyone seen anything like that before?
Restarting the OMS didn't have any impact. Logged an SR, but no response
on it yet and the customer really wants to see some progress so trying all
avenues to move this forward.
EM 13.2 vanilla.
Thanks
Pete

[Courtney Llamas]

Pete stop spreading vicious rumors ;)      EM is not going anywhere, just not the focus for Cloud deployments.  Folks with on-premises db’s can use either OEM or OMC, or a combination of the two.   

 

Send me the SR and I’ll have someone look into it ;)

 
--
- Courtney

http://www.oracle.com/
Courtney Llamas | Architect
Phone [phone] | Mobile: HYPERLINK "tel:[phone]"[phone]
Oracle Strategic Customer Program

Oracle

http://www.oracle.com/commitment

Oracle is committed to developing practices and products that help protect the environment

 

From: Chris Stephens <***@gmail.com>
Sent: Wednesday, November 14, 2018 8:50 AM
To: ***@westnet.com.au
Cc: Tim Gorman <***@gmail.com>; oracle-l <oracle-***@freelists.org>
Subject: Re: Enterprise Manager Application Data Modelling question

 

this is the second oracle-l thread where the future of EM has been questioned. is the product going away in the future? will it be replaced by something else for shops that run their own databases?

 

 

On Tue, Nov 13, 2018 at 6:03 PM <HYPERLINK "mailto:***@westnet.com.au"***@westnet.com.au> wrote:

Looking at other options is not on the table, Tim.

 

I make no comment about EOL for EM. :(

 

Pete

 


----- Original Message -----

From:

HYPERLINK "mailto:***@gmail.com"***@gmail.com

 

To:

<HYPERLINK "mailto:***@westnet.com.au"***@westnet.com.au>, <HYPERLINK "mailto:oracle-***@freelists.org"oracle-***@freelists.org>

Cc:

 

Sent:

Tue, 13 Nov 2018 15:56:05 -0800

Subject:

Re: Enterprise Manager Application Data Modelling question


In the end, all products are EOL, but some are closer to EOL than others.

With masking options from Informatica, IBM, Delphix, Red Gate, Dataveil, and others to choose from, each of which mask data across most all relational database platforms, as well as documents, it seems short-sighted to invest licensing money, time, and effort on masking one island of information within Oracle one way, and masking all other database platforms using other methods.  Because all confidential data in non-prod needs to be masked, not just Oracle.

Full disclosure: I work for Delphix, and we do data masking at-rest across almost all databases and documents, including mainframe.

In the past 4+ years, I have only once come up against data masking using the Oracle EM pack.  This company disliked their experiences masking with the Oracle pack because it generated complex SQL and PL/SQL to perform the masking within the database engine.  Masking algorithms are computationally intensive (i.e. encryption, hashing, list-processing, etc) and thus difficult to optimize in generated SQL and PL/SQL, performing poorly as they chew up CPU expensively licensed for database.  When you charge as much as Oracle does based on CPU, you don't want that CPU doing anything but database workload.

By contrast, each and all of the other data masking packages retrieve arrays of rows to an appserver, mask them in the appserver (typically a generic Linux server), then either insert them forward or update them back using ROWID, less reliance on the Oracle optimizer, and employing less expensive CPU for the computationally-intense masking workload, conserving the expensive database licensed CPUs for database workload.

So when your customers regroup to mask across the enterprise instead of an island of Oracle, any of these masking vendors will be happy to solve that.  Especially down under, on that super big island y'all have...  :)




On 11/13/18 14:36, HYPERLINK "mailto:***@westnet.com.au"***@westnet.com.au wrote:

Yes, I know, it’s unlike me to be asking a question on EM instead of answering one. 😊

This is one I’ve never seen before.  I’ve been setting up Data Masking for a customer and we have a couple of different ADMs.  Previously, the Referential Relationships screen showed no records, as the referential integrity is not defined in the database (not ideal, but that's how it is).  But now the screen is completely blank - no buttons, no screen saying no records found, nothing.  Anyone seen anything like that before?  Restarting the OMS didn't have any impact.  Logged an SR, but no response on it yet and the customer really wants to see some progress so trying all avenues to move this forward.

EM 13.2 vanilla.

Thanks

Pete

 

[l***@bluewin.ch]

You might be correct, but Pete has 100 days grace period ...
----UrsprÃŒngliche Nachricht----
Von : ***@oracle.com
Datum : 14/11/2018 - 15:55 (MN)
An : ***@gmail.com, ***@westnet.com.au
Cc : ***@gmail.com, oracle-***@freelists.org
Betreff : RE: Enterprise Manager Application Data Modelling question
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
Pete stop spreading vicious rumors ;) EM is not going anywhere, just not the focus for Cloud deployments. Folks with on-premises db’s can use either OEM or OMC, or a combination of the two.

Send me the SR and I’ll have someone look into it ;)
--
- Courtney
Courtney Llamas | Architect
Phone [phone] | Mobile: [phone]
Oracle Strategic Customer Program
Oracle
Oracle is committed to developing practices and products that help protect the environment

From: Chris Stephens <***@gmail.com>
Sent: Wednesday, November 14, 2018 8:50 AM
To: ***@westnet.com.au
Cc: Tim Gorman <***@gmail.com>; oracle-l <oracle-***@freelists.org>
Subject: Re: Enterprise Manager Application Data Modelling question

this is the second oracle-l thread where the future of EM has been questioned. is the product going away in the future? will it be replaced by something else for shops that run their own databases?


On Tue, Nov 13, 2018 at 6:03 PM <***@westnet.com.au> wrote:
Looking at other options is not on the table, Tim.

I make no comment about EOL for EM. :(

Pete

----- Original Message -----
From:
***@gmail.com

To:
<***@westnet.com.au>, <oracle-***@freelists.org>
Cc:

Sent:
Tue, 13 Nov 2018 15:56:05 -0800
Subject:
Re: Enterprise Manager Application Data Modelling question
In the end, all products are EOL, but some are closer to EOL than others.
With masking options from Informatica, IBM, Delphix, Red Gate, Dataveil, and others to choose from, each of which mask data across most all relational database platforms, as well as documents, it seems short-sighted to invest licensing money, time, and effort on masking one island of information within Oracle one way, and masking all other database platforms using other methods. Because all confidential data in non-prod needs to be masked, not just Oracle.
Full disclosure: I work for Delphix, and we do data masking at-rest across almost all databases and documents, including mainframe.
In the past 4+ years, I have only once come up against data masking using the Oracle EM pack. This company disliked their experiences masking with the Oracle pack because it generated complex SQL and PL/SQL to perform the masking within the database engine. Masking algorithms are computationally intensive (i.e. encryption, hashing, list-processing, etc) and thus difficult to optimize in generated SQL and PL/SQL, performing poorly as they chew up CPU expensively licensed for database. When you charge as much as Oracle does based on CPU, you don't want that CPU doing anything but database workload.
By contrast, each and all of the other data masking packages retrieve arrays of rows to an appserver, mask them in the appserver (typically a generic Linux server), then either insert them forward or update them back using ROWID, less reliance on the Oracle optimizer, and employing less expensive CPU for the computationally-intense masking workload, conserving the expensive database licensed CPUs for database workload.
So when your customers regroup to mask across the enterprise instead of an island of Oracle, any of these masking vendors will be happy to solve that. Especially down under, on that super big island y'all have... :)
On 11/13/18 14:36, ***@westnet.com.au wrote:
Yes, I know, it’s unlike me to be asking a question on EM instead of answering one. 😊
This is one I’ve never seen before. I’ve been setting up Data Masking for a customer and we have a couple of different ADMs. Previously, the Referential Relationships screen showed no records, as the referential integrity is not defined in the database (not ideal, but that's how it is). But now the screen is completely blank - no buttons, no screen saying no records found, nothing. Anyone seen anything like that before? Restarting the OMS didn't have any impact. Logged an SR, but no response on it yet and the customer really wants to see some progress so trying all avenues to move this forward.
EM 13.2 vanilla.
Thanks
Pete

[Tim Gorman]

Courtney,

Thank you so much for your carefully written response, but the statement
"EM is not going anywhere" has many facets.

I think what is being asked (and to which we accept that you cannot and
should not respond in this forum) is that nobody should be expecting
future releases of EM.

Thanks!

-Tim

Post by Courtney Llamas
Pete stop spreading vicious rumors ;)      EM is not going anywhere,
just not the focus for Cloud deployments.  Folks with on-premises db’s
can use either OEM or OMC, or a combination of the two.
Send me the SR and I’ll have someone look into it ;)
--
- Courtney
Oracle <http://www.oracle.com/>
Courtney Llamas | Architect
Phone _+7133742102_| Mobile: [phone] <tel:[phone]>
OracleStrategic Customer Program
Oracle
Green Oracle <http://www.oracle.com/commitment>
Oracle is committed to developing practices and products that help protect the environment
*Sent:* Wednesday, November 14, 2018 8:50 AM
*Subject:* Re: Enterprise Manager Application Data Modelling question
this is the second oracle-l thread where the future of EM has been
questioned. is the product going away in the future? will it be
replaced by something else for shops that run their own databases?
Looking at other options is not on the table, Tim.
I make no comment about EOL for EM. :(
Pete
----- Original Message -----
*From:*
*To:*
*Cc:*
*Sent:*
Tue, 13 Nov 2018 15:56:05 -0800
*Subject:*
Re: Enterprise Manager Application Data Modelling question
In the end, all products are EOL, but some are closer to EOL than others.
With masking options from Informatica, IBM, Delphix, Red Gate,
Dataveil, and others to choose from, each of which mask data
across most all relational database platforms, as well as
documents, it seems short-sighted to invest licensing money,
time, and effort on masking one island of information within
Oracle one way, and masking all other database platforms using
other methods.  Because all confidential data in non-prod
needs to be masked, not just Oracle.
Full disclosure: I work for Delphix, and we do data masking
at-rest across almost all databases and documents, including
mainframe.
In the past 4+ years, I have only once come up against data
masking using the Oracle EM pack.  This company disliked their
experiences masking with the Oracle pack because it generated
complex SQL and PL/SQL to perform the masking within the
database engine.  Masking algorithms are computationally
intensive (i.e. encryption, hashing, list-processing, etc) and
thus difficult to optimize in generated SQL and PL/SQL,
performing poorly as they chew up CPU expensively licensed for
database. When you charge as much as Oracle does based on CPU,
you don't want that CPU doing anything but database workload.
By contrast, each and all of the other data masking packages
retrieve arrays of rows to an appserver, mask them in the
appserver (typically a generic Linux server), then either
insert them forward or update them back using ROWID, less
reliance on the Oracle optimizer, and employing less expensive
CPU for the computationally-intense masking workload,
conserving the expensive database licensed CPUs for database workload.
So when your customers regroup to mask across the enterprise
instead of an island of Oracle, any of these masking vendors
will be happy to solve that. Especially down under, on that
super big island y'all have...  :)
Yes, I know, it’s unlike me to be asking a question on EM
instead of answering one. 😊
This is one I’ve never seen before.  I’ve been setting up
Data Masking for a customer and we have a couple of
different ADMs. Previously, the Referential Relationships
screen showed no records, as the referential integrity is
not defined in the database (not ideal, but that's how it
is).  But now the screen is completely blank - no buttons,
no screen saying no records found, nothing.  Anyone seen
anything like that before?  Restarting the OMS didn't have
any impact.  Logged an SR, but no response on it yet and
the customer really wants to see some progress so trying
all avenues to move this forward.
EM 13.2 vanilla.
Thanks
Pete

[Courtney Llamas]

You’re right, I can’t guarantee future releases of anything, because that’s not my role.  We all know that’s Larry’s job.   However, 13.3 was just released in July so as you know, development has some time to push out a new version before anybody should start speculating.   

https://blogs.oracle.com/managementcloud/rtm-announcement-for-oracle-enterprise-manager-cloud-control-13c-release-3-13300

 

 

 
--
- Courtney

http://www.oracle.com/
Courtney Llamas | Consulting Member of Technical Staff
Phone: HYPERLINK "tel:[phone]"[phone] | Mobile: HYPERLINK "tel:[phone]"[phone]
Oracle Strategic Customer Program

Oracle

http://www.oracle.com/commitment

Oracle is committed to developing practices and products that help protect the environment

 

From: Tim Gorman <***@gmail.com>
Sent: Wednesday, November 14, 2018 9:29 AM
To: Courtney Llamas <***@oracle.com>; ***@gmail.com; ***@westnet.com.au
Cc: oracle-l <oracle-***@freelists.org>
Subject: Re: Enterprise Manager Application Data Modelling question

 

Courtney,

Thank you so much for your carefully written response, but the statement "EM is not going anywhere" has many facets.

I think what is being asked (and to which we accept that you cannot and should not respond in this forum) is that nobody should be expecting future releases of EM.

Thanks!

-Tim




On 11/14/18 06:55, Courtney Llamas wrote:

Pete stop spreading vicious rumors ;)      EM is not going anywhere, just not the focus for Cloud deployments.  Folks with on-premises db’s can use either OEM or OMC, or a combination of the two.   

 

Send me the SR and I’ll have someone look into it ;)

 
--
- Courtney

http://www.oracle.com/
Courtney Llamas | Architect
Phone [phone] | Mobile: HYPERLINK "tel:[phone]"[phone]
Oracle Strategic Customer Program

Oracle

http://www.oracle.com/commitment

Oracle is committed to developing practices and products that help protect the environment

 

From: Chris Stephens HYPERLINK "mailto:***@gmail.com"<***@gmail.com>
Sent: Wednesday, November 14, 2018 8:50 AM
To: HYPERLINK "mailto:***@westnet.com.au"***@westnet.com.au
Cc: Tim Gorman HYPERLINK "mailto:***@gmail.com"<***@gmail.com>; oracle-l HYPERLINK "mailto:oracle-***@freelists.org"<oracle-***@freelists.org>
Subject: Re: Enterprise Manager Application Data Modelling question

 

this is the second oracle-l thread where the future of EM has been questioned. is the product going away in the future? will it be replaced by something else for shops that run their own databases?

 

 

On Tue, Nov 13, 2018 at 6:03 PM <HYPERLINK "mailto:***@westnet.com.au"***@westnet.com.au> wrote:

Looking at other options is not on the table, Tim.

 

I make no comment about EOL for EM. :(

 

Pete

 


----- Original Message -----

From:

HYPERLINK "mailto:***@gmail.com"***@gmail.com

 

To:

<HYPERLINK "mailto:***@westnet.com.au"***@westnet.com.au>, <HYPERLINK "mailto:oracle-***@freelists.org"oracle-***@freelists.org>

Cc:

 

Sent:

Tue, 13 Nov 2018 15:56:05 -0800

Subject:

Re: Enterprise Manager Application Data Modelling question


In the end, all products are EOL, but some are closer to EOL than others.

With masking options from Informatica, IBM, Delphix, Red Gate, Dataveil, and others to choose from, each of which mask data across most all relational database platforms, as well as documents, it seems short-sighted to invest licensing money, time, and effort on masking one island of information within Oracle one way, and masking all other database platforms using other methods.  Because all confidential data in non-prod needs to be masked, not just Oracle.

Full disclosure: I work for Delphix, and we do data masking at-rest across almost all databases and documents, including mainframe.

In the past 4+ years, I have only once come up against data masking using the Oracle EM pack.  This company disliked their experiences masking with the Oracle pack because it generated complex SQL and PL/SQL to perform the masking within the database engine.  Masking algorithms are computationally intensive (i.e. encryption, hashing, list-processing, etc) and thus difficult to optimize in generated SQL and PL/SQL, performing poorly as they chew up CPU expensively licensed for database.  When you charge as much as Oracle does based on CPU, you don't want that CPU doing anything but database workload.

By contrast, each and all of the other data masking packages retrieve arrays of rows to an appserver, mask them in the appserver (typically a generic Linux server), then either insert them forward or update them back using ROWID, less reliance on the Oracle optimizer, and employing less expensive CPU for the computationally-intense masking workload, conserving the expensive database licensed CPUs for database workload.

So when your customers regroup to mask across the enterprise instead of an island of Oracle, any of these masking vendors will be happy to solve that.  Especially down under, on that super big island y'all have...  :)





On 11/13/18 14:36, HYPERLINK "mailto:***@westnet.com.au"***@westnet.com.au wrote:

Yes, I know, it’s unlike me to be asking a question on EM instead of answering one. 😊

This is one I’ve never seen before.  I’ve been setting up Data Masking for a customer and we have a couple of different ADMs.  Previously, the Referential Relationships screen showed no records, as the referential integrity is not defined in the database (not ideal, but that's how it is).  But now the screen is completely blank - no buttons, no screen saying no records found, nothing.  Anyone seen anything like that before?  Restarting the OMS didn't have any impact.  Logged an SR, but no response on it yet and the customer really wants to see some progress so trying all avenues to move this forward.

EM 13.2 vanilla.

Thanks

Pete

 

 

[n***@gmail.com]

There was a new release in July this year!

I get that the positioning from Oracle is unclear, but that seems a
stretch, especially as there's no sign of the management cloud acquiring
complete db management capabilities on-premises for example

Post by Tim Gorman
Courtney,
Thank you so much for your carefully written response, but the statement
"EM is not going anywhere" has many facets.
I think what is being asked (and to which we accept that you cannot and
should not respond in this forum) is that nobody should be expecting future
releases of EM.
Thanks!
-Tim
Pete stop spreading vicious rumors ;) EM is not going anywhere, just
not the focus for Cloud deployments. Folks with on-premises db’s can use
either OEM or OMC, or a combination of the two.
Send me the SR and I’ll have someone look into it ;)
--
- Courtney
[image: Oracle] <http://www.oracle.com/>
Courtney Llamas | Architect
Phone *[phone]* | Mobile: [phone]
Oracle Strategic Customer Program
Oracle
[image: Green Oracle] <http://www.oracle.com/commitment>
Oracle is committed to developing practices and products that help protect the environment
*Sent:* Wednesday, November 14, 2018 8:50 AM
*Subject:* Re: Enterprise Manager Application Data Modelling question
this is the second oracle-l thread where the future of EM has been
questioned. is the product going away in the future? will it be replaced by
something else for shops that run their own databases?
Looking at other options is not on the table, Tim.
I make no comment about EOL for EM. :(
Pete
----- Original Message -----
*From:*
*To:*
*Cc:*
*Sent:*
Tue, 13 Nov 2018 15:56:05 -0800
*Subject:*
Re: Enterprise Manager Application Data Modelling question
In the end, all products are EOL, but some are closer to EOL than others.
With masking options from Informatica, IBM, Delphix, Red Gate, Dataveil,
and others to choose from, each of which mask data across most all
relational database platforms, as well as documents, it seems short-sighted
to invest licensing money, time, and effort on masking one island of
information within Oracle one way, and masking all other database platforms
using other methods. Because all confidential data in non-prod needs to be
masked, not just Oracle.
Full disclosure: I work for Delphix, and we do data masking at-rest across
almost all databases and documents, including mainframe.
In the past 4+ years, I have only once come up against data masking using
the Oracle EM pack. This company disliked their experiences masking with
the Oracle pack because it generated complex SQL and PL/SQL to perform the
masking within the database engine. Masking algorithms are computationally
intensive (i.e. encryption, hashing, list-processing, etc) and thus
difficult to optimize in generated SQL and PL/SQL, performing poorly as
they chew up CPU expensively licensed for database. When you charge as
much as Oracle does based on CPU, you don't want that CPU doing anything
but database workload.
By contrast, each and all of the other data masking packages retrieve
arrays of rows to an appserver, mask them in the appserver (typically a
generic Linux server), then either insert them forward or update them back
using ROWID, less reliance on the Oracle optimizer, and employing less
expensive CPU for the computationally-intense masking workload, conserving
the expensive database licensed CPUs for database workload.
So when your customers regroup to mask across the enterprise instead of an
island of Oracle, any of these masking vendors will be happy to solve
that. Especially down under, on that super big island y'all have... :)
Yes, I know, it’s unlike me to be asking a question on EM instead of
answering one. 😊
This is one I’ve never seen before. I’ve been setting up Data Masking for
a customer and we have a couple of different ADMs. Previously, the
Referential Relationships screen showed no records, as the referential
integrity is not defined in the database (not ideal, but that's how it
is). But now the screen is completely blank - no buttons, no screen saying
no records found, nothing. Anyone seen anything like that before?
Restarting the OMS didn't have any impact. Logged an SR, but no response
on it yet and the customer really wants to see some progress so trying all
avenues to move this forward.
EM 13.2 vanilla.
Thanks
Pete

[Tim Gorman]

I recall Larry responding to an audience question several OOW's ago: 
"Are you planning to buy the San Francisco 49ers (US football team)?" 
Larry paused, leaned forward to the microphone, and responded, "In order
to be buyer, there has to be a seller".

In order for there to be a new release, there has to be a development team.

Post by n***@gmail.com
There was a new release in July this year!
I get that the positioning from Oracle is unclear, but that seems a
stretch, especially as there's no sign of the management cloud
acquiring complete db management capabilities on-premises for example
Courtney,
Thank you so much for your carefully written response, but the
statement "EM is not going anywhere" has many facets.
I think what is being asked (and to which we accept that you
cannot and should not respond in this forum) is that nobody should
be expecting future releases of EM.
Thanks!
-Tim

Post by Courtney Llamas
Pete stop spreading vicious rumors ;)      EM is not going
anywhere, just not the focus for Cloud deployments.  Folks with
on-premises db’s can use either OEM or OMC, or a combination of
the two.
Send me the SR and I’ll have someone look into it ;)
--
- Courtney
Oracle <http://www.oracle.com/>
Courtney Llamas | Architect
Phone _+7133742102_| Mobile: [phone] <tel:[phone]>
OracleStrategic Customer Program
Oracle
Green Oracle <http://www.oracle.com/commitment>
Oracle is committed to developing practices and products that
help protect the environment
*Sent:* Wednesday, November 14, 2018 8:50 AM
*Subject:* Re: Enterprise Manager Application Data Modelling question
this is the second oracle-l thread where the future of EM has
been questioned. is the product going away in the future? will it
be replaced by something else for shops that run their own databases?
Looking at other options is not on the table, Tim.
I make no comment about EOL for EM. :(
Pete
----- Original Message -----
*From:*
*To:*
*Cc:*
*Sent:*
Tue, 13 Nov 2018 15:56:05 -0800
*Subject:*
Re: Enterprise Manager Application Data Modelling question
In the end, all products are EOL, but some are closer to
EOL than others.
With masking options from Informatica, IBM, Delphix, Red
Gate, Dataveil, and others to choose from, each of which
mask data across most all relational database platforms,
as well as documents, it seems short-sighted to invest
licensing money, time, and effort on masking one island
of information within Oracle one way, and masking all
other database platforms using other methods. Because all
confidential data in non-prod needs to be masked, not
just Oracle.
Full disclosure: I work for Delphix, and we do data
masking at-rest across almost all databases and
documents, including mainframe.
In the past 4+ years, I have only once come up against
data masking using the Oracle EM pack.  This company
disliked their experiences masking with the Oracle pack
because it generated complex SQL and PL/SQL to perform
the masking within the database engine.  Masking
algorithms are computationally intensive (i.e.
encryption, hashing, list-processing, etc) and thus
difficult to optimize in generated SQL and PL/SQL,
performing poorly as they chew up CPU expensively
licensed for database.  When you charge as much as Oracle
does based on CPU, you don't want that CPU doing anything
but database workload.
By contrast, each and all of the other data masking
packages retrieve arrays of rows to an appserver, mask
them in the appserver (typically a generic Linux server),
then either insert them forward or update them back using
ROWID, less reliance on the Oracle optimizer, and
employing less expensive CPU for the
computationally-intense masking workload, conserving the
expensive database licensed CPUs for database workload.
So when your customers regroup to mask across the
enterprise instead of an island of Oracle, any of these
masking vendors will be happy to solve that.  Especially
down under, on that super big island y'all have...  :)
Yes, I know, it’s unlike me to be asking a question
on EM instead of answering one. 😊
This is one I’ve never seen before.  I’ve been
setting up Data Masking for a customer and we have a
couple of different ADMs.  Previously, the
Referential Relationships screen showed no records,
as the referential integrity is not defined in the
database (not ideal, but that's how it is).  But now
the screen is completely blank - no buttons, no
screen saying no records found, nothing. Anyone seen
anything like that before? Restarting the OMS didn't
have any impact.  Logged an SR, but no response on it
yet and the customer really wants to see some
progress so trying all avenues to move this forward.
EM 13.2 vanilla.
Thanks
Pete

--
Niall Litchfield
Oracle DBA
http://www.orawin.info

[Jeff Chirco]

Wait did I miss some news update? Are you saying that there is currently
not a development team for Enterprise Manager? I use EM Cloud Control 13c
for my on-prem databases.

I recall Larry responding to an audience question several OOW's ago: "Are
you planning to buy the San Francisco 49ers (US football team)?" Larry
paused, leaned forward to the microphone, and responded, "In order to be
buyer, there has to be a seller".
In order for there to be a new release, there has to be a development team.
There was a new release in July this year!
I get that the positioning from Oracle is unclear, but that seems a
stretch, especially as there's no sign of the management cloud acquiring
complete db management capabilities on-premises for example

Post by Tim Gorman
Courtney,
Thank you so much for your carefully written response, but the statement
"EM is not going anywhere" has many facets.
I think what is being asked (and to which we accept that you cannot and
should not respond in this forum) is that nobody should be expecting future
releases of EM.
Thanks!
-Tim
Pete stop spreading vicious rumors ;) EM is not going anywhere, just
not the focus for Cloud deployments. Folks with on-premises db’s can use
either OEM or OMC, or a combination of the two.
Send me the SR and I’ll have someone look into it ;)
--
- Courtney
[image: Oracle] <http://www.oracle.com/>
Courtney Llamas | Architect
Phone *[phone]* | Mobile: [phone]
Oracle Strategic Customer Program
Oracle
[image: Green Oracle] <http://www.oracle.com/commitment>
Oracle is committed to developing practices and products that help
protect the environment
*Sent:* Wednesday, November 14, 2018 8:50 AM
*Subject:* Re: Enterprise Manager Application Data Modelling question
this is the second oracle-l thread where the future of EM has been
questioned. is the product going away in the future? will it be replaced by
something else for shops that run their own databases?
Looking at other options is not on the table, Tim.
I make no comment about EOL for EM. :(
Pete
----- Original Message -----
*From:*
*To:*
*Cc:*
*Sent:*
Tue, 13 Nov 2018 15:56:05 -0800
*Subject:*
Re: Enterprise Manager Application Data Modelling question
In the end, all products are EOL, but some are closer to EOL than others.
With masking options from Informatica, IBM, Delphix, Red Gate, Dataveil,
and others to choose from, each of which mask data across most all
relational database platforms, as well as documents, it seems short-sighted
to invest licensing money, time, and effort on masking one island of
information within Oracle one way, and masking all other database platforms
using other methods. Because all confidential data in non-prod needs to be
masked, not just Oracle.
Full disclosure: I work for Delphix, and we do data masking at-rest
across almost all databases and documents, including mainframe.
In the past 4+ years, I have only once come up against data masking using
the Oracle EM pack. This company disliked their experiences masking with
the Oracle pack because it generated complex SQL and PL/SQL to perform the
masking within the database engine. Masking algorithms are computationally
intensive (i.e. encryption, hashing, list-processing, etc) and thus
difficult to optimize in generated SQL and PL/SQL, performing poorly as
they chew up CPU expensively licensed for database. When you charge as
much as Oracle does based on CPU, you don't want that CPU doing anything
but database workload.
By contrast, each and all of the other data masking packages retrieve
arrays of rows to an appserver, mask them in the appserver (typically a
generic Linux server), then either insert them forward or update them back
using ROWID, less reliance on the Oracle optimizer, and employing less
expensive CPU for the computationally-intense masking workload, conserving
the expensive database licensed CPUs for database workload.
So when your customers regroup to mask across the enterprise instead of
an island of Oracle, any of these masking vendors will be happy to solve
that. Especially down under, on that super big island y'all have... :)
Yes, I know, it’s unlike me to be asking a question on EM instead of
answering one. 😊
This is one I’ve never seen before. I’ve been setting up Data Masking
for a customer and we have a couple of different ADMs. Previously, the
Referential Relationships screen showed no records, as the referential
integrity is not defined in the database (not ideal, but that's how it
is). But now the screen is completely blank - no buttons, no screen saying
no records found, nothing. Anyone seen anything like that before?
Restarting the OMS didn't have any impact. Logged an SR, but no response
on it yet and the customer really wants to see some progress so trying all
avenues to move this forward.
EM 13.2 vanilla.
Thanks
Pete

--
Niall Litchfield
Oracle DBA
http://www.orawin.info

[Courtney Llamas]

Jeff – that is inaccurate.   Again, speculation and rumors.   

 

Please contact me offline if you have any concerns.   I’m not entertaining this discussion any longer on the mail list.  

 
--
- Courtney

http://www.oracle.com/
Courtney Llamas | Consulting Member of Technical Staff
Phone: HYPERLINK "tel:[phone]"[phone] | Mobile: HYPERLINK "tel:[phone]"[phone]
Oracle Strategic Customer Program

Oracle

http://www.oracle.com/commitment

Oracle is committed to developing practices and products that help protect the environment

 

From: Jeff Chirco <***@gmail.com>
Sent: Wednesday, November 14, 2018 4:36 PM
To: Tim Gorman <***@gmail.com>
Cc: Niall Litchfield <***@gmail.com>; Courtney Llamas <***@oracle.com>; Chris Stephens <***@gmail.com>; ***@westnet.com.au; oracle-l-freelist <oracle-***@freelists.org>
Subject: Re: Enterprise Manager Application Data Modelling question

 

Wait did I miss some news update?  Are you saying that there is currently not a development team for Enterprise Manager?  I use EM Cloud Control 13c for my on-prem databases.

 

On Wed, Nov 14, 2018 at 9:51 AM Tim Gorman <HYPERLINK "mailto:***@gmail.com"***@gmail.com> wrote:

I recall Larry responding to an audience question several OOW's ago:  "Are you planning to buy the San Francisco 49ers (US football team)?"  Larry paused, leaned forward to the microphone, and responded, "In order to be buyer, there has to be a seller".

In order for there to be a new release, there has to be a development team.




On 11/14/18 08:32, HYPERLINK "mailto:***@gmail.com"***@gmail.com wrote:

There was a new release in July this year! 

 

I get that the positioning from Oracle is unclear, but that seems a stretch, especially as there's no sign of the management cloud acquiring complete db management capabilities on-premises for example

 

 

On Wed, Nov 14, 2018 at 3:30 PM Tim Gorman <HYPERLINK "mailto:***@gmail.com"***@gmail.com> wrote:

Courtney,

Thank you so much for your carefully written response, but the statement "EM is not going anywhere" has many facets.

I think what is being asked (and to which we accept that you cannot and should not respond in this forum) is that nobody should be expecting future releases of EM.

Thanks!

-Tim




On 11/14/18 06:55, Courtney Llamas wrote:

Pete stop spreading vicious rumors ;)      EM is not going anywhere, just not the focus for Cloud deployments.  Folks with on-premises db’s can use either OEM or OMC, or a combination of the two.   

 

Send me the SR and I’ll have someone look into it ;)

 
--
- Courtney

HYPERLINK "http://www.oracle.com/"
Courtney Llamas | Architect
Phone [phone] | Mobile: [phone]
Oracle Strategic Customer Program

Oracle

http://www.oracle.com/

HYPERLINK "http://www.oracle.com/"Oracle is committed to developing practices and products that help protect the environment

HYPERLINK "http://www.oracle.com/" 

HYPERLINK "http://www.oracle.com/"From: Chris Stephens <***@gmail.com>
Sent: Wednesday, November 14, 2018 8:50 AM
To: ***@westnet.com.au
Cc: Tim Gorman <***@gmail.com>; oracle-l <oracle-***@freelists.org>
Subject: Re: Enterprise Manager Application Data Modelling question

HYPERLINK "http://www.oracle.com/" 

HYPERLINK "http://www.oracle.com/"this is the second oracle-l thread where the future of EM has been questioned. is the product going away in the future? will it be replaced by something else for shops that run their own databases?

HYPERLINK "http://www.oracle.com/" 

HYPERLINK "http://www.oracle.com/" 

HYPERLINK "http://www.oracle.com/"On Tue, Nov 13, 2018 at 6:03 PM <***@westnet.com.au> wrote:

HYPERLINK "http://www.oracle.com/"Looking at other options is not on the table, Tim.

HYPERLINK "http://www.oracle.com/" 

HYPERLINK "http://www.oracle.com/"I make no comment about EOL for EM. :(

HYPERLINK "http://www.oracle.com/" 

HYPERLINK "http://www.oracle.com/"Pete

HYPERLINK "http://www.oracle.com/" 

HYPERLINK "http://www.oracle.com/"
----- Original Message -----

HYPERLINK "http://www.oracle.com/"From:

HYPERLINK "http://www.oracle.com/"***@gmail.com

HYPERLINK "http://www.oracle.com/" 

HYPERLINK "http://www.oracle.com/"To:

HYPERLINK "http://www.oracle.com/"<***@westnet.com.au>, <oracle-***@freelists.org>

HYPERLINK "http://www.oracle.com/"Cc:

HYPERLINK "http://www.oracle.com/" 

HYPERLINK "http://www.oracle.com/"Sent:

HYPERLINK "http://www.oracle.com/"Tue, 13 Nov 2018 15:56:05 -0800

HYPERLINK "http://www.oracle.com/"Subject:

HYPERLINK "http://www.oracle.com/"Re: Enterprise Manager Application Data Modelling question


In the end, all products are EOL, but some are closer to EOL than others.

With masking options from Informatica, IBM, Delphix, Red Gate, Dataveil, and others to choose from, each of which mask data across most all relational database platforms, as well as documents, it seems short-sighted to invest licensing money, time, and effort on masking one island of information within Oracle one way, and masking all other database platforms using other methods.  Because all confidential data in non-prod needs to be masked, not just Oracle.

Full disclosure: I work for Delphix, and we do data masking at-rest across almost all databases and documents, including mainframe.

In the past 4+ years, I have only once come up against data masking using the Oracle EM pack.  This company disliked their experiences masking with the Oracle pack because it generated complex SQL and PL/SQL to perform the masking within the database engine.  Masking algorithms are computationally intensive (i.e. encryption, hashing, list-processing, etc) and thus difficult to optimize in generated SQL and PL/SQL, performing poorly as they chew up CPU expensively licensed for database.  When you charge as much as Oracle does based on CPU, you don't want that CPU doing anything but database workload.

By contrast, each and all of the other data masking packages retrieve arrays of rows to an appserver, mask them in the appserver (typically a generic Linux server), then either insert them forward or update them back using ROWID, less reliance on the Oracle optimizer, and employing less expensive CPU for the computationally-intense masking workload, conserving the expensive database licensed CPUs for database workload.

So when your customers regroup to mask across the enterprise instead of an island of Oracle, any of these masking vendors will be happy to solve that.  Especially down under, on that super big island y'all have...  :)



HYPERLINK "http://www.oracle.com/"On 11/13/18 14:36, ***@westnet.com.au wrote:

HYPERLINK "http://www.oracle.com/"Yes, I know, it’s unlike me to be asking a question on EM instead of answering one. 😊

HYPERLINK "http://www.oracle.com/"This is one I’ve never seen before.  I’ve been setting up Data Masking for a customer and we have a couple of different ADMs.  Previously, the Referential Relationships screen showed no records, as the referential integrity is not defined in the database (not ideal, but that's how it is).  But now the screen is completely blank - no buttons, no screen saying no records found, nothing.  Anyone seen anything like that before?  Restarting the OMS didn't have any impact.  Logged an SR, but no response on it yet and the customer really wants to see some progress so trying all avenues to move this forward.

HYPERLINK "http://www.oracle.com/"EM 13.2 vanilla.

HYPERLINK "http://www.oracle.com/"Thanks

HYPERLINK "http://www.oracle.com/"Pete

HYPERLINK "http://www.oracle.com/" 

HYPERLINK "http://www.oracle.com/" 

HYPERLINK "http://www.oracle.com/"


HYPERLINK "http://www.oracle.com/" 

HYPERLINK "http://www.oracle.com/"--

HYPERLINK "http://www.oracle.com/"Niall Litchfield
Oracle DBA
http://www.orawin.info

HYPERLINK "http://www.oracle.com/" 

[Jeff Chirco]

Cool thanks.

Jeff – that is inaccurate. Again, speculation and rumors.
Please contact me offline if you have any concerns. I’m not entertaining
this discussion any longer on the mail list.
--
- Courtney
[image: Oracle] <http://www.oracle.com/>
Courtney Llamas | Consulting Member of Technical Staff
Phone: [phone] | Mobile: [phone]
Oracle Strategic Customer Program
Oracle
[image: Green Oracle] <http://www.oracle.com/commitment>
Oracle is committed to developing practices and products that help protect the environment
*Sent:* Wednesday, November 14, 2018 4:36 PM
*Subject:* Re: Enterprise Manager Application Data Modelling question
Wait did I miss some news update? Are you saying that there is currently
not a development team for Enterprise Manager? I use EM Cloud Control 13c
for my on-prem databases.
I recall Larry responding to an audience question several OOW's ago: "Are
you planning to buy the San Francisco 49ers (US football team)?" Larry
paused, leaned forward to the microphone, and responded, "In order to be
buyer, there has to be a seller".
In order for there to be a new release, there has to be a development team.
There was a new release in July this year!
I get that the positioning from Oracle is unclear, but that seems a
stretch, especially as there's no sign of the management cloud acquiring
complete db management capabilities on-premises for example
Courtney,
Thank you so much for your carefully written response, but the statement
"EM is not going anywhere" has many facets.
I think what is being asked (and to which we accept that you cannot and
should not respond in this forum) is that nobody should be expecting future
releases of EM.
Thanks!
-Tim
Pete stop spreading vicious rumors ;) EM is not going anywhere, just
not the focus for Cloud deployments. Folks with on-premises db’s can use
either OEM or OMC, or a combination of the two.
Send me the SR and I’ll have someone look into it ;)
--
- Courtney
Courtney Llamas | Architect
Phone [phone] | Mobile: *[phone]*
Oracle Strategic Customer Program
Oracle <http://www.oracle.com/>
<http://www.oracle.com/>
Oracle is committed to developing practices and products that help protect
the environment <http://www.oracle.com/>
<http://www.oracle.com/>
Enterprise Manager Application Data Modelling question
<http://www.oracle.com/>*
<http://www.oracle.com/>
this is the second oracle-l thread where the future of EM has been
questioned. is the product going away in the future? will it be replaced by
something else for shops that run their own databases?
<http://www.oracle.com/>
<http://www.oracle.com/>
<http://www.oracle.com/>
<http://www.oracle.com/>
Looking at other options is not on the table, Tim.
<http://www.oracle.com/>
<http://www.oracle.com/>
I make no comment about EOL for EM. :( <http://www.oracle.com/>
<http://www.oracle.com/>
Pete <http://www.oracle.com/>
<http://www.oracle.com/>
----- Original Message ----- <http://www.oracle.com/>
*From: <http://www.oracle.com/>*
<http://www.oracle.com/>
*To: <http://www.oracle.com/>*
<http://www.oracle.com/>
*Cc: <http://www.oracle.com/>*
<http://www.oracle.com/>
*Sent: <http://www.oracle.com/>*
Tue, 13 Nov 2018 15:56:05 -0800 <http://www.oracle.com/>
*Subject: <http://www.oracle.com/>*
Re: Enterprise Manager Application Data Modelling question
In the end, all products are EOL, but some are closer to EOL than others.
With masking options from Informatica, IBM, Delphix, Red Gate, Dataveil,
and others to choose from, each of which mask data across most all
relational database platforms, as well as documents, it seems short-sighted
to invest licensing money, time, and effort on masking one island of
information within Oracle one way, and masking all other database platforms
using other methods. Because all confidential data in non-prod needs to be
masked, not just Oracle.
Full disclosure: I work for Delphix, and we do data masking at-rest across
almost all databases and documents, including mainframe.
In the past 4+ years, I have only once come up against data masking using
the Oracle EM pack. This company disliked their experiences masking with
the Oracle pack because it generated complex SQL and PL/SQL to perform the
masking within the database engine. Masking algorithms are computationally
intensive (i.e. encryption, hashing, list-processing, etc) and thus
difficult to optimize in generated SQL and PL/SQL, performing poorly as
they chew up CPU expensively licensed for database. When you charge as
much as Oracle does based on CPU, you don't want that CPU doing anything
but database workload.
By contrast, each and all of the other data masking packages retrieve
arrays of rows to an appserver, mask them in the appserver (typically a
generic Linux server), then either insert them forward or update them back
using ROWID, less reliance on the Oracle optimizer, and employing less
expensive CPU for the computationally-intense masking workload, conserving
the expensive database licensed CPUs for database workload.
So when your customers regroup to mask across the enterprise instead of an
island of Oracle, any of these masking vendors will be happy to solve
that. Especially down under, on that super big island y'all have... :)
<http://www.oracle.com/>
<http://www.oracle.com/>
Yes, I know, it’s unlike me to be asking a question on EM instead of
answering one. 😊 <http://www.oracle.com/>
This is one I’ve never seen before. I’ve been setting up Data Masking for
a customer and we have a couple of different ADMs. Previously, the
Referential Relationships screen showed no records, as the referential
integrity is not defined in the database (not ideal, but that's how it
is). But now the screen is completely blank - no buttons, no screen saying
no records found, nothing. Anyone seen anything like that before?
Restarting the OMS didn't have any impact. Logged an SR, but no response
on it yet and the customer really wants to see some progress so trying all
avenues to move this forward. <http://www.oracle.com/>
EM 13.2 vanilla. <http://www.oracle.com/>
Thanks <http://www.oracle.com/>
Pete <http://www.oracle.com/>
<http://www.oracle.com/>
<http://www.oracle.com/>
<http://www.oracle.com/>
<http://www.oracle.com/>
-- <http://www.oracle.com/>
Niall Litchfield
Oracle DBA
*http://www.orawin.info* <http://www.oracle.com/>
<http://www.oracle.com/>

[Chris Taylor]

If this was Reddit, I'd gold you lol

Chris

Jeff – that is inaccurate. Again, speculation and rumors.
Please contact me offline if you have any concerns. I’m not entertaining
this discussion any longer on the mail list.
--
- Courtney
[image: Oracle] <http://www.oracle.com/>
Courtney Llamas | Consulting Member of Technical Staff
Phone: [phone] | Mobile: [phone]
Oracle Strategic Customer Program
Oracle
[image: Green Oracle] <http://www.oracle.com/commitment>
Oracle is committed to developing practices and products that help protect the environment
*Sent:* Wednesday, November 14, 2018 4:36 PM
*Subject:* Re: Enterprise Manager Application Data Modelling question
Wait did I miss some news update? Are you saying that there is currently
not a development team for Enterprise Manager? I use EM Cloud Control 13c
for my on-prem databases.
I recall Larry responding to an audience question several OOW's ago: "Are
you planning to buy the San Francisco 49ers (US football team)?" Larry
paused, leaned forward to the microphone, and responded, "In order to be
buyer, there has to be a seller".
In order for there to be a new release, there has to be a development team.
There was a new release in July this year!
I get that the positioning from Oracle is unclear, but that seems a
stretch, especially as there's no sign of the management cloud acquiring
complete db management capabilities on-premises for example
Courtney,
Thank you so much for your carefully written response, but the statement
"EM is not going anywhere" has many facets.
I think what is being asked (and to which we accept that you cannot and
should not respond in this forum) is that nobody should be expecting future
releases of EM.
Thanks!
-Tim
Pete stop spreading vicious rumors ;) EM is not going anywhere, just
not the focus for Cloud deployments. Folks with on-premises db’s can use
either OEM or OMC, or a combination of the two.
Send me the SR and I’ll have someone look into it ;)
--
- Courtney
Courtney Llamas | Architect
Phone [phone] | Mobile: *[phone]*
Oracle Strategic Customer Program
Oracle <http://www.oracle.com/>
<http://www.oracle.com/>
Oracle is committed to developing practices and products that help protect
the environment <http://www.oracle.com/>
<http://www.oracle.com/>
Enterprise Manager Application Data Modelling question
<http://www.oracle.com/>*
<http://www.oracle.com/>
this is the second oracle-l thread where the future of EM has been
questioned. is the product going away in the future? will it be replaced by
something else for shops that run their own databases?
<http://www.oracle.com/>
<http://www.oracle.com/>
<http://www.oracle.com/>
<http://www.oracle.com/>
Looking at other options is not on the table, Tim.
<http://www.oracle.com/>
<http://www.oracle.com/>
I make no comment about EOL for EM. :( <http://www.oracle.com/>
<http://www.oracle.com/>
Pete <http://www.oracle.com/>
<http://www.oracle.com/>
----- Original Message ----- <http://www.oracle.com/>
*From: <http://www.oracle.com/>*
<http://www.oracle.com/>
*To: <http://www.oracle.com/>*
<http://www.oracle.com/>
*Cc: <http://www.oracle.com/>*
<http://www.oracle.com/>
*Sent: <http://www.oracle.com/>*
Tue, 13 Nov 2018 15:56:05 -0800 <http://www.oracle.com/>
*Subject: <http://www.oracle.com/>*
Re: Enterprise Manager Application Data Modelling question
In the end, all products are EOL, but some are closer to EOL than others.
With masking options from Informatica, IBM, Delphix, Red Gate, Dataveil,
and others to choose from, each of which mask data across most all
relational database platforms, as well as documents, it seems short-sighted
to invest licensing money, time, and effort on masking one island of
information within Oracle one way, and masking all other database platforms
using other methods. Because all confidential data in non-prod needs to be
masked, not just Oracle.
Full disclosure: I work for Delphix, and we do data masking at-rest across
almost all databases and documents, including mainframe.
In the past 4+ years, I have only once come up against data masking using
the Oracle EM pack. This company disliked their experiences masking with
the Oracle pack because it generated complex SQL and PL/SQL to perform the
masking within the database engine. Masking algorithms are computationally
intensive (i.e. encryption, hashing, list-processing, etc) and thus
difficult to optimize in generated SQL and PL/SQL, performing poorly as
they chew up CPU expensively licensed for database. When you charge as
much as Oracle does based on CPU, you don't want that CPU doing anything
but database workload.
By contrast, each and all of the other data masking packages retrieve
arrays of rows to an appserver, mask them in the appserver (typically a
generic Linux server), then either insert them forward or update them back
using ROWID, less reliance on the Oracle optimizer, and employing less
expensive CPU for the computationally-intense masking workload, conserving
the expensive database licensed CPUs for database workload.
So when your customers regroup to mask across the enterprise instead of an
island of Oracle, any of these masking vendors will be happy to solve
that. Especially down under, on that super big island y'all have... :)
<http://www.oracle.com/>
<http://www.oracle.com/>
Yes, I know, it’s unlike me to be asking a question on EM instead of
answering one. 😊 <http://www.oracle.com/>
This is one I’ve never seen before. I’ve been setting up Data Masking for
a customer and we have a couple of different ADMs. Previously, the
Referential Relationships screen showed no records, as the referential
integrity is not defined in the database (not ideal, but that's how it
is). But now the screen is completely blank - no buttons, no screen saying
no records found, nothing. Anyone seen anything like that before?
Restarting the OMS didn't have any impact. Logged an SR, but no response
on it yet and the customer really wants to see some progress so trying all
avenues to move this forward. <http://www.oracle.com/>
EM 13.2 vanilla. <http://www.oracle.com/>
Thanks <http://www.oracle.com/>
Pete <http://www.oracle.com/>
<http://www.oracle.com/>
<http://www.oracle.com/>
<http://www.oracle.com/>
<http://www.oracle.com/>
-- <http://www.oracle.com/>
Niall Litchfield
Oracle DBA
*http://www.orawin.info* <http://www.oracle.com/>
<http://www.oracle.com/>

[Pete Sharman]

Folks



Sorry I haven’t responded. For those of you that know my history, you’d probably be aware that I have chronic pain issues which raises its ugly head every so often. It’s not that I’m scared of Courtney, you understand (Well, all right, it is that really!) 😉



I’ll be looking into all the good suggestions here today I hope, and will get back to people.



Pete



From: oracle-l-***@freelists.org <oracle-l-***@freelists.org> On Behalf Of Chris Taylor
Sent: Thursday, November 15, 2018 10:02 AM
To: Courtney Llamas <***@oracle.com>
Cc: Jeff Chirco <***@gmail.com>; Tim Gorman <***@gmail.com>; Niall Litchfield <***@gmail.com>; Chris Stephens <***@gmail.com>; ***@westnet.com.au; oracle-l-freelist <oracle-***@freelists.org>
Subject: Re: Enterprise Manager Application Data Modelling question



If this was Reddit, I'd gold you lol



Chris



On Wed, Nov 14, 2018, 5:39 PM Courtney Llamas <***@oracle.com <mailto:***@oracle.com> wrote:

Jeff – that is inaccurate. Again, speculation and rumors.



Please contact me offline if you have any concerns. I’m not entertaining this discussion any longer on the mail list.
--
- Courtney

<http://www.oracle.com/>
Courtney Llamas | Consulting Member of Technical Staff
Phone: <tel:[phone]> [phone] | Mobile: <tel:[phone]> [phone]
Oracle Strategic Customer Program

Oracle


<http://www.oracle.com/commitment>

Oracle is committed to developing practices and products that help protect the environment



From: Jeff Chirco <***@gmail.com <mailto:***@gmail.com> >
Sent: Wednesday, November 14, 2018 4:36 PM
To: Tim Gorman <***@gmail.com <mailto:***@gmail.com> >
Cc: Niall Litchfield <***@gmail.com <mailto:***@gmail.com> >; Courtney Llamas <***@oracle.com <mailto:***@oracle.com> >; Chris Stephens <***@gmail.com <mailto:***@gmail.com> >; ***@westnet.com.au <mailto:***@westnet.com.au> ; oracle-l-freelist <oracle-***@freelists.org <mailto:oracle-***@freelists.org> >
Subject: Re: Enterprise Manager Application Data Modelling question



Wait did I miss some news update? Are you saying that there is currently not a development team for Enterprise Manager? I use EM Cloud Control 13c for my on-prem databases.



On Wed, Nov 14, 2018 at 9:51 AM Tim Gorman <***@gmail.com <mailto:***@gmail.com> > wrote:

I recall Larry responding to an audience question several OOW's ago: "Are you planning to buy the San Francisco 49ers (US football team)?" Larry paused, leaned forward to the microphone, and responded, "In order to be buyer, there has to be a seller".

In order for there to be a new release, there has to be a development team.



On 11/14/18 08:32, ***@gmail.com <mailto:***@gmail.com> wrote:

There was a new release in July this year!



I get that the positioning from Oracle is unclear, but that seems a stretch, especially as there's no sign of the management cloud acquiring complete db management capabilities on-premises for example





On Wed, Nov 14, 2018 at 3:30 PM Tim Gorman <***@gmail.com <mailto:***@gmail.com> > wrote:

Courtney,

Thank you so much for your carefully written response, but the statement "EM is not going anywhere" has many facets.

I think what is being asked (and to which we accept that you cannot and should not respond in this forum) is that nobody should be expecting future releases of EM.

Thanks!

-Tim



On 11/14/18 06:55, Courtney Llamas wrote:

Pete stop spreading vicious rumors ;) EM is not going anywhere, just not the focus for Cloud deployments. Folks with on-premises db’s can use either OEM or OMC, or a combination of the two.



Send me the SR and I’ll have someone look into it ;)
--
- Courtney

<http://www.oracle.com/>
Courtney Llamas | Architect
Phone [phone] | Mobile: [phone]
Oracle Strategic Customer Program

Oracle


<http://www.oracle.com/> Oracle is committed to developing practices and products that help protect the environment

<http://www.oracle.com/>

<http://www.oracle.com/> From: Chris Stephens <***@gmail.com>
Sent: Wednesday, November 14, 2018 8:50 AM
To: ***@westnet.com.au
Cc: Tim Gorman <***@gmail.com>; oracle-l <oracle-***@freelists.org>
Subject: Re: Enterprise Manager Application Data Modelling question

<http://www.oracle.com/>

<http://www.oracle.com/> this is the second oracle-l thread where the future of EM has been questioned. is the product going away in the future? will it be replaced by something else for shops that run their own databases?

<http://www.oracle.com/>

<http://www.oracle.com/>

<http://www.oracle.com/> On Tue, Nov 13, 2018 at 6:03 PM <***@westnet.com.au> wrote:

<http://www.oracle.com/> Looking at other options is not on the table, Tim.

<http://www.oracle.com/>

<http://www.oracle.com/> I make no comment about EOL for EM. :(

<http://www.oracle.com/>

<http://www.oracle.com/> Pete

<http://www.oracle.com/>

<http://www.oracle.com/>
----- Original Message -----

<http://www.oracle.com/> From:

***@gmail.com <http://www.oracle.com/>

<http://www.oracle.com/>

<http://www.oracle.com/> To:

<http://www.oracle.com/> <***@westnet.com.au>, <oracle-***@freelists.org>

<http://www.oracle.com/> Cc:

<http://www.oracle.com/>

<http://www.oracle.com/> Sent:

<http://www.oracle.com/> Tue, 13 Nov 2018 15:56:05 -0800

<http://www.oracle.com/> Subject:

<http://www.oracle.com/> Re: Enterprise Manager Application Data Modelling question


In the end, all products are EOL, but some are closer to EOL than others.

With masking options from Informatica, IBM, Delphix, Red Gate, Dataveil, and others to choose from, each of which mask data across most all relational database platforms, as well as documents, it seems short-sighted to invest licensing money, time, and effort on masking one island of information within Oracle one way, and masking all other database platforms using other methods. Because all confidential data in non-prod needs to be masked, not just Oracle.

Full disclosure: I work for Delphix, and we do data masking at-rest across almost all databases and documents, including mainframe.

In the past 4+ years, I have only once come up against data masking using the Oracle EM pack. This company disliked their experiences masking with the Oracle pack because it generated complex SQL and PL/SQL to perform the masking within the database engine. Masking algorithms are computationally intensive (i.e. encryption, hashing, list-processing, etc) and thus difficult to optimize in generated SQL and PL/SQL, performing poorly as they chew up CPU expensively licensed for database. When you charge as much as Oracle does based on CPU, you don't want that CPU doing anything but database workload.

By contrast, each and all of the other data masking packages retrieve arrays of rows to an appserver, mask them in the appserver (typically a generic Linux server), then either insert them forward or update them back using ROWID, less reliance on the Oracle optimizer, and employing less expensive CPU for the computationally-intense masking workload, conserving the expensive database licensed CPUs for database workload.

So when your customers regroup to mask across the enterprise instead of an island of Oracle, any of these masking vendors will be happy to solve that. Especially down under, on that super big island y'all have... :)



<http://www.oracle.com/> On 11/13/18 14:36, ***@westnet.com.au wrote:

<http://www.oracle.com/> Yes, I know, it’s unlike me to be asking a question on EM instead of answering one. 😊

<http://www.oracle.com/> This is one I’ve never seen before. I’ve been setting up Data Masking for a customer and we have a couple of different ADMs. Previously, the Referential Relationships screen showed no records, as the referential integrity is not defined in the database (not ideal, but that's how it is). But now the screen is completely blank - no buttons, no screen saying no records found, nothing. Anyone seen anything like that before? Restarting the OMS didn't have any impact. Logged an SR, but no response on it yet and the customer really wants to see some progress so trying all avenues to move this forward.

<http://www.oracle.com/> EM 13.2 vanilla.

<http://www.oracle.com/> Thanks

<http://www.oracle.com/> Pete

<http://www.oracle.com/>

<http://www.oracle.com/>

<http://www.oracle.com/>


<http://www.oracle.com/>

<http://www.oracle.com/> --

<http://www.oracle.com/> Niall Litchfield
Oracle DBA
http://www.orawin.info

<http://www.oracle.com/>

[Pete Sharman]

Gah! When I went to the same page this morning the screen displays properly!!!



Damn I hate inconsistent issues! ☹



Pete



From: oracle-l-***@freelists.org <oracle-l-***@freelists.org> On Behalf Of Pete Sharman
Sent: Monday, November 19, 2018 10:43 AM
To: ***@gmail.com; 'Courtney Llamas' <***@oracle.com>
Cc: 'Jeff Chirco' <***@gmail.com>; 'Tim Gorman' <***@gmail.com>; 'Niall Litchfield' <***@gmail.com>; 'Chris Stephens' <***@gmail.com>; 'oracle-l-freelist' <oracle-***@freelists.org>
Subject: RE: Enterprise Manager Application Data Modelling question



Folks



Sorry I haven’t responded. For those of you that know my history, you’d probably be aware that I have chronic pain issues which raises its ugly head every so often. It’s not that I’m scared of Courtney, you understand (Well, all right, it is that really!) 😉



I’ll be looking into all the good suggestions here today I hope, and will get back to people.



Pete



From: oracle-l-***@freelists.org <mailto:oracle-l-***@freelists.org> <oracle-l-***@freelists.org <mailto:oracle-l-***@freelists.org> > On Behalf Of Chris Taylor
Sent: Thursday, November 15, 2018 10:02 AM
To: Courtney Llamas <***@oracle.com <mailto:***@oracle.com> >
Cc: Jeff Chirco <***@gmail.com <mailto:***@gmail.com> >; Tim Gorman <***@gmail.com <mailto:***@gmail.com> >; Niall Litchfield <***@gmail.com <mailto:***@gmail.com> >; Chris Stephens <***@gmail.com <mailto:***@gmail.com> >; ***@westnet.com.au <mailto:***@westnet.com.au> ; oracle-l-freelist <oracle-***@freelists.org <mailto:oracle-***@freelists.org> >
Subject: Re: Enterprise Manager Application Data Modelling question



If this was Reddit, I'd gold you lol



Chris



On Wed, Nov 14, 2018, 5:39 PM Courtney Llamas <***@oracle.com <mailto:***@oracle.com> wrote:

Jeff – that is inaccurate. Again, speculation and rumors.



Please contact me offline if you have any concerns. I’m not entertaining this discussion any longer on the mail list.
--
- Courtney

<http://www.oracle.com/>
Courtney Llamas | Consulting Member of Technical Staff
Phone: <tel:[phone]> [phone] | Mobile: <tel:[phone]> [phone]
Oracle Strategic Customer Program

Oracle


<http://www.oracle.com/commitment>

Oracle is committed to developing practices and products that help protect the environment



From: Jeff Chirco <***@gmail.com <mailto:***@gmail.com> >
Sent: Wednesday, November 14, 2018 4:36 PM
To: Tim Gorman <***@gmail.com <mailto:***@gmail.com> >
Cc: Niall Litchfield <***@gmail.com <mailto:***@gmail.com> >; Courtney Llamas <***@oracle.com <mailto:***@oracle.com> >; Chris Stephens <***@gmail.com <mailto:***@gmail.com> >; ***@westnet.com.au <mailto:***@westnet.com.au> ; oracle-l-freelist <oracle-***@freelists.org <mailto:oracle-***@freelists.org> >
Subject: Re: Enterprise Manager Application Data Modelling question



Wait did I miss some news update? Are you saying that there is currently not a development team for Enterprise Manager? I use EM Cloud Control 13c for my on-prem databases.



On Wed, Nov 14, 2018 at 9:51 AM Tim Gorman <***@gmail.com <mailto:***@gmail.com> > wrote:

I recall Larry responding to an audience question several OOW's ago: "Are you planning to buy the San Francisco 49ers (US football team)?" Larry paused, leaned forward to the microphone, and responded, "In order to be buyer, there has to be a seller".

In order for there to be a new release, there has to be a development team.

On 11/14/18 08:32, ***@gmail.com <mailto:***@gmail.com> wrote:

There was a new release in July this year!



I get that the positioning from Oracle is unclear, but that seems a stretch, especially as there's no sign of the management cloud acquiring complete db management capabilities on-premises for example





On Wed, Nov 14, 2018 at 3:30 PM Tim Gorman <***@gmail.com <mailto:***@gmail.com> > wrote:

Courtney,

Thank you so much for your carefully written response, but the statement "EM is not going anywhere" has many facets.

I think what is being asked (and to which we accept that you cannot and should not respond in this forum) is that nobody should be expecting future releases of EM.

Thanks!

-Tim

On 11/14/18 06:55, Courtney Llamas wrote:

Pete stop spreading vicious rumors ;) EM is not going anywhere, just not the focus for Cloud deployments. Folks with on-premises db’s can use either OEM or OMC, or a combination of the two.



Send me the SR and I’ll have someone look into it ;)
--
- Courtney

<http://www.oracle.com/>
Courtney Llamas | Architect
Phone [phone] | Mobile: [phone]
Oracle Strategic Customer Program

Oracle


<http://www.oracle.com/> Oracle is committed to developing practices and products that help protect the environment

<http://www.oracle.com/>

<http://www.oracle.com/> From: Chris Stephens <***@gmail.com>
Sent: Wednesday, November 14, 2018 8:50 AM
To: ***@westnet.com.au
Cc: Tim Gorman <***@gmail.com>; oracle-l <oracle-***@freelists.org>
Subject: Re: Enterprise Manager Application Data Modelling question

<http://www.oracle.com/>

<http://www.oracle.com/> this is the second oracle-l thread where the future of EM has been questioned. is the product going away in the future? will it be replaced by something else for shops that run their own databases?

<http://www.oracle.com/>

<http://www.oracle.com/>

<http://www.oracle.com/> On Tue, Nov 13, 2018 at 6:03 PM <***@westnet.com.au> wrote:

<http://www.oracle.com/> Looking at other options is not on the table, Tim.

<http://www.oracle.com/>

<http://www.oracle.com/> I make no comment about EOL for EM. :(

<http://www.oracle.com/>

<http://www.oracle.com/> Pete

<http://www.oracle.com/>

<http://www.oracle.com/>
----- Original Message -----

<http://www.oracle.com/> From:

***@gmail.com <http://www.oracle.com/>

<http://www.oracle.com/>

<http://www.oracle.com/> To:

<http://www.oracle.com/> <***@westnet.com.au>, <oracle-***@freelists.org>

<http://www.oracle.com/> Cc:

<http://www.oracle.com/>

<http://www.oracle.com/> Sent:

<http://www.oracle.com/> Tue, 13 Nov 2018 15:56:05 -0800

<http://www.oracle.com/> Subject:

<http://www.oracle.com/> Re: Enterprise Manager Application Data Modelling question


In the end, all products are EOL, but some are closer to EOL than others.

With masking options from Informatica, IBM, Delphix, Red Gate, Dataveil, and others to choose from, each of which mask data across most all relational database platforms, as well as documents, it seems short-sighted to invest licensing money, time, and effort on masking one island of information within Oracle one way, and masking all other database platforms using other methods. Because all confidential data in non-prod needs to be masked, not just Oracle.

Full disclosure: I work for Delphix, and we do data masking at-rest across almost all databases and documents, including mainframe.

In the past 4+ years, I have only once come up against data masking using the Oracle EM pack. This company disliked their experiences masking with the Oracle pack because it generated complex SQL and PL/SQL to perform the masking within the database engine. Masking algorithms are computationally intensive (i.e. encryption, hashing, list-processing, etc) and thus difficult to optimize in generated SQL and PL/SQL, performing poorly as they chew up CPU expensively licensed for database. When you charge as much as Oracle does based on CPU, you don't want that CPU doing anything but database workload.

By contrast, each and all of the other data masking packages retrieve arrays of rows to an appserver, mask them in the appserver (typically a generic Linux server), then either insert them forward or update them back using ROWID, less reliance on the Oracle optimizer, and employing less expensive CPU for the computationally-intense masking workload, conserving the expensive database licensed CPUs for database workload.

So when your customers regroup to mask across the enterprise instead of an island of Oracle, any of these masking vendors will be happy to solve that. Especially down under, on that super big island y'all have... :)



<http://www.oracle.com/> On 11/13/18 14:36, ***@westnet.com.au wrote:

<http://www.oracle.com/> Yes, I know, it’s unlike me to be asking a question on EM instead of answering one. 😊

<http://www.oracle.com/> This is one I’ve never seen before. I’ve been setting up Data Masking for a customer and we have a couple of different ADMs. Previously, the Referential Relationships screen showed no records, as the referential integrity is not defined in the database (not ideal, but that's how it is). But now the screen is completely blank - no buttons, no screen saying no records found, nothing. Anyone seen anything like that before? Restarting the OMS didn't have any impact. Logged an SR, but no response on it yet and the customer really wants to see some progress so trying all avenues to move this forward.

<http://www.oracle.com/> EM 13.2 vanilla.

<http://www.oracle.com/> Thanks

<http://www.oracle.com/> Pete

<http://www.oracle.com/>

<http://www.oracle.com/>

<http://www.oracle.com/>


<http://www.oracle.com/>

<http://www.oracle.com/> --

<http://www.oracle.com/> Niall Litchfield
Oracle DBA
http://www.orawin.info

<http://www.oracle.com/>

[Stefan Knecht]

Run a sql trace on the repo when you refresh the problem page? Might show
some SQL unexpectedly failing or returning no data where it should.

Yes, I know, it’s unlike me to be asking a question on EM instead of
answering one. 😊
This is one I’ve never seen before. I’ve been setting up Data Masking
for a customer and we have a couple of different ADMs. Previously, the
Referential Relationships screen showed no records, as the referential
integrity is not defined in the database (not ideal, but that's how it
is). But now the screen is completely blank - no buttons, no screen saying
no records found, nothing. Anyone seen anything like that before?
Restarting the OMS didn't have any impact. Logged an SR, but no response
on it yet and the customer really wants to see some progress so trying all
avenues to move this forward.
EM 13.2 vanilla.
Thanks
Pete

[n***@gmail.com]

I haven't no, but is it possible that its a browser change/update?

Yes, I know, it’s unlike me to be asking a question on EM instead of
answering one. 😊
This is one I’ve never seen before. I’ve been setting up Data Masking
for a customer and we have a couple of different ADMs. Previously, the
Referential Relationships screen showed no records, as the referential
integrity is not defined in the database (not ideal, but that's how it
is). But now the screen is completely blank - no buttons, no screen saying
no records found, nothing. Anyone seen anything like that before?
Restarting the OMS didn't have any impact. Logged an SR, but no response
on it yet and the customer really wants to see some progress so trying all
avenues to move this forward.
EM 13.2 vanilla.
Thanks
Pete