Best Of
Re: database resource utilization for a user
Hi
Tracking per-user resource consumption (CPU, memory, I/O, etc.) is feasible and can be achieved using a combination of Oracle’s dynamic performance
views like gv$sesstat,gv$statname,gv$session etc .
You can also Generate AWR reports (awrrpti.sql for RAC) to get cluster-wide historical breakdowns by user, SQL, service, and more.
The section "Top Users by DB Time" summarizes per-user resource usage.
Thanks
Swati A
Re: eSupplier / Supplier Portal Setup Guide 9.2
This what I was thinking I believe….it was implementing Strategic Sourcing and not the overall Supplier Portal.
Re: Component Pick Release in WIP
I think Multi step Picking and Dropping (before the Picked Material finally reaches its destination) is not possible from standard perspective.
Ref : WMS N Step Putaway Reason Does Not Work For Staging Put Away (Doc ID 1093334.1)
How Can Subinventory Transfer and Load LPN Process Be Combined Into One Operation in MSCA? (Doc ID 2968807.1)
Thanks
Component Pick Release in WIP
Hi,
I want to pick material against a job after the component pick release, place it into a cart LPN, and then move that cart LPN to a staging subinventory/locator. From there, I want to issue the material to the job from that staging subinventory/locator.
In Oracle WMS, once material is loaded into an LPN, it cannot be moved across subinventories or locators. The only option available after loading is Drop, which directly issues the material to the job. What I am looking for is a way to introduce a two-step process:
- Load the picked material into an LPN.
- Move that LPN to staging, and then issue/drop it to the job from staging.
If anyone has achieved this, please guide me on how to configure it. We are also open to custom solutions.
Thanks,
Sumir
SumirB
Re: eSupplier / Supplier Portal Setup Guide 9.2
I found this
PeopleSoft FSCM 9.2: eSupplier Connection and
Using the Comprehensive Supplier Public Portal in PeopleSoft Fluid User Interface
Not sure if either of these are what you are looking for.
Re: Forms bit.ly/ORA-00600 always send a java exception since some days
Hi Cedric,
I've moved your post out of the "Support portal help" channel and into the Database ORA-600 / ORA-7445 Analysis , Diagnostic Repository (ADR) & Packaging (MOSC) category, which I believe is a better fit for the subject matter of your question.
Hopefully the experts here will be able to assist. Otherwise, please log a support ticket (SR) in My Oracle Support to get some personal assistance.
Thank you,
Jennifer B
My Oracle Support Community Administrator
Re: Java version installed within the Oracle Database 19c Standard Edition ORACLE_HOME is covered under
Hi,
As far as I understand, no additional license is required to use the Oracle JVM. As shown below, the Oracle JVM is included with Oracle Database, and the license guide contains no specific additional notes.
the Oracle JVM is embedded within Oracle Database and introduces a number of new concepts
Regards,
asahide
Re: INACTIVE_ACCOUNT_TIME - How often does the database check for inactive accounts
I unlocked some inactive accounts yesterday afternoon and they were locked again by this morning.
I unlocked them again at about 09:30 and the unused accounts were locked again by 14:00.
The database checks frequently for inactive accounts and locks them. It doesn't matter if they have never logged in.
My question is how often does the database do the checking?