Blog

All categories and ta

Read more

OAC documenation: https://docs.oracle.com/en/middleware/bi/analytics-server/datamodel-oas/create-and-manage-level-based-hierarchies.html Oracle OAC blog: https://blogs.oracle.com/analytics/post/oracle-analytics-best-practices-for-dimensional-hierarchies-level-keys-and-content-levels OAC best practices: https://blogs.oracle.com/analytics/post/oracle-analytics-best-practices-series-optimal-performance-and-usage

Read more

https://docs.oracle.com/en/database/oracle/oracle-database/19/inmem/populating-objects-in-memory.html In-Memory activation at CDB level alter system set heat_map=ON scope=spfile;alter system set db_keep_cache_size=400M scope=spfile;alter system set inmemory_size=400M scope=spfile;alter system set inmemory_max_populate_servers=4 scope=spfile;alter system set inmemory_virtual_columns=enable scope=spfile;alter system set “_inmemory_64k_percent”=5 scope=spfile;alter system set “_inmemory_small_segment_threshold”=0 scope=spfile;alter system set “_optimizer_use_feedback”=FALSE scope=spfile;alter system set “_imado_enable_coloptim”=FALSE scope=spfile; This will give 400MB to the keep pool cache and 400MB to

Read more

Select t.owner,t.table_name,to_char(nvl(sum(s.bytes),0) / 1024 / 1024 , ‘9999999.99’) mbfrom dba_tables t,dba_segments swhere –t.table_name not like ‘DECOM_%’ escape ‘\’ — does not start with decom_— t.owner = :schemas.owner(+) = t.ownerand s.segment_name(+) = t.table_nameand nvl(s.bytes,0) > 10000000group by t.owner, t.table_nameorder by 2 desc; select nvl(tablespace_name,’ – Total – ‘) tablespace_name,round(sum(bytes)/1024/1024/1024,1) as size_in_GBfrom dba_segmentswhere tablespace_name not in (‘SYSAUX’,’SYSTEM’)group

Read more

YouTube videos by Oracle https://www.youtube.com/@OracleAPEX Blogs https://blogs.oracle.com/apex/ https://videohub.oracle.com/esearch/search?keyword=apex   (some non-English content also) APEX documentation https://docs.oracle.com/en/database/oracle/apex/index.html  APEX discussion forum  https://forums.oracle.com/ords/apexds/domain/dev-community/category/apex APEX community https://apex.oracle.com/pls/apex/f?p=411:18

Read more

How to use SNOWSPARK with Python,Java, Scala, Javascript  and External Functions https://community.snowflake.com/s/topic/0TO3r000000oXQvGAM/snowpark Snowflake SQL forum https://community.snowflake.com/s/topic/0TO31000000k9zhGAA/sql Migrations https://community.snowflake.com/s/topic/0TO3r000000bskFGAQ/migrations Snow Sight  UI https://community.snowflake.com/s/topic/0TO3r000000buDqGAI/snowsightui Ask Me Anything https://community.snowflake.com/s/topic/0TODo0000004PuAOAU/ask-me-anything

Read more

Instead of clicking on links in this blog, copy/paste it. Oracle Global Leaders Technical Series These videos are not on YouTube https://go.oracle.com/LP=105660 ====================================================== VIDEOHUB.ORACLE.COM Oracle’s Videohub has many playlists and channels. These videos are not on YouTube. For example Analytics channel is at: https://videohub.oracle.com/channel/Oracle%2BAnalytics%2BEnablement/ ============================================== Oracle Autonomous database playlists including New features and get started

Read more

Excerpt fourth post ……………. ………………. ……….. ……………. …………. ……………… ………….

Read more

Steps to create Master-Child report

Read more