@$ORACLE_HOME/rdbms/admin/awrrpt.sql
@/dboracle/orabase/product/11.2.0.4.2.0/rdbms/admin/awrsqrpt.sql
Chinnakkalai,MK,Mahesh,TAJ C
21:47
979v22zsnjfhf
dm46p0r894pss
djt275c6q6zpx
28/09/2017 08:51:38.029
28/09/2017 07:28:49.455
28/09/2017 07:28:37.445
SELECT DECODE (l.BLOCK, 0, 'Waiting', 'Blocking ->') user_status
,CHR (39) || s.SID || ',' || s.serial# || CHR (39) sid_serial
,(SELECT instance_name FROM gv$instance WHERE inst_id = l.inst_id)
conn_instance
,s.SID
,s.PROGRAM
,s.osuser
,s.machine
,DECODE (l.TYPE,'RT', 'Redo Log Buffer','TD', 'Dictionary'
,'TM', 'DML','TS', 'Temp Segments','TX', 'Transaction'
,'UL', 'User','RW', 'Row Wait',l.TYPE) lock_type
--,id1
--,id2
,DECODE (l.lmode,0, 'None',1, 'Null',2, 'Row Share',3, 'Row Excl.'
,4, 'Share',5, 'S/Row Excl.',6, 'Exclusive'
,LTRIM (TO_CHAR (lmode, '990'))) lock_mode
,ctime
--,DECODE(l.BLOCK, 0, 'Not Blocking', 1, 'Blocking', 2, 'Global') lock_status
,object_name
,s.blocking_session
FROM
gv$lock l
JOIN
gv$session s
ON (l.inst_id = s.inst_id
AND l.SID = s.SID)
JOIN gv$locked_object o
ON (o.inst_id = s.inst_id
AND s.SID = o.session_id)
JOIN dba_objects d
ON (d.object_id = o.object_id)
WHERE (l.id1, l.id2, l.TYPE) IN (SELECT id1, id2, TYPE
FROM gv$lock
WHERE request > 0)
ORDER BY id1, id2, ctime DESC;
==========
SELECT distinct a.sql_id, a.blocking_session,a.blocking_session_serial#,
a.user_id,s.sql_text,a.module
FROM V$ACTIVE_SESSION_HISTORY a, v$sql s
where a.sql_id=s.sql_id
and blocking_session is not null
and a.user_id <> 0
and a.sample_time between to_date('27/09/2017 00:00', 'dd/mm/yyyy hh24:mi')
and to_date('28/09/2017 23:50', 'dd/mm/yyyy hh24:mi');
SELECT a.sql_id,a.session_id,a.session_serial#, a.blocking_session,a.blocking_session_serial#,A.SAMPLE_TIME,
a.user_id,s.sql_text,a.module
FROM V$ACTIVE_SESSION_HISTORY a, v$sql s
where a.sql_id=s.sql_id
and blocking_session is not null
and a.user_id <> 0
and a.sample_time between to_date('28/09/2017 09:00', 'dd/mm/yyyy hh24:mi')
and to_date('28/09/2017 10:30', 'dd/mm/yyyy hh24:mi');
select session_id from V$ACTIVE_SESSION_HISTORY where BLOCKING_SESSION='852';
fx60akn9n2tc0
57nvt1ay0ggt2
select plan_table_output from table (dbms_xplan.display_awr('57nvt1ay0ggt2'));
SQL_ID 57nvt1ay0ggt2
--------------------
DELETE FROM BT_CWK_CONTRACT_EMP_PROV_INFO ContractEmpProvInfoEO WHERE
CONTRACT_EMPLOYEE_ID=:1 AND EFFECTIVE_START_DATE=:2 AND
EFFECTIVE_END_DATE=:3 AND EFF_SEQ=:4
Plan hash value: 3735639707
----------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
----------------------------------------------------------------------------------------------------
| 0 | DELETE STATEMENT | | | | 2 (100)| |
| 1 | DELETE | BT_CWK_CONTRACT_EMP_PROV_INFO | | | | |
| 2 | INDEX UNIQUE SCAN| BT_CWK_CONTRACT_EMP_PROV__PK | 1 | 26 | 2 (0)| 00:00:01 |
----------------------------------------------------------------------------------------------------
DELETE FROM BT_CWK_CONTRACT_EMP_PROV_INFO ContractEmpProvInfoEO WHERE CONTRACT_EMPLOYEE_ID=:1 AND EFFECTIVE_START_DATE=:2 AND EFFECTIVE_END_DATE=:3 AND EFF_SEQ=:4
@$ORACLE_HOME/rdbms/admin/awrrpt.sql
===========
@/dboracle/orabase/product/11.2.0.4.2.0/rdbms/admin/awrsqrpt.sql
=================================================================================
FAO: NFMI SPOCs (cc’d to NFMI Leads)
Subject: Q2 Deadline - Friday 29th September @ 15:00
1. What’s happening?
· The cut-off for Q2 is Friday 29th September 2017 @ 15:00.
2. What do I need to do?
· Ensure all data you need to enter into NFMI has been updated and accurate.
· Review your weekly NFMI SPOC digest and ensure any expiring questions have been updated to prevent them expiring on 1st October.
3. What happens next?
· We’ll gather the results and publish them to the Delivery Directors against the targets defined at the start of the year – this will happen in the next few weeks.
· The NFMI Tool will move into the Q3 period and quarterly targets will reflect what was set in the Q3 glide path.
· If you or your team missed any questions that were due to be refreshed, they’ll be automatically expired and could drop your NFMI score to 0%. This can be easily prevented by dealing with all Expiring or Expired questions before the cut-off – you just have to update them with current status or a note to say they’ve been reviewed.
4. Issues with Run Book storage
· We’ve been made aware that a number of teams have been unable to upload an updated RunBook to the SharePoint location where they’re centrally stored. The location is at its maximum and if correctly managed should have more than enough space to hold all the required Run Book documents.
· I’m planning to gain control over this SP Site and will kick off some clean up activity next week. In the interim, each app/vendor need to take some responsibility for the areas they use in the SP Site. There are multiple copies of RunBooks, multiple versions which if cleaned up, could create a lot of free storage space. So, for now, clean up your spaces which will create the short term space required. Longer term, we’ll perform more analysis and clean-up activities.
If you see any issues or have further questions, please drop us a note at nfmi.admin@bt.com or reply to this email.
Thanks
NFMI Team
===================================
release data is 30th 16:33 My release date is 30th sep 16:34 A new member joined 16:34 Mukherjee,SS,Subhra,TAJ C Hi Rakesh 16:34 Karam,R,Rakesh,TAJ C his name is soumyajit 16:34 Mukherjee,SS,Subhra,TAJ C ok please provide him the KT 16:34 Karam,R,Rakesh,TAJ C I have already given DB kT 16:35 pending is giving KT regarding server of applications 16:35 Mukherjee,SS,Subhra,TAJ C did that include the EOT DB also 16:35 ? 16:35 Karam,R,Rakesh,TAJ C Just I need to inform him what are the servernames , monitoring and password reset 16:36 thats all 16:36 Mukherjee,SS,Subhra,TAJ C ok fine 16:36 Karam,R,Rakesh,TAJ C so when u are free 16:36 I schedule a call 16:36 ? 16:36 Mukherjee,SS,Subhra,TAJ C hope he is aware of the architecture? 16:36 Karam,R,Rakesh,TAJ C architecture of DB? 16:37 He is having 2 yrs of exp on DB and linux 16:37 he know shell scripting. 16:37 as well 16:37 shall I schedule a call at 5pm 16:37 ? 16:37 Mukherjee,SS,Subhra,TAJ C we have a program at 5:00 pm 16:38 Karam,R,Rakesh,TAJ C ok what about 6pm? 16:38 Mukherjee,SS,Subhra,TAJ C you can have the call with him if he is available 16:38 does that need me? 16:38 Karam,R,Rakesh,TAJ C ok I am good , no issue . I mail once KT has been provided 16:39 Mukherjee,SS,Subhra,TAJ C thanks 16:39 We saved this conversation in the Conversations tab in Lync and in the Conversation History folder in Outlook.Karam,R,Rakesh,TAJ C
its long back ago,, I accessed payroll execel sheet. 17:49 U had set some password 17:50 i forgot it and can u ping the password agian 17:50 again 17:50 ? 17:50 We saved this conversation in the Conversations tab in Lync and in the Conversation History folder in Outlook.Mukherjee,SS,Subhra,TAJ C
yes 18:14 today_123 18:14 also help him to procure access to bridge, citrix and the servers 18:15 Karam,R,Rakesh,TAJ C ok 18:16
==============
Hi Rakesh
Pls submit
Debabrata- I will check and confirm on the issue. Pls be informed, the laptop can be sent back to KOL in case someone is travelling from Bangalore to KOL. Hence pls provision this
Regards
Moumita
========================================
We all know there is Hardware Clock on each of the server which is used to manage various OS and Host components. Time Sync. on this server is very important particulary when Servers are Clustered together as is the case in Oracle RAC setup.
In Oracle RAC by there is a Oracle provided service(Unix Deamon) called CTSS (Cluster Time Sync. Service) which by Default runs in Observer mode when NTP is configured. NTP (Network Time Protocol) is O/S provided Protocol and is visible at OS level in form of "ntpd" deamon process when we perform "ps -ef|grep" command.
By Default NTP manages Oracle RAC DB server Time Sync.
On Oracle RAC we often find that DB server clock is not synced between RAC nodes. When difference gets too large (greater than defined tolerable offset), Oracle can kick that node out of cluster which is known as Node Eviction.
To Avoid such issues, sometimes manual sync. of Clock is required. Below steps outline the procedure used to accomplish same:
1.Suspend current NTP sync process. Suspend rather than stop as that way we don’t get spurious alerts about NTP not operating.
2.Pick the best time source, and schedule a cron job to slow down/speed up, ie SLEW, the system clock by 10% so the system clock approaches to best time source. This is a standard operation using “ntpdate –B”. If we don’t use –B we may get a STEP change, and this may cause problems with the databases in the cluster.
3.Leave the cron job operating until all hosts in the cluster are < 100 ms from the time source.
4.If bad time source isn’t fixed, then comment out bad time source in NTP configuration.
5.Stop NTP process.
6.Restart NTP process so it only SLEWS the time, and won’t STEP on startup. This requires manually running just the ntpd part of the startup.
7.Monitor for a few days.
In Oracle RAC by there is a Oracle provided service(Unix Deamon) called CTSS (Cluster Time Sync. Service) which by Default runs in Observer mode when NTP is configured. NTP (Network Time Protocol) is O/S provided Protocol and is visible at OS level in form of "ntpd" deamon process when we perform "ps -ef|grep" command.
By Default NTP manages Oracle RAC DB server Time Sync.
On Oracle RAC we often find that DB server clock is not synced between RAC nodes. When difference gets too large (greater than defined tolerable offset), Oracle can kick that node out of cluster which is known as Node Eviction.
To Avoid such issues, sometimes manual sync. of Clock is required. Below steps outline the procedure used to accomplish same:
1.Suspend current NTP sync process. Suspend rather than stop as that way we don’t get spurious alerts about NTP not operating.
2.Pick the best time source, and schedule a cron job to slow down/speed up, ie SLEW, the system clock by 10% so the system clock approaches to best time source. This is a standard operation using “ntpdate –B”. If we don’t use –B we may get a STEP change, and this may cause problems with the databases in the cluster.
3.Leave the cron job operating until all hosts in the cluster are < 100 ms from the time source.
4.If bad time source isn’t fixed, then comment out bad time source in NTP configuration.
5.Stop NTP process.
6.Restart NTP process so it only SLEWS the time, and won’t STEP on startup. This requires manually running just the ntpd part of the startup.
7.Monitor for a few days.
========================================================
How often DBA is in a situation where he wants to perform some maintanance on a table and that very table is getting updated by end-user. This results in delaying the maintannce of tables in Outage window which is most often denied by Business due to need for availability of such critical tables in Production.
There is a way out in Oracle 11g.
In Oracle 11g release, You can make a Table Read Only.
Command used will be :
Alter table EMP read only;
To make table Read-Write again, issue below command:
Alter Table EMP read write;
When a table is in Read Only mode, DMLs (Update,Insert,Delete) are NOT allowed. Performing DML on such table will result in ORA-12081 error:
delete emp *ERROR at line 1:ORA-12081: update operation not allowed on table "SCOTT"."EMP"
You can still perform DDL operations (Create indexes, maintain partitions and so on) on a Read Only Table. So, a very important Use Case for this feature would be Performing Table Maintenance.
Steps would be :
1. Make Table Read Only. This will ensure NO DMLs are allowed on table for which you want to perform maintanance. So you will not encounter any performance/locking issues while peroforming table maintanance.
2. Perform Table Maintance using necessary DDL commands.
3. Turn Table Read Write.
To see the status of the table, look for the read_only column in the data dictionary view dba_tables.
SQL> select read_only from user_tables where table_name = 'EMP'; REA---NO
There is a way out in Oracle 11g.
In Oracle 11g release, You can make a Table Read Only.
Command used will be :
Alter table EMP read only;
To make table Read-Write again, issue below command:
Alter Table EMP read write;
When a table is in Read Only mode, DMLs (Update,Insert,Delete) are NOT allowed. Performing DML on such table will result in ORA-12081 error:
delete emp *ERROR at line 1:ORA-12081: update operation not allowed on table "SCOTT"."EMP"
You can still perform DDL operations (Create indexes, maintain partitions and so on) on a Read Only Table. So, a very important Use Case for this feature would be Performing Table Maintenance.
Steps would be :
1. Make Table Read Only. This will ensure NO DMLs are allowed on table for which you want to perform maintanance. So you will not encounter any performance/locking issues while peroforming table maintanance.
2. Perform Table Maintance using necessary DDL commands.
3. Turn Table Read Write.
To see the status of the table, look for the read_only column in the data dictionary view dba_tables.
SQL> select read_only from user_tables where table_name = 'EMP'; REA---NO
=============================================
https://www.prevention.com/fitness/yoga/yoga-poses-insomnia --- Yoga poses to fall asleep
https://draxe.com/insomnia-cures/ -- insomania problem solutions
==========================
===========
This is an opportunity not to be missed. It’s not just a job we're offering you, it’s a career with a tailored training programme as well as incredible hands-on experiences. Don’t be put off from applying because you haven’t done anything similar before, you'll get loads of support, and if successful, after the first year you’ll have achieved a qualification for IT and Telecoms professionals*.
==============================
====================================
It's as if Richa Chadha and Huma Qureshi are competing to be the worst-dressed celeb of the month
We have few more queries left to be discussed on node addition activity.
Can you please let us know your availability to have a discussion on this.
==========
https://www.amazon.in/Oracle-11g-Data-Guard-hands-ebook/dp/B071YN6RST/262-4273521-5494032?_encoding=UTF8&portal-device-attributes=desktop&tag=googinhydr18418-21
=======================
Hi Kendra,
I was reviewing old mails where the requirement was sent to ASG and I have a doubt.
As per the ppt received via RFC the requirement was –
As- IS
|
To - Be
|
2 new BTPS Fields on CAN screen
- 1, a seven digit plus 1 alpha character field (NNNNNNNA).
- 2, A separate Alpha field which can be "F", "E", "P“ or “B”.
Default should be blank
|
Amend BTPS Fields on CAN screen
- 1, two digit plus three alpha-numeric plus seven digit plus 1 alpha character field (NNXXXNNNNNNNA).
- 2, Amend separate Alpha field so it can be "F", "E", "P“ or “B”. or “I”
Default should be blank
|
But as per the update from Kev, he mention it will be like –
i.e. either need to extend the field to 15 characters or remove the formatting of the field or extend field length to 15 characters with formatting of AANNNNNNNNNNNNA.
Also, it is unclear whether we should change the 2nd Alpha field to include the new “I” dropdown.
Could you please confirm which approach we should follow?
========
AS_IS means current situation .
TO Be means in future.
======
REP accounts
different applications apart from BTPS
tablespace monitoring.
rsync in HRUAF.
TEMP issue , undo issue.
scripting .
choices I can say.
maytas pre-prod
DR activities and backups.
How to get storage increased.
user creation.
select sum(bytes)/1024/1024 size_in_mb from dba_segments;
root (Please be careful)
3rd line team doesnt work during weekdays.
HCP request.
explain how changing field in shell script will affect all.
http://www.oracle.com/technetwork/articles/servers-storage-admin/ginnydbinstallonlinux-488779.html
http://www.oracle.com/technetwork/topics/linux/install-082632.html
/etc/init.d/oracleasm querydisk /dev/sdg1
http://www.oracle.com/technetwork/articles/hunter-rac11gr2-iscsi-088677.html
Any operating system disk can be queried to see if it is used by ASM:
[root@ca-test1 /]# /etc/init.d/oracleasm querydisk /dev/sdg1
Checking if device "/dev/sdg1" is an Oracle ASM disk [ OK ]
[root@ca-test1 /]# /etc/init.d/oracleasm querydisk /dev/sdh1
Checking if device "/dev/sdh1" is an Oracle ASM disk [FAILED]
how to list existing disks
[root@ca-test1 /]# /etc/init.d/oracleasm listdisks
VOL1
VOL2
VOL3
[root@ca-test1 /]# /etc/init.d/oracleasm querydisk VOL1
Checking for ASM disk "VOL1" [ OK ]
blt12439001:CRS:11gCRS > crsctl status cluster -all
Parse error:
'cluster' is an invalid argument
Brief usage:
crsctl status <resource|type|serverpool|server> [<name>] [options]
crsctl status <ip|testdns> <options>
crsctl status ip -A {<IP_name>|<IP_address>}
Check if the IP is alive
Where
IP_name Name which resolves to an IP. If name is not fully qualified domain name then standard name search will be used.
IP_address IP address
crsctl status testdns [-address <IP_address>] [-port <port>] [-v]
Check status of DNS server for specified domain
Where
IP_address DNS server address (defaults to hostname)
port The port on which the DNS server is listening. Default value for the port is 53.
-v Verbose output
For complete usage, use:
crsctl [-h | --help]
For detailed help on each command and object and its options use:
crsctl <command> <object> -h For example, crsctl relocate resource -h
=
http://www.oracle.com/technetwork/articles/servers-storage-admin/ginnydbinstallonlinux-488779.html
Data at rest in information technology means inactive data that is stored physically in any digital form (e.g. databases, data warehouses, spreadsheets, archives, tapes, off-site backups, mobile devices etc
Data in transit is defined[according to whom?] into two categories, information that flows over the public or untrusted network such as the internet and data which flows in the confines of a private network such as a corporate or enterprise Local Area Network (LAN).
Data in use is an information technology term referring to active data which is stored in a non-persistent digital state typically in computer random access memory (RAM), CPU caches, or CPU registers
Device Drivers:
Assume i had invented new device which starts flashing red-light when connected to usb port, if it finds virus/malware/keylogger in it. Now, that device does not start talking automatically tocomputer on its own, it needs some software to tell it how to communicate with *nix/win computers. that software is device driver (of that device).
Library:
Now that i am developing software (device driver) for that device, in that, i want to display virus found, date, and time of attack as report. but date can be displayed in many ways. so i write a date library, in which i code many modules on how to display dates in many ways. so whenever i want todisplay date, i import that module from that date library. this is what library is - a collection of programs/modules.
Hope its clear...
U7a0\Pg'
The main difference between a device driver and a library is that the purpose of a device driver isto control some hardware component
========================
