|
||||
|
As we all know, optimizer parse the statement to provide a plan, but to provide that Oracle Optimizer has to go through different phases called Parse, Execute, Fetch. 1. Parsing has three phases again, Compiler: Compiles the statement to oracle readable format or oracle understandable state. Estimator: Look out the […] Hello All, This post is specifically for those who works on Amazon Cloud and want to build a RAC on Amazon EC2 Instances (machines). There is a very good article in the AWS Documentation Articles (here), but the linux instances taken and built were very large and per hour it cost around 4$ each […] The issue is there’s a query which executes quickly through 12c client in 12c database where as it is taking longer time when connecting as with 11g Clients to 12c database. The table has a […] Most of us know the result cache is introduced in 11g initially with pl/sql result cache and then the query result cache to store the results of query in a separate memory structures in shared pool. As I do not want to get into how it works, what it do, may be the best start […] Hello, Previous parts in the series we have covered, DB Load Profile, DB Load Profile2, Time Model, IO Performance. In Today’s series, we will see, I cover both current/AWR in one after another below, the scripts are attached and linked for each screenshot for your later use. (It took longer than usual, as such I […] Want to know new features in 12c, 18c, 19c, 20c ??? Follow this More than 100+ features listed here : http://db.geeksinsight.com/category/12c-database/ More than 50+ features listed here: http://db.geeksinsight.com/category/18c-database/ More than 40 features listed here: http://db.geeksinsight.com/category/19c-database/ Upcoming 20c features : http://db.geeksinsight.com/category/20c-database/ Hello, After Looking at identifying Database Load in previous posts (Post 1,Post 2) and seeing […] Hello, This is the second part of the series of Performance Troubleshooting, Whilst the first one is from AWR/Statspack tables. And what if , if you don’t have both in your environment, That made me to write up this second post. Those who does not know about the metrics tables a short notes here, After […] The situation is, and you just logged 🙂 1. DB Response is slow 2. Top/OEM/Graphs show your database host CPU is pegged to 100%, and (no other things running apart from db) 3. Unfortunately you do not have Active Session History, to fire a magical script , 5 minutes back, 10 minutes back, 4. […] Hello, I have been reading in other blog citing that what if lost of a data file scenario. Here are the questions. 1) if in case of system/user datafile lost of Pluggable database, what happens to CDB? ANS: Nothing happens to CDB, it will still running, similar case in non-cdb database if a user data […] Again, OEL 7 (UEK) and 12c Grid Infrastructure issue. OEL UEK 7 does not shipped or support ACFS yet, but we tried and stumbled :(. Here is the log for root.sh failure. ACFS-9317: No ADVM/ACFS distribution media detected at location: ‘/u02/app/11.2.0.2/grid1/install/usm/EL5/x86_64/2.6.18-8/2.6.18-8.el5-x86_64/bin’ root@ol5-112-rac1 ~]# /u02/app/11.2.0.2/grid1/bin/acfsroot install ACFS-9320: Missing file: ‘advmutil’. ACFS-9320: Missing file: ‘advmutil.bin’. ACFS-9320: Missing […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!