Dooly's Corner

                Especially in India, when we say about TRADING, the majority of people think about either risk or loss or both. The reason behind the risks are extremely untutored on charting techniques, ill-educated about the trading platform, witless goals on the outcome, cretinous decisions when trade, lack of knowledge about current affairs and market conditions and so on. General info on Trading. Trading means buying or selling goods, commodities, metals, oils, currencies, stock & futures, etc. In trading either you can be an individual trader and be a boss of your own (OR) you can learn the skills, develop your own strategies and join a company as a professional trader. Before entering into Trading Network, you need to set your mind with the below qualities: 1 - Being patient. 2 - Not being greedy. 3 - Self Educated (both fundamental and technical analysis). If you miss any of the above at any point ...

Today, I am going to articulate an interesting topic. It is about Cryonics Technology. It is the first and foremost prominent technology that relates to AFTERLIFE! Does it sound weird? Cryonics is the low-temperature freezing, that would be -130 °C and storage of corpses!  Now, you might have a plethora of WH-Questions! Cryonics Technology comes into the picture only when the human being expires due to lung/liver/heart or any other organ failure or due to any diseases. This technology will keep the body and other organs as undamaged as possible by freezing them and circulating the blood throughout the vessels. So that, In future, If the dead person gets antidote or cure, then they will implement the fix and then the dead can come back to life AGAIN!  It is like " I am back " as Keanu Reeves says in the movie John Wick. Let's go a little deeper into this topic! This will be fascinating. James Bedford was an American Psychology professor whose body was first preserved aft...

Analytic Workspace Manager Known Bugs * BUG 28532773 - CUBE STORAGE ADVISOR FAILS TO RUN UNLESS USER CAN QUERY V$PARAMETER Cube Storage Advisor fails with the following error: ORA-00942 table or view not found Workaround: None * BUG 28937717 - CALCULATIONS MISSING FROM' CREATE CALCULATION MEASURES' Measures cannot be calculated in the Create Calculation Measure wizard. Workaround: None Issues Affecting Linux for Oracle Database 19c BUG 26708302 - UNABLE TO DELETE "DEINSTALL" EMPTY FOLDER ON SHARED RAC HOME ON NAS Deinstallation of Oracle Real Application Clusters (Oracle RAC) home on shared Network Attached Storage (NAS) fails to delete the directory $ORACLE_HOME/deinstall and returns the following error: Failed to delete the directory $ORACLE_HOME/deinstall. Either user has no permission to delete or it is in use. Workaround: Manually delete the $ORACLE_HOME/deinstall folder as either the Oracle RAC owner or as root. Known Issues and Bug...

The SQL_ID of a statement can be found in an AWR or ASH report or by selecting it from the database data dictionary using the V$SQL view. If the SQL can be identified with a particular identifiable string or by some kind of unique comment such as /* TARGET SQL */ then this will make it easier to locate. For Example: SELECT /* TARGET SQL */ * FROM dual; SELECT sql_id, plan_hash_value, substr(sql_text,1,40) sql_text FROM v$sql WHERE sql_text like 'SELECT /* TARGET SQL */%' SQL_ID PLAN_HASH_VALUE SQL_TEXT ------------- --------------- ---------------------------------------- 0xzhrtn5gkpjs 272002086 SELECT /* TARGET SQL */ * FROM dual The plan_hash_value is included here for convenience. You can also find the SQL_ID in the V$SQL view using a substitution variable: SELECT sql_id, plan_hash_value, SUBSTR(sql_text,1,40) Text FROM v$sql WHERE sql_text LIKE '%&An_Identifiable_String%'; If SQL is no longer available in v$sql, you can find i...

ORA-30013 is the error reported when the specified Undo tablespace is in use. In other words, this implies there are some background processes still using the undo tablespace.   This error can be reported in both space management or transaction management.   Error ORA-30013 reported while dropping the Undo tablespace.   In this case, the Undo tablespace is used by other active transactions, leading to the error. In such cases, we have to wait until the transactions are committed or rolled back before dropping the Undo tablespace. This situation is similar to that of the ORA-1548 case. Error ORA-30013 reported while bringing up the database.   This happens for RAC databases while the undo tablespace mentioned for an instance is already in use. The solution will be to set separate Undo tablespace for all instances.   Since undo_tablespace is an instance local parameter, we have to ensure that the "Alter system set undo_tablespace" is being invo...

How to Move File System To ASM & ASM To File System Here you go, guys!!! if use 12c you can online move a datafile SQL> show parameter create NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ create_bitmap_area_size              integer     8388608 create_stored_outlines               string db_create_file_dest                  string      /oradata2 db_create_online_log_dest_1          string db_create_online_log_dest_2          string db_create_online_log_dest_3          string db_create_online_log_dest_4    ...