Best Of
Re: Weblogic Zip file is corrupt
It is generally covered in patch readmes,
https://updates.oracle.com/Orion/PatchDetails/view_readme?aru=25741281
1. Unzip p36805124_122140_Generic.zip into PATCH_TOP
Notes: You must make sure that the target directory for unzip has required write and executable permissions for "user" with which the component being patched is installed.
On some platforms, the zip/unzip utility may not be able to extract the jar files in the zip correctly.
On Windows, the native zip utility will show a 'path too long' error. Java provides the jar utility which will avoid this problem, e.g., jar -xvf p36805124_122140_Generic.zip.
Re: routing using nested realms (AP1100)
I have seen some recent bugs relating to match-sa-port option.
I'd recommend that you open a case with support with the appropriate information to include "show run", "show support-info" and an example of failing call.
If the issue turns out not to be a bug, your configuration can also be verified.
John
Re: ODA X11 new deployment
Hi Krisz,
Thanks for the feedback.
Yes, I created cpupool for VMs using 20 cores.
Meaning the total vcpu for VM is 40. (2x20)
Well understood.
Thanks for clarification.
Thanks,
James.
Re: Anyone having problem with the prepatch report hanging on Validate ILOM server reachable?
Krisz,
I sent you the SR.
Luigi
Re: Check The Table Record Size
@Chee Lon "My objective is to do an estimation on how much storage space I could free up after I have deleted X amount of records"
Again, you need to clarify - free for what? Deleting rows will not reduce space allocated to table and therefore tablespace free space will not increase. We will just end up with more unused space with table segment (subject to Bruno's explanation), so if your goal make more free space for other objects in the tablespace - delete will not do. If you want to delete some rows, compact table data and return freed space back to the tablespace you could use ALTER TABLE MOVE. You will need to come up with keep rather than delete condition. For example, you want to delete rows
where Date_of_Birth < DATE '2000-01-01'
This means we want to keep rows
where Date_of_Birth >= DATE '2000-01-01'
or, if Date_of_Birth can be NULL
where Date_of_Birth >= DATE '2000-01-01' or Date_of_Birth is NULL
Now we can:
alter table employee move including where Date_of_Birth >= DATE '2000-01-01' or Date_of_Birth is NULL online update indexes;
Still, even online move can affect performance so you'd need to test it in PTE (performance testing environment) before implementing. Another option would be deleting rows, enabling row movement and using shrink space but I don't recall if it supports online option.
SY.
![Nick [Application Server] -Oracle](https://us.v-cdn.net/6032256/uploads/userpics/99FV8E0EEW09/n1DRCNFJ5LDAF.jpg)
