|
Previous <
15
16
17
18
19
20
21
22
23
> Next
|
|
There are times when duplicate rows somehow creep into the table. The best scenario to happen this is when the data is to be imported from some other table or data and the Constraints are removed so that data import successfully.
Now in Oracle you can delete the duplicate entries by just executing a simple SQL because Oracle stores an index to each row in a table known as ROWID |
|
|
|
ASM enhances the performance that raw disks provide, without the pain or difficulty of administrating the raw disks. Moreover, ASM provides storage mirroring policies that can be configured on a file level rather than at the volume level that traditional volume managers provide. Therefore, a combination of files that are mirrored and non-mirrored in the same ASM disk group can co-exist.
ASM spreads Oracle datafiles across all disks in the disk group, thereby eliminating any Hotspots (storage areas where tables that are being used aggressively are located). Above all, it allows adding and dropping disks online. All this can be done without any extra cost. Therefore, whenever we need to use a clustered filesystem, ASM is an important component as its resources, such as disks and files, are sharable and fit into shared storage architecture whether it is RAC or non-RAC clusterware.
|
|
|
|
Microsoft BizTalk Adapter for Oracle Database is a development and run-time environment for line-of-business process management and automation. This section describes two SDK samples that present an end-to-end exercise in setting up and deploying the adapter so that you can get a quick start.
These tutorials include detailed step-by-step information about adding an adapter to BizTalk Server, creating the appropriate send and receive ports, building and deploying the samples, and processing test data with the samples.
|
|
|
|
Ok, so someone is going to take me to task for calling it a 'tutorial' because the correct term to use is "OBE" - Oracle By Example. To quote from the Oracle documentation site, "Oracle by Example (OBE) tutorials provide hands-on, step-by-step instructions on how to implement various technology solutions to business problems. OBE solutions are built for practical real-world situations, allowing you to gain valuable hands-on experience as well as use the presented solutions as the foundation for production implementation, dramatically reducing time to deployment."
There are two OBEs for the BI EE 10.1.3 release that are immediately available, while more are in the works.
|
|
|
|
To continue with the shared server series, as mentioned in my last post, I will here be taking up the issues of configuration of memory, and the management of shared servers using available data dictionary views and initialization parameters.
How much memory should you configure for shared servers?
Well, that may be based upon the memory requirements of a representative session multiplied by the expected number of user connections you expect to connect simultaneously. Querying data dictionary views v$session, v$sesstat, v$statname gives us the memory usage of a representative user session. Here's how I work it out : |
|
|
|
Previous <
15
16
17
18
19
20
21
22
23
> Next
|
|
|