Best Of
Re: How can i start index monitoring on active data guard? Is it possible to monitor indexes in ADG?
I think v$object_usage is the right view - this is available as long as the instance with the ADG is running and after a db restart it is empty again - but it does only show entries for the connected user.
You can query that for all users as System also, but you need to build your own select:
SELECT U.NAME OWNER, IO.NAME INDEX_NAME, T.NAME TABLE_NAME, DECODE(BITAND(I.FLAGS, 65536), 0, 'NO', 'YES') MONITORING, decode(bitand(ou.flags, 1), 0, 'NO', 'YES') used, ou.start_monitoring, ou.end_monitoring from sys.user$ u, sys.obj$ io, sys.obj$ t, sys.ind$ i, sys.object_usage ou where i.obj# = ou.obj# and io.obj# = ou.obj# AND T.OBJ# = I.BO# and u.user# = io.owner#;
Re: oracle 19c remote listener ssl problem
Hello tbela,
Can you clarify more on the note of "remote listener"? Do you mean a connection between a remote client with the DB listener? Which platform is the DB running on and what is the full version number of the DB?
Based on the "listenerssl" entries do you intend to have only the "tcps" address and not have the 'tcp' and/or 'ipc' addresses? Why 2 entries of "Wallet_Location"? Does the environment also has the GI? If so then the 'sqlnet.ora' entries are to be setup both under the GI home and DB home.
Hope this helps -- Cheers -- Suresh
Re: Instead of disposing and creating new one in another unit, can we transfer asset from one to another
Hi Vamshi HM.,
The concept of asset transfer from one Entity/OU/book to another doesn't exist in Oracle Asset.
The only available workaround is the one you already mentioned.
Regards,
Catalin
Re: Can I use WSFC in an environment where SEHA is configured ?
Hi,
I understand that this is because SEHA includes disk operations, etc., and if WSFC is set up on the Windows side, it will be managed in order and inconsistencies will occur.
2)
←No. You cannot use WSFC(Windows Server Failover Clustering) in environment where SEHA is configured.
So, You cannot configure SEHA w/ WSFC.
Regards,
asahide
Re: Dual Unit of measure for non stock part without maintaining the UoM conversions
From Oracle Support: thank you for the post Balaji.
This is working as I would expect - if the system cannot locate any conversion, then it cannot calculate the appropriate values. I tested here with an EA to CA Primary/Secondary, and with no conversion, when I raise an order with 4EA and 1 CA, it reverts the CA value to 4, the same as the EA. The same results you see.
If you do not want an item-based conversion, can you set a standard conversion (P41003) for the Meter/JT ?
WIth regards,
-Matt
Re: Configuring Data Guard Redo Transport on separate network.
Unless you use the GRID Infrastructure to manage the listener associated with the second network, you will need to implement the second network using VIP's.
Re: Why EXPDP suddenly takes too long than usual? How to resolve this?
Hello,
Please follow next steps
- Configure stream_pool_size, e.g. set streams_pool_size (the internal mechanism of Data Pump is using streams ) I would recommend setting the STREAMS_POOL_SIZE to the value returned by the result set of the following query.
select 'ALTER SYSTEM SET STREAMS_POOL_SIZE='||(max(to_number(trim(c.ksppstvl)))+67108864)||' SCOPE=SPFILE;'
from sys.x$ksppi a, sys.x$ksppcv b, sys.x$ksppsv c
where a.indx = b.indx and a.indx = c.indx and lower(a.ksppinm) in ('__streams_pool_size','streams_pool_size');
- Collect Dictionary Statistics:
SQL> connect / as sysdba
SQL> exec dbms_stats.gather_dictionary_stats;
SQL> exec dbms_stats.lock_table_stats (null,'X$KCCLH');
SQL> exec dbms_stats.gather_fixed_objects_stats;
- then stop the current impdp and eliminate the orphaned data pumps jobs as per steps from How To Cleanup Orphaned DataPump Jobs In DBA_DATAPUMP_JOBS ? (Doc ID 336014.1)
- re-run the export adding the EXCLUDE=STATISTICS parameter. The statistics can be collected after the import will finish
Also please follow the recommendations from next document:
Checklist For Slow Performance Of DataPump Export (expdp) And Import (impdp) (Doc ID 453895.1)
Best regards,
George
How can we restrict the Price once the modifier is applied.
Hi,
Scenario:
There are 3 lines on a sales order with the same item with different schedule ship date.
A modifier is applied on a sales order lines and the price is modified accordingly based on the qty ordered. Two lines got shipped to customer.
Price is getting changed when the user tries to decrease the qty on the third line.
Could you help in restricting the change in price as the customer wants the order lines to be shipped on the price applied by a modifier.
Billing - Adjust Entire Bill
Hello,
Im trying to adjust a entire bill and when after entering the details under Adjust Entire bill page, im able to see the adjustment bill Id under "Bill Inquiry" page after this what are the steps to post the entry to GL ?
Im looking to create a reversal of the original bill and post it to GL
Thanks
Re: ORA-01403: no data found in bulk collect
Hi User_D9VNV,
The "ORA-01403: no data found" is raised probably because no record is found at index position 3 of the collection variable 'test_head_stg' while the INSERT is executed.
You have accidentally used same index variable('i) for accessing the elements from both 'test_head_stg' and 'test_cur_stg' inside the INSERT INTO VALUES statement. The test_cur_stg.COUNT() returns 3 implies there exists three records in test_cur_stg but the same may not be true for 'test_head_stg'.
Use different index variable for accessing the elements from the collection variables 'test_head_stg' and 'test_cur_stg'. This should fix the problem.
Thanks,
Kaushik.