Best Of
Re: On demand event : remote program PSPBARUN failed with reason
Unsolicited comment: Joyce is awesome! Thank you so much for linking document KB260165 as the information in that document helped me to resolve an issue we were having and kept me from having to open an SR. I have worked with Joyce on previous SRs and she is truly knowledgeable about Benefits and Pension and she is a true asset for Oracle. Thanks again!
Re: Anyone worked on as built configuration report for aviation industry? would like your input.
Thank you for your follow up, We will have someone from CMRO respond to the other thread.
Re: Performance Transactions in PO_IGT_PERF_DETAIL table have null in PO_DISTRIBUTION_ID column
Its been a while, so this has probably been figured out. But if helpful, I'll add.
"The Invoice gets created with a Invoice Header and Line no Distributions."
That is standard behavior when interfacing via the Payables Open Interface. The distributions records aren't created in the ap_invoice_distributions_all table, until Invoice Validation is executed on the Invoice, for imported invoices. The "distributions" will appear via the forms, but these are "logical" records based on the data in the ap_invoice_lines_all table, until invoice validation. I believe the distribution status shows as 'Preview' for the distributions in this case, vs 'Saved' when the records are actually created in the ap_invoice_distributions_all table.
Re: W4 PDF with Basic Authentication and SSL (HTTPS)
Please take a look at these Doc's
E-SSL: Offloading SSL to F5 Load Balancer (KB327435)
EPY: Updatable W-4 Feature Errors Using Basic Authentication and SSL and Using Load Balancer (KB502808)
E-PIA: PeopleSoft Load Balancer Support Guidelines (KB537361)
which states in the attached file Load_Balancer_Support_Guidelines.pdf
"Because the focus is on replicating bugs and configuring for basic environments, these complex load balancer issues have always been considered out of scope."
Will wait for other customers to respond and help you.
Regards,
Asif M -Oracle.
Re: adding support Identifiers
Now that the portal has changed, what is the recent method to request/add a new support identifier which exists within the same organization? Kindly share the steps.
Re: PER016 EEO-1 Employer Information report wrong column order?
Looks like it is bug 38208358 and development is waiting on the EEOC so no delivery date at this time.
Re: Temp tablespace 12.2
Hello,
Regarding the documentation note -
>>> ... So it looks like it always uses the shared temp tablespace in read/write instance. ... <<<
What it means is the order in which the Oracle internal algorithms searches for the temporary space. It does not mean that for read-write database only a shared temporary tablespace is being used. Rather it implies the priorities assigned to each of the categories of the temporary tablespace.
There will be other aspects that can come into play as well. Firstly the local temporary tablespace needs to created as 'bigfile' on each RAC node. There could be a possibility of the query that started on a particular node/instance could have slave processes running on other node(s)/instance(s). Next the intent is to normally use the local temporary tablespace as a 'spillover' area. So that means anything that could not be handled by the regular (shared) temporary tablespace is caught/spillover to the local temporary tablespace. There are situations wherein the local temporary tablespace is insufficient to handle then obviously it would make use of the shared temporary area.
The contents of the local temporary tablespace (of respective nodes/instances) are not visible across the other RAC nodes/instances. This is because even though the local temporary tablespace name could be the same but on each of these RAC instances they would be pointing to a different physical file. This also eliminates the need to synchronize the data (in local temp) across instances reducing the interconnect network traffic.
Last but not the least in your case the local temporary tablespace file is on a ASM diskgroup as being against disks local to the node. The ASM diskgroup is on a shared storage for the RAC cluster. As mentioned above the only variant being the respective files (of the local temp) are distinct for each of the RAC node/instance.
Hope this helps
Cheers
Suresh
Re: Temp tablespace 12.2
Thanks. I tested it doesn't use the local temp tablespace "ltemp" from the instead using the shared tablespace temp.
How can i make sure that it uses the local .
Re: Temp tablespace 12.2
Local temp tablespace got created successfully . We had enough space on the diskgroup had to give complete absolute path for the filename and two files got each on one instance.
'+OCP31_DGA_DTA01/OCP31C1/6F2CD03F10DD46ECE05358D15A0A6D8B/TEMPFILE/ltemp_01.dbf'
i assigned this local temp tablespace to the user now. does the user now uses the local or shared temp space in case of any sort or hash join operations?
1* select username,temporary_tablespace,local_temp_tablespace from dba_users where username like 'EREG04_WEB' order by 1
SQL> /
USERNAME TEMPORARY_TABLESPACE LOCAL_TEMP_TABLESPACE
-------------------- ------------------------------ ------------------------------
EREG04_WEB TEMP LTEMP
Thanks