Skip to main content

The Cool Fox

Oracle Cloud Technologies Blog

Home
Site Map
Oracle OCI
Oracle OIC
Oracle VBCS
Oracle Fusion
Oracle VBS
Oracle ADF
Oracle SOA
Oracle Apps
Oracle OAF
Oracle SQL

Showing posts with the label SQL

Posts

[Fusion] How/Why to use PARTITION BY in Oracle SQL (GL BALANCE example)?

on May 29, 2024

Oracle Fusion Oracle Fusion ERP Oracle Fusion Financials Oracle SQL SQL SQL Queries

+

Get link
Facebook
X
Pinterest
Email
Other Apps

Dealing with Locked Session & DB Objects in Oracle

on November 23, 2023

Database EBS oracle ebs Oracle SQL R12 SQL SQL Queries

+

Get link
Facebook
X
Pinterest
Email
Other Apps

All Categories

Account Hierarchy1 Accounting Flexfields1 API2 ASCII1 BIP6 BIP Refresh Time1 Call Fusion BIP Report2 Change Password1 Code Combinations2 Compute Instance1

Database1 DB Adapter2 Development1 EBS3 ESS Jobs3 Examine1 FBDI3 Fusion BIP2 GIT2 GL3 GL Journals1 GL_DAILY_CONVERSION_TYPES1 GL_DAILY_RATES1 ICS1 Identity Domain1 Integrations1 Java1 Journal Import1 Keys1 LookupTypeLOV1 LOV1 LOVs1 MultiPartAPIs1 NVL2 NVL in OIC2 OCI4 OCI Compute2 OCI Events Service1 OCI Free Tier2 OCI Notifification Service1 OIC Mapper1 Oracle9 Oracle ADF17 Oracle APEX1 Oracle Apps55 Oracle Apps R122 Oracle BIP5 Oracle Cloud7 Oracle Cloud Free Tier1 Oracle cloud Infrastructure4 Oracle Cloud Security1 Oracle Cloud VM1 oracle ebs3 Oracle ERP1 Oracle ERP Adapter2 Oracle ERP Cloud6 Oracle financials2 Oracle Forms1 Oracle Fusion44 Oracle Fusion ERP10 Oracle Fusion Financials10 Oracle Integration Cloud3 Oracle OAF14 Oracle OCI9 Oracle OIC18 Oracle SOA 12c10 Oracle SQL9 Oracle VBCS1 Oracle VBS2 Oracle Visual Builder Cloud Service1 Oracle Visual Builder Studio2 Oracle Workflow Notifications1 Others10 Properties1 R121 Register BIP as ESS Job1 Reset Password1 Responsibility1 REST1 Site Map1 SOAP2 SOAP API2 SOAP UI3 SQL7 SQL Queries6 SQL Query2 SSH1 Value Sets1 VBCS1 Virtual Machine1 Virtual Machines1 XML1 XSLT1

Show more Show less

Gurpreet Singh - Oracle ACE.

Total Pageviews

Search This Blog

Popular Posts

Fix java.lang.OutOfMemory Java Heap Space error in JDeveloper

Why out-of-memory error is thrown? Permanent Generation: The Permanent Generation is where class files are kept. These are the result of compiled classes and JSP pages. If this space is full, it triggers a Full Garbage Collection. If the Full Garbage Collection cannot clean out old unreferenced classes and there is no room left to expand the Permanent Space, an Out‐of‐ Memory error (OOME) is thrown and the JVM will crash. There are three basic JVM command switches that control the amount of memory in the Java heap. -XX:Xms -XX:Xmx -XX:MaxPermSize -XX:Xms used to set memory available to JVM initially. -XX:Xms used to set maximum amount of memory into which the JVM can grow . -XX:MaxPermSize are used to set size for Permanent Generation. Fixing out-of-memory error Find the location of Oracle Middleware Home. Click here to see Navigate to the location: <Oracle_Middleware_Home_Location> \ jdev\bin and open the file jdev.conf Add the be

Clearing Oracle JDeveloper temp and cache directory with hotkeys

Oracle JDeveloper keeps on creating temp, cache and history files. So as a best practice to boost up your JDeveloper performance keep deleting the files frequently. Every time you can't go these directories to manually delete the files, so you can assign hotkeys to perform this delete operation. Follow the below steps to setup hotkeys: Goto run command and type prefetch and hit the OK button Copy the location of this directory, like in our case the below location Goto run command and type prefetch and hit the OK button Copy the location of this directory, like in our case the below location Goto Help -> About -> Properties Tab and search for ide.system.dir this is system directory In the system directory, there are two directories which need to be cleaned: .diagnostics and .history Now create the following batch file (.bat) with above-copied directories. Make sure you are using correct system directory

Change the priority of Oracle JDeveloper to improve performance

You can change the priority of Oracle JDeveloper to improve performance. To change performance follow these steps: Open the task manager. Click on Processes Tab Now right click the JDeveloper process and set the priority to either Realtime or High

[VBCS] Creating Oracle Visual Builder Cloud Service (VBCS) instance?

Oracle Visual Builder Cloud Service (VBCS) is a cloud-based development platform that allows developers to rapidly create and deploy web and mobile applications with a low-code approach. Use Cases: Custom Application Development - For organizations looking to develop tailored applications quickly without extensive coding. Extension of Oracle SaaS Applications - Enhancing and extending the capabilities of existing Oracle SaaS applications like Oracle Fusion Applications. Rapid Prototyping - Quickly building and iterating on application prototypes to validate ideas and gather feedback. To start working with VBCS, we need an instance. There are two ways we can provision VBCS instance, by: Enabling VBCS for an OIC instance Creating standalone VBCS instance Enabling VBCS for an OIC instance Login to the OCI console and navigate to already created OIC instance. Follow this link to know how to create OIC instance. Below is the instance that we have already created In the resour

Changing preference to open pages in Source View instead of Design View in Oracle jDeveloper

Whenever we open files like JSP Page Fragments, JSP Pages, HTML code, etc. they always open in Design view instead of source code which makes large files or files with many components to load slower. So, do we have any way which enables Jdeveloper to open files directly in Source Code view instead of opening the Design editor? Yes, we can change this default setting. To change this setting follow these steps: Go to Tools Menu, then click Preferences Preferences dialog will appear. In files Files Types section, switch to Default Editors Tab. Select the file type for which you want to change the default editor and then change the editor from Default Editor drop down at the bottom. For example, here we have changed the default editor of JSP Source file type to Source. So from now whenever you open any file of type JSP Source, JDeveloper will open its source code instead of design view.

Powered by Blogger

All rights reserved