magnusjohanssontuning.wordpress.com
Oracle Tuning | by Magnus Johanssonby Magnus Johansson (by Magnus Johansson)
http://magnusjohanssontuning.wordpress.com/
by Magnus Johansson (by Magnus Johansson)
http://magnusjohanssontuning.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Saturday
LOAD TIME
0.9 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
10
SSL
EXTERNAL LINKS
19
SITE IP
192.0.78.12
LOAD TIME
0.922 sec
SCORE
6.2
Oracle Tuning | by Magnus Johansson | magnusjohanssontuning.wordpress.com Reviews
https://magnusjohanssontuning.wordpress.com
by Magnus Johansson (by Magnus Johansson)
magnusjohanssontuning.wordpress.com
Copy SPM between sqls. | Oracle Tuning
https://magnusjohanssontuning.wordpress.com/2015/08/10/copy-spm-between-sqls
Skip to primary content. Copy SPM between sqls. I came across an interesting blog by Jonathan Lewis, he called it fake baselines. Which basically means that we can take a good plan for a modified sql and transfer it to the original sql. I’ll show you how I used it. This is the sql. The plan looked like this:. I noticed that the IN subquery wasn’t merged, and according to the documentation. What I then did was to check which order the tables was joined and I noticed it started. SQL ID PLAN HASH VALUE CHIL...
New and old histograms an overview (11g and 12c) | Oracle Tuning
https://magnusjohanssontuning.wordpress.com/2015/05/18/new-and-old-histograms-an-overview-11g-and-12c
Skip to primary content. New and old histograms an overview (11g and 12c). Histograms is all about distribution, the more detailed information you give the optimizer the better it will perform. So lets look at an example… We can use the example data that can be installed with the database, we have a schema named SH and a table named products. In that table we have a column named prod category. The data for prod category looks like this:. Some product categories has more products then others. Software...
Adaptive Cursor Sharing | Oracle Tuning
https://magnusjohanssontuning.wordpress.com/2014/08/22/adaptive-cursor-sharing
Skip to primary content. Adaptive cursor sharing is a an interesting feature that came in version 11g, this is an example that shows how it works. Let’s create a table to use. Create table spm as select * from dba objects; create index spm idx1 on spm (owner); exec dbms stats.gather table stats(ownname= NULL,tabname= 'SPM', method opt= 'for all indexed columns size 254'). Okay we now have some data to work with. Select owner,count(owner) from spm group by owner order by 2;. Declare the bind variable vari...
Magnus Johansson | Oracle Tuning
https://magnusjohanssontuning.wordpress.com/author/magnusjohanssondba
Skip to primary content. Skip to secondary content. Author Archives: Magnus Johansson. Poor Performance related to ADS (Part2). Why do I need a part two? Well in part 1 i said that “I’m (almost) sure we suffered from Very Long Parse Time for Queries in In-Memory Database (Doc ID 2102106.1).”. Continue reading →. Poor Performance related to ADS (Part 1). We experienced an issue of spinning cpu. Which required us to apply a one of patch,. At the same time we applied the latest PSU. Continue reading →.
Oracle Tuning | by Magnus Johansson | Page 2
https://magnusjohanssontuning.wordpress.com/page/2
Skip to primary content. Skip to secondary content. Newer posts →. Buffer busy waits during inserts. During a batch job we noticed we had several sessions suffering from buffer busy waits. Many sessions was running the same insert, one was related to auditing user logon. We could see the pattern several days back. Continue reading →. ORA-1652: unable to extend temp segment when doing insert. Continue reading →. Result Cache “wrong result”. I have a post. The result from the result cache was wrong. Log Fi...
TOTAL PAGES IN THIS WEBSITE
10
Howto know the processor type (Power 5, power6 or power7) on AIX | Luis's Blog
https://luiscalvolopez.wordpress.com/2016/01/20/howto-know-the-processor-type-power-5-power6-or-power7-on-aix
My technical work (Oracle Database, Scripting, Linux, etc …). Howto know the processor type (Power 5, power6 or power7) on AIX. Lsattr -E -l proc0. Output should be similar to:. Frequency 3000000000 Processor Speed False smt enabled true Processor SMT enabled False smt threads 4 Processor SMT threads False state enable Processor state False type PowerPC POWER7 Processor type False. Always check the OS level (version) using:. January 20, 2016. Posted by Luis on January 20, 2016. Leave a Reply Cancel reply.
January | 2016 | Luis's Blog
https://luiscalvolopez.wordpress.com/2016/01
My technical work (Oracle Database, Scripting, Linux, etc …). All posts for the month January, 2016. How to move your ubuntu to another computer. Step 1: Store the list of installed packages. Run the following command on the source machine to store the installed packages names in. Sudo dpkg - get-selections sed "s/.*deinstall/ " sed "s/install$/ g" /pkglist. Step 2: Transfer your config. Or even a flash drive to transfer your home directory (. The source list (. From the source machine to the target one.
Check CRC errors on Emulex HBA | Luis's Blog
https://luiscalvolopez.wordpress.com/2016/02/24/check-crc-errors-on-emulex-hba
My technical work (Oracle Database, Scripting, Linux, etc …). Check CRC errors on Emulex HBA. The command to check that on each HBA port:. You’ll see something like this. And watch for that Invalid CRC count to increase. This indicated either the HBA or fibre channel wire are having issues. I would start by replacing the wire…. Check http:/ www.emulex.com/files/solutions/oracle/pdfs/using-oracle.pdf. February 24, 2016. Posted in Oracle Database. Posted by Luis on February 24, 2016. Enter your comment here.
NUMA related | Luis's Blog
https://luiscalvolopez.wordpress.com/2016/01/20/numa-related
My technical work (Oracle Database, Scripting, Linux, etc …). Nfob is a variable used to determine the size of numa pool size parameter. Nfob=1 ( 0.1*nprocs)*nfiles). January 20, 2016. Posted in Oracle Database. Posted by Luis on January 20, 2016. Https:/ luiscalvolopez.wordpress.com/2016/01/20/numa-related/. Ssh still ask for password in spite of a passwordless configuration. Obtain all locks and resource information from a RAC instance (also works for standalone). Leave a Reply Cancel reply. Christoph&...
Obtain all locks and resource information from a RAC instance (also works for standalone) | Luis's Blog
https://luiscalvolopez.wordpress.com/2016/01/20/obtain-all-locks-and-resource-information-from-a-rac-instance-also-works-for-standalone
My technical work (Oracle Database, Scripting, Linux, etc …). Obtain all locks and resource information from a RAC instance (also works for standalone). This will dump all information needed to locate locks and resources hold on different instances:. Sqlplus "/ as sysdba" oradebug setmypid oradebug unlimit oradebug -g all lkdebug -A res oradebug -g all lkdebug -A lock oradebug -g all hanganalyze 3 oradebug -g all dump systemstate 267 quit. Destinations for new files. Lkdebug -O 0x0 0x0 CF. Please log in ...
ssh still ask for password in spite of a passwordless configuration | Luis's Blog
https://luiscalvolopez.wordpress.com/2016/01/20/ssh-still-ask-for-password-in-spite-of-a-passwordless-configuration
My technical work (Oracle Database, Scripting, Linux, etc …). Ssh still ask for password in spite of a passwordless configuration. You are trying to configure a linux account so it can be used as RAC owner for software install. You has followed all steps:. Created the rsa and dsa keys. Added the pub keys to the authorized keys file of the current node and the rest of nodes. Checked that permissions for. Is 700 and for. However the problem persists. You try to debug the sshd client and copy. As default va...
February | 2016 | Luis's Blog
https://luiscalvolopez.wordpress.com/2016/02
My technical work (Oracle Database, Scripting, Linux, etc …). All posts for the month February, 2016. Check CRC errors on Emulex HBA. The command to check that on each HBA port:. You’ll see something like this. And watch for that Invalid CRC count to increase. This indicated either the HBA or fibre channel wire are having issues. I would start by replacing the wire…. Check http:/ www.emulex.com/files/solutions/oracle/pdfs/using-oracle.pdf. February 24, 2016. Posted in Oracle Database. Jon Adams, OCP, MCTS.
Hang Stuff: V$Wait_Chains, Procwatcher, Hanganalyze, and Systemstate Dump Levels | Luis's Blog
https://luiscalvolopez.wordpress.com/2016/01/20/hang-stuff-vwait_chains-procwatcher-hanganalyze-and-systemstate-dump-levels
My technical work (Oracle Database, Scripting, Linux, etc …). Hang Stuff: V$Wait Chains, Procwatcher, Hanganalyze, and Systemstate Dump Levels. This is taken from an email from Mike Polanski. There are many good alternatives to getting huge systemstate dumps in v11 that impact the customer’s system far less. I wanted to take this opportunity to mention some…. 8211; Troubleshooting Database Contention With V$Wait Chains. However, it turns out the reason for the excessive systemstate times at levels 266 an...
How to move your ubuntu to another computer | Luis's Blog
https://luiscalvolopez.wordpress.com/2016/01/20/how-to-move-your-ubuntu-to-another-computer
My technical work (Oracle Database, Scripting, Linux, etc …). How to move your ubuntu to another computer. Step 1: Store the list of installed packages. Run the following command on the source machine to store the installed packages names in. Sudo dpkg - get-selections sed "s/.*deinstall/ " sed "s/install$/ g" /pkglist. Step 2: Transfer your config. Or even a flash drive to transfer your home directory (. The source list (. And any other files you customized or installed (like apache config under. Christ...
Little Tips | Luis's Blog
https://luiscalvolopez.wordpress.com/about/littletips
My technical work (Oracle Database, Scripting, Linux, etc …). To enable an OS X application to be run without the annoying message:. 8220;App can’t be opened because it is from an unidentified developer”. You should use spctl (man spctl). Spctl - add - label "VIP Access" /Applications/VIP Access.app/ $ spctl - assess -v /Applications/VIP Access.app/ /Applications/VIP Access.app/: accepted source=VIP Access. Christoph's 2 Oracle Cents. Matthew Walden - Oracle DBA. Bdt's oracle blog. Jorge Barba Oracle Blog.
TOTAL LINKS TO THIS WEBSITE
19
DJ Magnus Johanson
Magnus Johanssons Webbshop
0 produkter - 0,00Kr. Din varukorg är tom! Du kan logga in. Din musikshop på nätet magnusjohansson.info. Magnus Johanssons Webbshop 2015.
Home
FaLang translation system by Faboba. Is a front-end framework of Twitter, Inc. Code licensed under MIT License. Font licensed under SIL OFL 1.1.
www.MagnusJohansson.se
Vem är jag - Junior. Magnus Johansson är en it och lantbruks- intresserad agronom. Är uppväxt på en växtodlingsgård och mitt stora intresse ledde till agronom- utbildingen. Har läst på SLU och är teknikagronom med växtodlings- inriktning. Lantbrukare med växtodling. Jobbar också som redovisningskonsult med inriktning mot jord och skog. Är intresserad av film och musik. Vintertid åker jag gärna skidor. Jagar även ibland. Magnus(snabel a) magnusjohansson.se.
magnusjohanssondba.wordpress.com
magnusjohanssondba – Just another Oracle DBA blog
Just another Oracle DBA blog. How to …. Inside the Oracle Optimizer. My profile on LinkedIn. Cannot insert duplicate key in object ‘dbo.D PAR PARTS’. Continue reading “Cannot insert duplicate key in object ‘dbo.D PAR PARTS’”. ORA-1803 using DBMS SCHEDULER. Helping a customer I was creating a job running a procedure I created. Running the procedure in sql*plus was no problem, but when I scheduled it I got the following error. Continue reading “ORA-1803 using DBMS SCHEDULER”. Error when creating table.
magnusjohanssontuning.wordpress.com
Oracle Tuning | by Magnus Johansson
Skip to primary content. Skip to secondary content. Testing application sql and maintaining the sql id. I often analyze sql from Siebel that performs poorly. I always try to reproduce the execution plan outside the application to be able to work with the performance issue. Continue reading →. Copy SPM between sqls. I came across an interesting blog by Jonathan Lewis, he called it fake baselines. Continue reading →. Log File Sync Issue (Part 2). Continue reading →. Continue reading →. While doing a health...
Magnus Johnson
Website Designed at Homestead Design a Website. And List Your Business.
Magnus Johnsson - Research on Artificial Intelligence, Computational Cognitive Neuroscience, Cognitive Robotics, Philosophy
Cognitive Scientist, Computer Scientist. Denna sida på svenska. I'm a cross-disciplinary scientist. Though I have degrees I'm also to a large extent an autodidact. My research interests are wide and include, but are not limited to, computer modelling, artificial neural networks, artificial intelligence, cognitive neuroscience, cognitive robotics, data science, cognitive architectures, cognitive aids and the philosophy of mind. Within cognitive neuroscience, you study how the brain enables mental phenomen...
magnusjohnstone.com
Welcome to: magnusjohnstone.com. This Web page is parked for FREE, courtesy of GoDaddy.com. Search for domains similar to. Is this your domain? Let's turn it into a website! Would you like to buy this. THE domain at THE price. Visit GoDaddy.com for the best values on. Restrictions apply. See website for details.
magnusjolnaes.dk - Tine, Nora og Magnus på tur
Tine, Nora og Magnus på tur. Skisportssteder og varme kilder. Med Rocky Mountain bag os bød de kommende dage Læs mere. Farvel til Rocky Mountains. Torsdag sagde vi farvel til Rocky Mountains, og satte kursen Læs mere. Verdens mest spektakulære køretur. The World’s Most Spectacular Journey. Det er, hvad Parks Canada Læs mere. Tre dage i Banff. Banff Det var her turen for alvor skulle i gang, Læs mere. Første møde med bjerge. Calgary var lækkert – alt taget i betragtning – men Læs mere. Tre dage i Banff.
Magnus Jonasson.com
Teknisk projektledare på Light Tower AB. En av rösterna i poddcasten. En podd om teknik. En av rösterna i poddcasten Till den det berör. Jag heter Magnus Jonasson och arbetar till vardags som teknisk projektledare på Light Tower AB. När jag inte arbetar hörs jag istället som en av rösterna i två podcasts, del Sveriges främsta teknikpodcast En podd om teknik. Där vi varje vecka snackar om prylar och ny, spännande teknik men också i Till den det berör. En humorpodd där vi snackar om allt som berör. Det är ...
