Some time back, I posted a blog entry about Metering and Chargeback in Enterprise Manager, where I covered the basic capabilities of the Chargeback Application. It’s taken me some time to get back to the promised followup blog post on setting up Chargeback, what with Oracle Open World getting in the way of things, but that’s what I’m finally doing now.
Chargeback can be setup in EM12c by any user with the EM_CBA_ADMIN role, or (more...)
I previously wrote that I peeped the idea about showing the session information in terminal title from Timur Akhmadeev’s screenshots, and Timur wrote:
I’m using (a bit modified) Tanel Poder’s login.sql available in his TPT scripts library: http://tech.e2sn.com/oracle-scripts-and-tools
My title.sql and on_login.sql
Colored prompt is the one of many features of rlwrap.
Connected as simple user:
Connected as sysdba:
SQL*Plus on OEL through putty:
@inc/title “*** Test ***”
I ran the following query on an Oracle 126.96.36.199 database but it failed with an ORA-02020:
SQL> SELECT ppc.sttlmnt_dt day_date
2 FROM vrm_d18_ppc ppc,
3 meter_nhh mtr,
4 mtd_registers reg
5 WHERE ppc.tm_pttrn_rgm = reg.tpr
6 AND TO_NUMBER(ppc.stndrd_sttlmnt_cnfgrtn_id) = mtr.std_stlmnt_config_id
7 AND ppc.prfl_clss_id = mtr.profile_class_id
8 AND ppc.gsp_grp_id = mtr.gsp_group_id
After we upgraded our OMS environment we realized that our Harvester wasn’t uploading data to MOS anymore. Of course, you say, you just replaced your former ORACLE_HOME with a new home for 188.8.131.52.
1. Download p5567658_120030_Linux-x86-64.zip or the latest OCM installer for your environment. You’ll find a tab for downloading OCM on your front page in MOS. While you are there you should also download the Quick Start guide.
2. Unzip (more...)
I’m super looking forward to next weeks DevOps Enterprise Summit in San Francisco. You might ask “Why?!” since I’m a database guy and not a DevOps guy. I can understand that reaction.
I don’t know about you, but when I hear the term DevOps I have to roll my eyes and think “oh, the latest greatest tech industry buzzword.” So why would I as a DBA care about DevOps? With DevOps, as with (more...)
Every once in a while it comes to my attention that edb360 takes several hours to run. What can be done? My advice is to let it run for several hours if possible. In most environment it completes in less that 1 hour, but I have seen cases where it may take 5 or 6. The reason is simple: too many SQL statements to execute. And some of those queries are executed on top of (more...)
I modified the bind variable extraction script that I normally use to make it more helpful to me.
Here was my earlier post with the old script: blog post
Here is my updated script:
set termout on
set echo on
set linesize 32000
set pagesize 1000
set trimspool on
column NAME format a3
column VALUE_STRING format a17
select * from
This one looks like the real thing ... getting advice to "not skip" the patching process for a whole bunch of things included here.
I'm just saying ...
Just a quick note to point out that the October PSU was just released. The database has a few more vulnerabilities than usual (31), but they are mostly related to Java and the high CVSS score of 9 only applies to people running Oracle on windows. (On other operating systems, the highest score is 6.5.)
I did happen to glance at the announcement on the security blog, and I thought this short (more...)
In the last post in this series I discussed some of the various tasks that need to be performed by the flash translation layer – the layer of abstraction that sits between us and the raw NAND flash on which we desire to store our data. One of those tasks is the infamous garbage collection process (or “GC”) – and in these next couple of posts I’m going to look into GC a little deeper.
In a multitenant environment, a common user is a database user whose identity and password are known in the root and in every existing and future pluggable database (PDB). Common users can connect to the root and perform administrative tasks specific to the root or PDBs. There are two types of common users :
- All Oracle-supplied administrative user accounts, such as SYS and SYSTEM
- User created common users- Their names must start with (more...)
Log buffer space is a simple, yet frequently misunderstood wait event. The main reason for that is probably its name. It sounds as if it points immediately to the answer: if space in the log buffer is the issue, then increasing it surely should resolve it. Well, unfortunately even though log buffer space is simple, it’s not that simple.
Log buffer is an area in memory (SGA, to be more specific) where (more...)
When using the Data Guard Broker, you don’t need to set any LOG_ARCHIVE_* parameter for the databases that are part of your Data Guard configuration. The broker is doing that for you. Forget about what you may have heard about VALID_FOR – you don’t need that with the broker. Actually, setting any of the LOG_ARCHIVE_* parameters with an enabled broker configuration might even confuse the broker and lead to warning or error messages. Let’s look (more...)
During one of the classes I taught about Exadata optimisations I had an interesting question:
If I am using VPD, will Exadata still offload the query?
Background is that we discussed function offloading, and the meta-view v$sqlfn_metadata. It turned out that SYS_CONTEXT() is not offloadable in 184.108.40.206.
SQL> select name,datatype,analytic,aggregate,offloadable,descr
2 from v$sqlfn_metadata where name = 'SYS_CONTEXT';
NAME DATATYPE ANA AGG OFF DESCR
-------------------------------------------------- -------- --- --- --- ------------------------------
SYS_CONTEXT UNKNOWN NO (more...)
When I started this blog, almost 6 years ago I had a clear purpose: give back. I had extracted so much useful information from the internet and in early 2009 it was time to give back. Publish my tricks, secrets, tips, etc. I then moved into Oracle and now I can’t disclose everything I know. […]
On a client site recently, experimenting with a T5-2 – fortunately a test system – we decided to restart an instance with a larger SGA. It had been 100GB, but with 1TB of memory and 256 threads (2 sockets, 16 cores per socket, 8 threads per core) it seemed reasonable to crank this up to 400GB for the work we wanted to do.
It took about 15 minutes for the instance to start; worse, it (more...)
I frequently hear of, and see, developers and DBA’s using the NOLOCK hint within SQL Server to bypass the locking mechanism and return their data sets as soon as possible. There are times when this is OK, such as when you are running an ad hoc query and are only interested in approximate results. It is somewhat less OK to write this hint into application code and reports, unless you don’t actually care whether the (more...)
Only two things are really certain: network latency over long distances, and the fact that humanity will soon rapidly degenerate into undead brain-eaters.
When that day comes, when the dead are crowding at your door and the windows are busted out and ripped up rotted arms are clawing at the inside of your home, I know what you’ll be thinking: is my database protected?
Don’t worry, my friends. The Oracle Alchemist has you covered. We (more...)
So in a slight reversal of submit so many presentation abstracts get rejected so many times the Rocky Mountain training days 2015 will be featuring me! Wow pumped yikes this should be a ton of fun!
Ok to be totally honest Maria Colgan is keynoting not me ( shocking news still trying to get over it ).Rocky Mountain training days 2015
Looks like a top batch of speakers and topics ... I only have (more...)
As database gurus and fanatics of the world, as well as hotels and cabbies of San Francisco know, one of the largest enterprise software events, Oracle OpenWorld 2014 was held in San Francisco from September 28th, 2014 to October 2nd, 2014. The reason the later group know a tad bit about the event is because […]
The post Overview of Oracle OpenWorld 2014 appeared first on VitalSoftTech.