What is the difference between the summaries of disk space on these two systems? Look at the free_usable_file_MB column and free space
ASMCMD [+] > lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED NORMAL N 512 4096 4194304 72769536 2031032 433152 798940 0 N DATA_PEX0/
MOUNTED NORMAL N 512 4096 4194304 128286720 20004028 2672640 8665694 0 N DATA_PEX1/
Group Diskgroup Total Req'd Free (more...)
I saw this from an Oracle account manager who I deal with.
Oracle’s regional price lists are based on a constant Dollar based price list, and these are usually recalculated at the beginning of each financial quarter. Given the recent sharp decline in the £ against the $, I’m expecting an increase of roughly 15% for Oracle’s next financial quarter, beginning September.
For illustration, a single Oracle DB EE license has a current GBP list (more...)
I was showing some basic sqlplus connection tips to a new DBA starter today and my normal warning about putting the password on the line when calling sqlplus didn’t produce what I expected.
For ever and a day if you have entered a line within a server session such as when using putty or similar to this :-
and then ‘host’ to the unix shell and run a ps -ef|grep sqlplus you will (more...)
Sometimes you across a blog entry and you think to yourself – ‘I wish I had written that’.
It is clear, it is on a subject you are interested in and the examples help illustrate the points clearly.
Well I did come across just such an article today. It was written by Franck Pachot and was on the subject of SQL Profiles
It was written 18 months ago and has only had 1800 hits. I (more...)
I have recently taken over our Systems Management team and we have several vacancies for people used to working with the HP toolset. I know my blog is read almost entirely by DBAs but I am sure some of you work with Systems management teams and hopefully you can pass a link on to anyone you think might be interested.
The main tools used are
- HP Service manager 9.x
- HP Operations manager for Windows, (more...)
My team has a permanent vacancy which almost anyone could apply for.
We are looking for a good DBA with RAC, RMAN and Dataguard skills
We are thinking that we might wish to take on a Junior DBA who has some skills but maybe not all three listed above.
We would also consider someone who has no real experience – maybe has used RDBMS at University
Whoever we take-on will get a broad experience of (more...)
There is a standard for SQL code known as ANSI-92 which is adopted by many of the main RDBMS vendors. However each vendor has its own differences from the standard.
Oracle are currently taking votes on a proposal to add the CREATE ASSERTION statement to Oracle SQL on the OTN community page https://community.oracle.com/ideas/13028
Here are two examples of how the statement could be used
This SQL statement creates an assertion to demand that (more...)
This isn’t directly Oracle related but it did come to light within an Oracle context
We had a problem with a password file in a RAC cluster and whilst they appeared to be the same on both nodes of a cluster there were issues. I knew we needed to check the size of the files and ensure they were the same but I could not remember the (l)Unix command.
I knew it was to do (more...)
Security asked to determine when certain passwords were last changed and I used the ptime column in user$ table to find out.
set lines 120 set pages 60
col name form a30
col Last_Changed form a12
SELECT name,ptime "Last_Changed"
FROM sys.user$ a, dba_users b
order by 1;
I am sure every DBA has used a kill session script before, although a lot probably use OEM as much now as individual scripts.
However I had not realised there was an option to add a 3rd parameter, the instance _id to the command
For example to kill any DBSNMP connections across all nodes of a RAC database
select 'alter system kill session ''' || sid || ', ' || serial# || ', @' || (more...)