we recently upgraded our db from 11g to 12c, now db with 12.2 version on linux. the db is mostly of oltp type, having around 150GB application data and tables having approx 5GB to 10Gb in size, after upgradation the performance of db is degraded, we believe we can improve that by changing db parameters. Can you pls suggest any oracle parameters to look for to improve performance apart from memory related. and any parameters specific to 12.2 version ?
ORACLE 12c parameter to change , as db performace is a bottleneck with default parameters
284 Views Asked by RUDRA PARIDA At
1
There are 1 best solutions below
Related Questions in ORACLE
- sqlplus myusername/mypassword@ORCL not working with Oracle on Docker
- Oracle setting up on k8s cluster using helm charts enterprise edition
- Oracle Managed Data Access Client can't work from IIS but work for local debug environment
- If composite indexing created - indexing is called?
- Oracle Http server ISNT-07551
- why here not creating table?
- Data migration from Oracle Database Clob to GCP Bucket
- SQL Alchemy custom type, forcing blob bind parameter
- How to send message to syslog agent in plsql
- Whatever the data available in previous record it should add to the new record
- I have an Oracle SQL query that is giving me a "ORA-00918: column ambiguously defined" error on a line that is a comment line
- 'ORA-12170: TNS:Connect timeout occurredORA-12170: TNS:Connect timeout occurred' ERROR while working on oracle with laravel
- Is their any way i can open parallel query tabs
- VSCode Libraries not showing for New Java Project
- I can't ssh to my instance, Connection refused
Related Questions in ORACLE12C
- How to use CONNECT BY in Oracle with columns that contain strings with forward slashes
- Yii2 - Oracle performance issue when getting one row by a unique field
- Pivot statement randomly produces NULL valued columns (Oracle 12c)
- Validate datatype stored in VARCHAR2 column
- No data source definition was found for data source name: 'StorePrimary'. Oracle Retail Xstore POS Dev Setup
- Oracle catch exception code given at runtime
- Oracle's SDO_NET.FIND_CONNECTED_COMPONENTS fails with 'wrong number or types of arguments in call'
- Clone schema within same database
- Oracle PL_SQL set execution timeout
- Error while exchanging partition in Oracle ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION
- Oracle impdb command throws ORA-12154 error, but sqlplus and sql developer are working properly
- Oracle xQuery merge two xml matching nodes
- Oracle 12c impdp ORA-12154: TNS:could not resolve the connect identifier specified
- Get new password from OraOLEDB Password Change Dialog
- Fetch/Update the amount value from previous record based on date
Related Questions in DATABASE-ADMINISTRATION
- Moving LOB size more than actual size
- import dump in oracle database
- SQL Server Replication - Transactional
- Create a one computer/one user relationship to permissions on a database
- Grant Alter to Only to All Functions on SQL Server
- Oracle database Undo size not clearing after the dml operation
- How to create specific user security for schemas?
- How to change the password for all Oracle database users?
- OS User on Oracle DBA History views
- How Oracle calculates the db block changes segment metric?
- Is there a way to update 2 values each time calculating data on each row?
- Views Creation Permissions without table Creation Permissions in POSTGRESQL
- Can i set -I ( Quoted Identifier ON ) for all scripts while running through Batch File?
- Cassandra dynamic snitch and dynamic_snitch_reset_interval_in_ms parameter
- Reading system_health*.xel files efficiently
Related Questions in DATABASE-TUNING
- How can I fix MySQL replication lag on Windows when slave_io and slave_sql are both running with 'copy to tmp table' in Slave_SQL_Running_State?
- Oracle Database performance tuning (on database level)
- what should be minimum ratio of dead tuple for a table to be considered for VACUUM FULL in Postgres
- AttributeError: Can't get attribute 'TunerInternal._validate_overwrite_trainable' on <module 'ray.tune.impl.tuner_internal'
- how to tune postgres for IO waits
- Does Automatic tuning in Azure SQL Database reorganize and rebuild indexes?
- Add index and partitioning for Postgress table
- I need to change the temp table to a CTE in part of my Stored Procedure
- SELECT query waiting on DataFileWrite in Postgres
- Tuning Azure Postgres PAAS (100% memory usage)
- Druid Tuning Configuration
- Oracle-Java | Update 6000 rows in 30 Mins to 1 hour| A Non Primary Non Indexed composite key
- Oracle expdp and impdp command?
- Performance issue - max_elapsed_time
- Mysql total time SHOW PROFILE is diiferent from SHOW PROFILES
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Please check wehat is the value of parameter OPTIMIZER_FEATURES_ENABLE i.e. whether you are using 11g optimizer of 12c optimizer. Sometimes 12c optimizer dont perform well along with that check the values of OPTIMIZER_ADAPTIVE_PLANS and OPTIMIZER_ADAPTIVE_STATISTICS. Please refer to this article. I have faced a similar performance issue after migration from 11g to 12.2c, so please share yur feedback after checking these parameter values.