The following figure illustrates the phases, and the iterative nature, of a machine learning project. The process flow shows that a machine learning project does not stop when a particular solution is deployed. Instead, the results trigger new business questions, which can be used to develop more focused models.
Entries by Arsalan
Avoid SQL Performance Problems
Would you please download and install the one-off patch for your database version and OS for bugs not included in RU yet? If you do not find a patch for your specific version and OS from MOS, please open a Service Request with details on the patch needed. In addition, please include a list of […]
DBA_LOCK or DBA_LOCKS
Formatted view on V$LOCK that created via $ORACLE_HOME/rdbms/admin/catblock.sql SESSION_ID == SID in V$LOCK LOCK_TYPE, LOCK_ID1, LOCK_ID2 formatted value of TYPE, ID1, ID2 from V$LOCK MODE_HELD and MODE_REQUESTED formatted value of LMODE and REQUEST from V$LOCK LAST_CONVERT == CTIME of V$LOCK BLOCKING_OTHERS formatted value of BLOCK from V$LOCK Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/DBA_LOCK.html#GUID-B19FF191-AC89-498D-B2C1-2A18F63DC03D
V$TRANSACTION
V$TRANSACTION lists the active transactions in the system. (i) The following columns together point to a transaction. (i.e.) The combination of the following should give a unique transaction id for that database. XIDUSN – Undo segment number XIDSLOT – NUMBER Slot number XIDSQN – NUMBER Sequence number (ii) The following columns explain the number of […]
Which lock modes are required for which table action? How compatibility of locks works?
The following table describes what lock modes on DML enqueues are gotten for table operations in a standard Oracle installation. The compatibility of lock modes usually are represented by the following matrix:
Will objects be imported with the INMEMORY attribute?
You can import database objects that are enabled for the IM column store using the TRANSFORM=INMEMORY:y option of the ‘impdp’ command. With this option, Data Pump keeps the IM column store clause for all objects that have one. When the TRANSFORM=INMEMORY:n option is specified, Data Pump drops the IM column store clause from all objects […]
Oracle BUG DB RU 19.12.0.0.210720 or DB RUR 19.11.1.0.210720
After applying DB RU 19.12.0.0.210720 or DB RUR 19.11.1.0.210720, you may notice that the Block Change Tracking (BCT) file is getting created of a size that is not in line with the database size. Oracle recommends that you apply interim one-off Patch 33185773 to correct this problem(s) in the RU/RURs indicated above. Note the fix for this issue has […]
Transitivity
Oracle CBO performs transitivity as the first step in optimization. Transitivity means generating additional predicates based on existing predicates. The main advantage is the inclusion of extra access methods. Transitivity is not done for join predicates. Assume A, B, and C are columns. If A=5 and A=B, you can conclude that B=5. This can be […]
Move to Oracle Cloud Database (MV2OCI)
MV2OCI is a new tool is permitting the load data and migration from “on-premises” to Oracle Cloud Database leveraging on Oracle Data Pump and within one command. Data Pump Import lets you import data from Data Pump files residing on the Oracle Cloud Database node. For more information see Doc ID 2514026.1.
Oracle Multitenant: LICENSE CHANGES IN 2019
For all offerings using Oracle Database 19c or later, if you are not licensed for Oracle Multitenant, then you may have up to 3 user-created PDBs in a given container database at any time. For all offerings using Oracle Database 12.1 through 18c, if you are not licensed for Oracle Multitenant, then the container database […]