Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Blog Directory  >  Software Blogs  >  Techgoeasy - Learn Oracle, PHP, HTML,CSS,Perl,UNIX software Blog  > 

2024-02-03 09:46
We will be discussing Oracle create tablespace statement/oracle create tablespace 11g/12c/19c in detail in this post. I will through light on all the option on create tablespace statement.I… Read More
2024-02-02 10:13
External table is one of the important feature in oracle , we will exploring external table in oracle with example in this post What are EXTERNAL TABLES in Oracle? 1)External tables are… Read More
2024-01-31 08:58
What is Hotpatch mode in R12.0/R12.1? We add hotpatch to the adpatch option list to apply the patches in the environment without putting it into Maintenance Mode.  This was quite widely… Read More
2024-01-24 09:27
New Optimizer Feature with 11g (1) Invisible indexes With an 11g release, the index can be made invisible. They will be maintained all the time and can be made visible at any time alter inde… Read More
2024-01-23 09:21
In this post, we will discuss the Flashback technology in Oracle, its architecture, Oracle  Flashback query, the syntax to use Oracle  Flashback query What is Flashback technology… Read More
2024-01-11 12:44
Types of jobs and their resolutions .odf files : -odf files are there to create tables, indexes and views etc.-If encountered locking, identify the session that holds the lock and kill the s… Read More
2024-01-11 12:31
How Incremental statistics works Incremental global statistics work by storing a synopsis for each partition in the table. A synopsis is a statistical metadata for that partition and the col… Read More
2024-01-10 10:43
We have touched upon many unix commands before in the previous article. Here are some more commands with downloadable basic unix commands pdf   mv – move files(s) /dirs Optio… Read More
2024-01-07 14:09
INTRODUCTION TO FNDLOAD CONFIGURATION FILE The contents of the configuration file are at the heart of the loader operation since they specify the structure of the data and the access methods… Read More
2023-12-27 17:14
Many times questions are being asked about how to find the Oracle database version and version of various Oracle utilities in Linux, Solaris, AIX, and Windows. Let’s check out how is t… Read More
2023-12-21 15:59
We may get a failure while running the managed backup on the ExaCS system. Let’s see how to troubleshoot these backup failures (1)Identification of the error We need to first find out… Read More
2023-11-15 09:14
Essbase 21c is the latest version of Oracle essbase. It is the first release after 11.1.2.4 where Oracle is giving the option of installing on the on-prem machine. New Feature in Essbase 21c… Read More
2023-10-05 05:09
Oracle 23c is the latest Release of Oracle Database. Oracle has introduced lot of new features in it. Here are the Top Features Developer-Friendly Features Oracle has been adding features to… Read More
2023-10-02 03:34
Sometimes users get performance issues during various pages in the Oracle Apps application. We need to take the trace of the problem in order to identify the bottleneck We can execute the be… Read More
2023-09-14 06:25
Here are some of the top SQL Patch Queries in Oracle Database Query to Query to find the hints associated with a SQL Patch select cast(extractvalue(value(x), '/hint') as varchar2(500)) as ou… Read More
2023-09-12 03:53
In this article, we check about How to Configure Auto Login TDE Wallet. When we configure the TDE wallet, we need to explicitly open it after each database restart. ADMINISTER KEY MANAGEMENT… Read More
2023-09-08 11:43
What is Sequence in Oracle? Oracle Sequence is a user-created object which can be shared by multiple users to generate unique integers The most general use of sequences would be to generate… Read More
2023-09-06 09:26
What is Coalesce Function Coalesce Function is a useful function in oracle and it is very useful when we want to return the first non-null values in the list. This SQL tutorial provides expl… Read More
2023-09-06 04:56
Introduction to Oracle Database Cloud Service (OCI Database Services) Oracle database cloud service is a service of Cloud Category PaaS. It enables businesses to reap all the benefits of Pla… Read More
2023-08-04 13:14
Oracle Database Packages are widely used in EBS R12. We have thousands of Packages in the Apps schema. These packages are loaded and modified in the Oracle database using adpatch or adop usi… Read More
2023-07-31 03:06
A SQL Tuning Set (STS) in Oracle is a database object that includes one or more SQL statements along with their execution statistics and context. It provides a means to store SQL statements… Read More
2023-06-18 17:14
We must have felt the pain when you have applied multiple patches and each time you have to give Y to the prompt in opatch. There is a solution available to this problem How to run Opatch in… Read More
2023-06-16 09:54
SQL Plan Management (SPM) in Oracle is a preventative mechanism that provides a level of control over the execution plans used by the Oracle optimizer. It ensures that regression due to chan… Read More
2023-06-06 08:42
Here are some very useful queries on Sql plan Management How to check the sql plan parameter show parameter sql_plan How to check the settings for Automatic plan capture If OPTIMIZER_CAPTURE… Read More
2023-06-02 08:14
You can drop a SQL Plan Baseline in Oracle using the DBMS_SPM.DROP_SQL_PLAN_BASELINE function. DBMS_SPM.DROP_SQL_PLAN_BASELINE ( sql_handle IN VARCHAR2 := NULL, plan_name IN VARCHAR2 := NULL… Read More
2023-05-12 09:13
Oracle has provided a procedure VERIFY_STATS in the FND_STATS package to verify stats for the table in EBS This procedure reports the statistics in the data dictionary tables for the tables… Read More
2023-05-11 08:07
The STATISTICS_LEVEL parameter was introduced in Oracle version 9 (9.2) to control allmajor statistics collections or advisories in the database. The level of the setting affects thea number… Read More
2023-05-04 08:05
We can import statistics from the user statistics table identified by stattab and stored in the data dictionary. Basically you can import the statistics which you exported some time bef… Read More
2023-05-03 10:37
To export statistics in Oracle, you can use the DBMS_STATS package. This package provides several procedures and functions for managing database statistics. Here are the basic steps: (1) Con… Read More
2023-05-02 06:43
We can create a stat table in Oracle that can be used to store statistics of the schema, tables, and indexes. In this post we will see how to create and drop the stat table in Oracle, and wh… Read More
2023-04-13 22:37
As we know that DBMS_STATS takes a backup of the statistics every time dbms_stats is run on the table. So we can restore the statistics from the backup. Let’s see a few important thing… Read More
2023-04-11 22:27
Suppose you want to remove the optimizer preference you set on the schema, table, or database, then the below procedure can be used to do that How to delete table level Optimizer preference… Read More
2023-04-09 22:15
Here are some frequently used queries for histograms in Oracle How to check the endpoint values for the histograms SELECT ENDPOINT_NUMBER, ENDPOINT_VALUE, COLUMN_NAME FROM DBA_HISTOGRAMS WHE… Read More
2023-04-08 06:10
Histograms are required for skewed data, so it is required in the Oracle EBS database also. Histograms tell the CBO when data is not evenly distributed and can help the CBO to estimate the n… Read More
2023-04-02 15:45
To check the java version: java -versionjava version "1.8.0.107"Java(TM) 2 Runtime Environment, Standard Edition (build 1.8.0.107-_12_jan_2007_03_27)Java HotSpot(TM) Server VM (build 1.8.0.1… Read More
2023-04-01 22:18
What is PREFERENCE_OVERRIDES_PARAMETER We discussed optimizer statistics preferences in the previous blog post and we know that that got overwritten by the values given explicitly in the dbm… Read More
2023-03-30 22:38
What are optimizer statistics preferences? The statistics preferences of the optimizer determine the preset values of the parameters used by automatic statistics collection and the DBMS_STAT… Read More
2023-03-29 22:11
When we ran gather stats on the table, it generate table stats, index stats, and column stats. Column statistics are used in the optimizer’s selectivity calculations Let’s see ho… Read More
2023-03-28 22:41
Indexes are used to fasten access to the record in Oracle. Optimizer chooses an index over a full table scan based on the Index statistics. The statistics allow the optimizer to calculate th… Read More
2023-03-22 10:16
Many times, you might need to determine the segment name given the file id and block number. The below query can be used for that SELECT segment_name, segment_typeFROM dba_extentsWHERE file_… Read More
2023-03-21 10:46
When a user issues a sql query to the Oracle engine, the below illustration is worked out Here is how this works (1) Users issue SQL statements via your client tool SQL*Plus or SQL Developer… Read More
2023-03-16 10:08
10053 trace is the optimizer trace. It externalizes most of the information that the optimizer uses in generating a plan for a query. In this post, we will check out How to enable 10053 trac… Read More
2023-03-15 10:14
Sometimes a sql_id might show a different plan because of a particular value of the bind variable. So we would like to find out the bind variable. Also, we might want to know the bind variab… Read More
2023-03-13 10:00
EBS R12 is supported in Multitenant mode for Oracle Database 19c. If you try to generate a tkprof report explain plan generation on the Database, you will errors for the Invalid username /pa… Read More
2023-03-12 10:09
We saw how to enable trace in an earlier post. The trace files obtained from the method is in raw  form which can be converted into a more readable format using the tkprof utility … Read More
2023-03-11 10:00
This can be easily done using the find command. The general syntax is find . -type f -size + -exec ls -al {} \; Here are the suffixes available for the size b – 512-byte blocks (this i… Read More
2023-03-11 06:35
Tracing is an important part of Oracle database tuning. This will help capture all the problem statements and waitevents that are responsible for the slow running of the session. Oracle data… Read More
2023-03-10 15:58
We often need to replace strings in a file or multiple files in a Unix system. This can be done easily using the sed command. we can easily replace the strings in multiples in a very short s… Read More
2023-03-05 10:48
Password version is a new column in DBA_USERS starting 11g. The PASSWORD_VERSIONS column shows the list of password versions that exist for the account. 10G refers to the earlier case-insens… Read More

Share the post

Techgoeasy - Learn Oracle, PHP, HTML,CSS,Perl,UNIX

×

Subscribe to Techgoeasy - Learn Oracle, Php, Html,css,perl,unix

Get updates delivered right to your inbox!

Thank you for your subscription

×