Oracle DBA Topics: July 2017

Monday, 31 July 2017

[root@oraracn2 bin]# ./crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'oraracn2'
CRS-2673: Attempting to stop 'ora.crsd' on 'oraracn2'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'oraracn2'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'oraracn2'
CRS-2673: Attempting to stop 'ora.oc4j' on 'oraracn2'
CRS-2673: Attempting to stop 'ora.oraracn2.vip' on 'oraracn2'
CRS-2673: Attempting to stop 'ora.CRS.dg' on 'oraracn2'
CRS-2673: Attempting to stop 'ora.cvu' on 'oraracn2'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'oraracn2'
CRS-2677: Stop of 'ora.cvu' on 'oraracn2' succeeded
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'oraracn2' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'oraracn2'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'oraracn2' succeeded
CRS-2677: Stop of 'ora.oraracn2.vip' on 'oraracn2' succeeded
CRS-2673: Attempting to stop 'ora.oraracn1.vip' on 'oraracn2'
CRS-2677: Stop of 'ora.scan1.vip' on 'oraracn2' succeeded
CRS-2677: Stop of 'ora.oraracn1.vip' on 'oraracn2' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'oraracn2' succeeded
CRS-2677: Stop of 'ora.CRS.dg' on 'oraracn2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'oraracn2'
CRS-2677: Stop of 'ora.asm' on 'oraracn2' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'oraracn2'
CRS-2677: Stop of 'ora.ons' on 'oraracn2' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'oraracn2'
CRS-2677: Stop of 'ora.net1.network' on 'oraracn2' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'oraracn2' has completed
CRS-2677: Stop of 'ora.crsd' on 'oraracn2' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'oraracn2'
CRS-2673: Attempting to stop 'ora.evmd' on 'oraracn2'
CRS-2673: Attempting to stop 'ora.asm' on 'oraracn2'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'oraracn2'
CRS-2677: Stop of 'ora.evmd' on 'oraracn2' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'oraracn2' succeeded
CRS-2677: Stop of 'ora.asm' on 'oraracn2' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'oraracn2'
CRS-2677: Stop of 'ora.ctssd' on 'oraracn2' succeeded
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'oraracn2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'oraracn2'
CRS-2677: Stop of 'ora.cssd' on 'oraracn2' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'oraracn2'
CRS-2677: Stop of 'ora.crf' on 'oraracn2' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'oraracn2'
CRS-2677: Stop of 'ora.gipcd' on 'oraracn2' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'oraracn2'
CRS-2677: Stop of 'ora.gpnpd' on 'oraracn2' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'oraracn2' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[root@oraracn2 bin]#

output of orainstRoot.sh and root.sh when executed on 1st node.

Last login: Tue Aug 1 03:55:56 2017 from 192.168.1.100
[root@oraracn1 ~]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[root@oraracn1 ~]# /u01/app/11.2.0/grid/root.sh
Performing root user operation for Oracle 11g

The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/11.2.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
User ignored Prerequisites during installation
Installing Trace File Analyzer
OLR initialization - successful
root wallet
root wallet cert
root cert export
peer wallet
profile reader wallet
pa wallet
peer wallet keys
pa wallet keys
peer cert request
pa cert request
peer cert
pa cert
peer root cert TP
profile reader root cert TP
pa root cert TP
peer pa cert TP
pa peer cert TP
profile reader pa cert TP
profile reader peer cert TP
peer user cert
pa user cert
Adding Clusterware entries to upstart
CRS-2672: Attempting to start 'ora.mdnsd' on 'oraracn1'
CRS-2676: Start of 'ora.mdnsd' on 'oraracn1' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'oraracn1'
CRS-2676: Start of 'ora.gpnpd' on 'oraracn1' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'oraracn1'
CRS-2672: Attempting to start 'ora.gipcd' on 'oraracn1'
CRS-2676: Start of 'ora.cssdmonitor' on 'oraracn1' succeeded
CRS-2676: Start of 'ora.gipcd' on 'oraracn1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'oraracn1'
CRS-2672: Attempting to start 'ora.diskmon' on 'oraracn1'
CRS-2676: Start of 'ora.diskmon' on 'oraracn1' succeeded
CRS-2676: Start of 'ora.cssd' on 'oraracn1' succeeded

ASM created and started successfully.

Disk Group CRS created successfully.

clscfg: -install mode specified
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4256: Updating the profile
Successful addition of voting disk 0cd92e0f16434fa2bfbdc6592ea04971.
Successfully replaced voting disk group with +CRS.
CRS-4256: Updating the profile
CRS-4266: Voting file(s) successfully replaced
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 0cd92e0f16434fa2bfbdc6592ea04971 (/dev/oracleasm/disks/CRS1) [CRS]
Located 1 voting disk(s).
CRS-2672: Attempting to start 'ora.asm' on 'oraracn1'
CRS-2676: Start of 'ora.asm' on 'oraracn1' succeeded
CRS-2672: Attempting to start 'ora.CRS.dg' on 'oraracn1'
CRS-2676: Start of 'ora.CRS.dg' on 'oraracn1' succeeded
Preparing packages for installation...
cvuqdisk-1.0.9-1
Configure Oracle Grid Infrastructure for a Cluster ... succeeded
[root@oraracn1 ~]#

==================================

execution of scripts on node 2

[root@oraracn2 ~]# /u01/app/oraInventory/orainstRoot.sh

Changing permissions of /u01/app/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to oinstall.

The execution of the script is complete.

[root@oraracn2 ~]# /u01/app/11.2.0/grid/root.sh

Performing root user operation for Oracle 11g

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /u01/app/11.2.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:

Copying dbhome to /usr/local/bin ...

Copying oraenv to /usr/local/bin ...

Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params

Creating trace directory

User ignored Prerequisites during installation

Installing Trace File Analyzer

OLR initialization - successful

Adding Clusterware entries to upstart

CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node oraracn1, number 1, and is terminating

An active cluster was found during exclusive startup, restarting to join the cluster

Preparing packages for installation...

cvuqdisk-1.0.9-1

Configure Oracle Grid Infrastructure for a Cluster ... succeeded

[root@oraracn2 ~]#

SSH connectivity chck in while grid installation.

-rwxr-xr-x 1 oracle oinstall 32343 Aug 26 2013 sshUserSetup.sh
[oracle@oraracn1 sshsetup]$ ./sshUserSetup.sh -user oracle -hosts "oraracn1 oraracn2" -noPromptPassphrase -confirm -advanced
The output of this script is also logged into /tmp/sshUserSetup_2017-08-01-04-54-34.log
Hosts are oraracn1 oraracn2
user is oracle
Platform:- Linux
Checking if the remote hosts are reachable
PING oraracn1.oraclegenesis.com (192.168.1.111) 56(84) bytes of data.
64 bytes from oraracn1.oraclegenesis.com (192.168.1.111): icmp_seq=1 ttl=64 time=0.036 ms
64 bytes from oraracn1.oraclegenesis.com (192.168.1.111): icmp_seq=2 ttl=64 time=0.040 ms
64 bytes from oraracn1.oraclegenesis.com (192.168.1.111): icmp_seq=3 ttl=64 time=0.042 ms
64 bytes from oraracn1.oraclegenesis.com (192.168.1.111): icmp_seq=4 ttl=64 time=0.041 ms
64 bytes from oraracn1.oraclegenesis.com (192.168.1.111): icmp_seq=5 ttl=64 time=0.042 ms

--- oraracn1.oraclegenesis.com ping statistics ---
5 packets transmitted, 5 received, 0% packet loss, time 4003ms
rtt min/avg/max/mdev = 0.036/0.040/0.042/0.004 ms
PING oraracn2.oraclegenesis.com (192.168.1.112) 56(84) bytes of data.
64 bytes from oraracn2.oraclegenesis.com (192.168.1.112): icmp_seq=1 ttl=64 time=1.36 ms
64 bytes from oraracn2.oraclegenesis.com (192.168.1.112): icmp_seq=2 ttl=64 time=0.602 ms
64 bytes from oraracn2.oraclegenesis.com (192.168.1.112): icmp_seq=3 ttl=64 time=0.611 ms
64 bytes from oraracn2.oraclegenesis.com (192.168.1.112): icmp_seq=4 ttl=64 time=0.629 ms
64 bytes from oraracn2.oraclegenesis.com (192.168.1.112): icmp_seq=5 ttl=64 time=0.609 ms

--- oraracn2.oraclegenesis.com ping statistics ---
5 packets transmitted, 5 received, 0% packet loss, time 4006ms
rtt min/avg/max/mdev = 0.602/0.762/1.362/0.301 ms
Remote host reachability check succeeded.
The following hosts are reachable: oraracn1 oraracn2.
The following hosts are not reachable: .
All hosts are reachable. Proceeding further...
firsthost oraracn1
numhosts 2
The script will setup SSH connectivity from the host oraracn1.oraclegenesis.com to all
the remote hosts. After the script is executed, the user can use SSH to run
commands on the remote hosts or copy files between this host oraracn1.oraclegenesis.com
and the remote hosts without being prompted for passwords or confirmations.

NOTE 1:
As part of the setup procedure, this script will use ssh and scp to copy
files between the local host and the remote hosts. Since the script does not
store passwords, you may be prompted for the passwords during the execution of
the script whenever ssh or scp is invoked.

NOTE 2:
AS PER SSH REQUIREMENTS, THIS SCRIPT WILL SECURE THE USER HOME DIRECTORY
AND THE .ssh DIRECTORY BY REVOKING GROUP AND WORLD WRITE PRIVILEDGES TO THESE
directories.

Do you want to continue and let the script make the above mentioned changes (yes/no)?
Confirmation provided on the command line

The user chose yes
User chose to skip passphrase related questions.
Creating .ssh directory on local host, if not present already
Creating authorized_keys file on local host
Changing permissions on authorized_keys to 644 on local host
Creating known_hosts file on local host
Changing permissions on known_hosts to 644 on local host
Creating config file on local host
If a config file exists already at /home/oracle/.ssh/config, it would be backed up to /home/oracle/.ssh/config.backup.
Removing old private/public keys on local host
Running SSH keygen on local host with empty passphrase
Generating public/private rsa key pair.
Your identification has been saved in /home/oracle/.ssh/id_rsa.
Your public key has been saved in /home/oracle/.ssh/id_rsa.pub.
The key fingerprint is:
71:7b:42:30:a3:fc:1f:83:92:8c:d5:eb:fa:24:11:cc oracle@oraracn1.oraclegenesis.com
The key's randomart image is:
+--[ RSA 1024]----+
| + |
| + o + |
| E o o |
| + + * . |
| . = S = . |
| + . = |
| . o . |
| + |
| ... |
+-----------------+
Creating .ssh directory and setting permissions on remote host oraracn1
THE SCRIPT WOULD ALSO BE REVOKING WRITE PERMISSIONS FOR group AND others ON THE HOME DIRECTORY FOR oracle. THIS IS AN SSH REQUIREMENT.
The script would create ~oracle/.ssh/config file on remote host oraracn1. If a config file exists already at ~oracle/.ssh/config, it would be backed up to ~oracle/.ssh/config.backup.
The user may be prompted for a password here since the script would be running SSH on host oraracn1.
Warning: Permanently added 'oraracn1,192.168.1.111' (RSA) to the list of known hosts.
oracle@oraracn1's password:
Done with creating .ssh directory and setting permissions on remote host oraracn1.
Creating .ssh directory and setting permissions on remote host oraracn2
THE SCRIPT WOULD ALSO BE REVOKING WRITE PERMISSIONS FOR group AND others ON THE HOME DIRECTORY FOR oracle. THIS IS AN SSH REQUIREMENT.
The script would create ~oracle/.ssh/config file on remote host oraracn2. If a config file exists already at ~oracle/.ssh/config, it would be backed up to ~oracle/.ssh/config.backup.
The user may be prompted for a password here since the script would be running SSH on host oraracn2.
Warning: Permanently added 'oraracn2,192.168.1.112' (RSA) to the list of known hosts.
oracle@oraracn2's password:
Done with creating .ssh directory and setting permissions on remote host oraracn2.
Copying local host public key to the remote host oraracn1
The user may be prompted for a password or passphrase here since the script would be using SCP for host oraracn1.
oracle@oraracn1's password:
Done copying local host public key to the remote host oraracn1
Copying local host public key to the remote host oraracn2
The user may be prompted for a password or passphrase here since the script would be using SCP for host oraracn2.
oracle@oraracn2's password:
Done copying local host public key to the remote host oraracn2
Creating keys on remote host oraracn1 if they do not exist already. This is required to setup SSH on host oraracn1.

Creating keys on remote host oraracn2 if they do not exist already. This is required to setup SSH on host oraracn2.
Generating public/private rsa key pair.
Your identification has been saved in .ssh/id_rsa.
Your public key has been saved in .ssh/id_rsa.pub.
The key fingerprint is:
0b:7f:5a:ec:ee:9f:a3:f6:bb:c1:f3:e6:a1:03:07:76 oracle@oraracn2.oraclegenesis.com
The key's randomart image is:
+--[ RSA 1024]----+
| |
| |
| |
| o E |
| . S. o |
| o o... |
| o +o+ . |
| =. o*.. |
| .+=+BBo |
+-----------------+
Updating authorized_keys file on remote host oraracn1
Updating known_hosts file on remote host oraracn1
Updating authorized_keys file on remote host oraracn2
Updating known_hosts file on remote host oraracn2
cat: /home/oracle/.ssh/known_hosts.tmp: No such file or directory
cat: /home/oracle/.ssh/authorized_keys.tmp: No such file or directory
SSH setup is complete.

------------------------------------------------------------------------
Verifying SSH setup
===================
The script will now run the date command on the remote nodes using ssh
to verify if ssh is setup correctly. IF THE SETUP IS CORRECTLY SETUP,
THERE SHOULD BE NO OUTPUT OTHER THAN THE DATE AND SSH SHOULD NOT ASK FOR
PASSWORDS. If you see any output other than date or are prompted for the
password, ssh is not setup correctly and you will need to resolve the
issue and set up ssh again.
The possible causes for failure could be:
1. The server settings in /etc/ssh/sshd_config file do not allow ssh
for user oracle.
2. The server may have disabled public key based authentication.
3. The client public key on the server may be outdated.
4. ~oracle or ~oracle/.ssh on the remote host may not be owned by oracle.
5. User may not have passed -shared option for shared remote users or
may be passing the -shared option for non-shared remote users.
6. If there is output in addition to the date, but no password is asked,
it may be a security alert shown as part of company policy. Append the
additional text to the <OMS HOME>/sysman/prov/resources/ignoreMessages.txt file.
------------------------------------------------------------------------
--oraracn1:--
Running /usr/bin/ssh -x -l oracle oraracn1 date to verify SSH connectivity has been setup from local host to oraracn1.
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL. Please note that being prompted for a passphrase may be OK but being prompted for a password is ERROR.
Tue Aug 1 04:55:19 IST 2017
------------------------------------------------------------------------
--oraracn2:--
Running /usr/bin/ssh -x -l oracle oraracn2 date to verify SSH connectivity has been setup from local host to oraracn2.
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL. Please note that being prompted for a passphrase may be OK but being prompted for a password is ERROR.
Tue Aug 1 04:55:19 IST 2017
------------------------------------------------------------------------
------------------------------------------------------------------------
Verifying SSH connectivity has been setup from oraracn1 to oraracn1
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL.
bash: -c: line 0: unexpected EOF while looking for matching `"'
bash: -c: line 1: syntax error: unexpected end of file
------------------------------------------------------------------------
------------------------------------------------------------------------
Verifying SSH connectivity has been setup from oraracn1 to oraracn2
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL.
bash: -c: line 0: unexpected EOF while looking for matching `"'
bash: -c: line 1: syntax error: unexpected end of file
------------------------------------------------------------------------
-Verification from complete-
SSH verification complete.
[oracle@oraracn1 sshsetup]$ ssh oracleracn2
ssh: Could not resolve hostname oracleracn2: No address associated with hostname
[oracle@oraracn1 sshsetup]$ ssh oraracn2
Last login: Tue Aug 1 04:44:23 2017 from 192.168.1.100
[oracle@oraracn2 ~]$ shh oraracn1
-bash: shh: command not found
[oracle@oraracn2 ~]$ ssh oraracn1
Last login: Tue Aug 1 04:39:27 2017 from 192.168.1.100
[oracle@oraracn1 ~]$ ssh oraracn1
Last login: Tue Aug 1 04:57:29 2017 from oraracn2.oraclegenesis.com
[oracle@oraracn1 ~]$ yum install ntp
Loaded plugins: refresh-packagekit, security
You need to be root to perform this command.
[oracle@oraracn1 ~]$ su -
Password:
[root@oraracn1 ~]# yum install ntp
Loaded plugins: refresh-packagekit, security
ol6_UEK_latest | 1.2 kB 00:00
ol6_UEK_latest/primary | 33 MB 00:08
ol6_UEK_latest 701/701
ol6_latest | 1.4 kB 00:00
ol6_latest/primary | 65 MB 00:14
ol6_latest 39217/39217
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package ntp.x86_64 0:4.2.6p5-1.el6 will be updated
---> Package ntp.x86_64 0:4.2.6p5-10.0.1.el6_8.2 will be an update
--> Processing Dependency: ntpdate = 4.2.6p5-10.0.1.el6_8.2 for package: ntp-4.2.6p5-10.0.1.el6_8.2.x86_64
--> Running transaction check
---> Package ntpdate.x86_64 0:4.2.6p5-1.el6 will be updated
---> Package ntpdate.x86_64 0:4.2.6p5-10.0.1.el6_8.2 will be an update

Real time scenario which I faced

Hi
Error: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

https://community.oracle.com/thread/2552670

http://abeytom.blogspot.in/2012/08/finding-and-fixing-ora-00054-resource.html

Saturday, 29 July 2017

ಅಮೇರಿಕಾದ 1ಡಾಲರಿನ ಮಾರುಕಟ್ಟೆ ಬೆಲೆ 67 ರೂಪಾಯಿಗಳಾಗಿದೆ ಏಕೆ ? ರೂಪಾಯಿ ಮೌಲ್ಯ ಹೇಗೆ ನಿರ್ಧಾರವಾಗುತ್ತದೆ ? ಎಂಬುದನ್ನು ಅರ್ಥಶಾಸ್ತ್ರೀಯವಾಗಿ ಅರ್ಥ ಮಾಡಿಸುವ ಸಣ್ಣ ಪ್ರಯತ್ನದ ಎರಡಕ್ಷರಗಳಿವು ಓದಿ

ಒಂದು ರಾಷ್ಟ್ರ ತನ್ನ ಕರೆನ್ಸಿ ನೋಟುಗಳನ್ನು ಇಷ್ಟಬಂದಂತೆ ಮುದ್ರಿಸುವ ಹಾಗೆ ಇಲ್ಲ ಅದಕ್ಕೆ ಅಂತರಾಷ್ಟ್ರೀಯ ಮಾನದಂಡಗಳು ನಿಯಮಗಳು ಇವೆ ಸ್ವರ್ಣಮಿತಿ ನಿಯಮ

ಚಿನ್ನದ ಮೌಲ್ಯವನ್ನು ಕೇಂದ್ರವಾಗಿಟ್ಟುಕೊಂಡು ವಿಶ್ವದ ಎಲ್ಲಾ ರಾಷ್ಟ್ರಗಳು ತಮ್ಮ ಕರೆನ್ಸಿ ನೋಟುಗಳನ್ನು ಮುದ್ರಿಸಬೇಕು ಸರಳವಾಗಿ ಅರ್ಥ ಮಾಡಿಸುವುದಾದರೆ

ಭಾರತದಲ್ಲಿ 100 ಗ್ರಾಂ ವನ್ನು ಆಧರಿಸಿ ರಿಸರ್ವ ಬ್ಯಾಂಕ್ 100 ರೂಪಾಯಿಗಳನ್ನು ಮುದ್ರಿಸಿ ಚಲಾವಣೆಗೆ ತರುತ್ತದೆ ಎಂದರೆ ಒಂದು ಗ್ರಾಂ ಚಿನ್ನದ ಬೆಲೆ 1 ರೂಪಾಯಿ ಹಾಗೆ ಅಮೆರಿಕಾದಲ್ಲೂ 100 ಗ್ರಾಂ ಚಿನ್ನ ಆಧರಿಸಿ ಅಮೆರಿಕಾದ ಫೆಡರಲ್ ಬ್ಯಾಂಕ್ 100 ಡಾಲರ್ ಗಳನ್ನು ಮುದ್ರಿಸಿ ಚಲಾವಣೆಗೆ ತರುತ್ತದೆ ಆಗ 1 ಗ್ರಾಂ ಚಿನ್ನದ ಬೆಲೆ 1 ಡಾಲರ್
ಆಗಿರುತ್ತದೆ ಆಗ 1 ರೂಪಾಯಿ ಮುಖಬೆಲೆಗೆ 1 ಡಾಲರ್ ಸಮವಾಗಿರುತ್ತದೆ
ಚಲಾವಣೆಯಲ್ಲಿರುವ 100 ರೂಪಾಯಿ ಮತ್ತು ಚಲಾವಣೆಯಲ್ಲಿರುವ 100 ಡಾಲರ್ ವಾಪಸ್ ಸರ್ಕಾರಕ್ಕೆ ತೆರಿಗೆ ರೂಪದಲ್ಲಿ ಎಷ್ಟು ಬರುತ್ತದೆಯೋ ಅಷ್ಟು ಹಣದ ಮೌಲ್ಯದ ಚಿನ್ನವನ್ನು ಖರೀಧಿಸಿ ಅಷ್ಟು ಹಣವನ್ನು ಮುದ್ರಿಸಿ ಚಲಾವಣೆಗೆ ತರಬೇಕು

ಉದಾಹರಣೆಗೆ ಭಾರತದಲ್ಲಿ ಚಲಾವಣೆಯಲ್ಲಿರುವ 100 ರೂಪಾಯಿಯಲ್ಲಿ ತೆರಿಗೆ ರೂಪದಲ್ಲಿ 10 ರೂಪಾಯಿ ಸರಕಾರಕ್ಕೆ ವಾಪಸ್ಸ್ ಬಂದಿರುತ್ತದೆ ರಿಸರ್ವ ಬ್ಯಾಂಕ್ ಆ10 ರೂಪಾಯಿಗೆ 10 ಗ್ರಾಂ ಚಿನ್ನ ಖರೀಧಿಸಿ 10 ರೂಪಾಯಿ ನೋಟುಗಳನ್ನು ಮುದ್ರಿಸುತ್ತದೆ

ಚಲಾವಣೆಯಲ್ಲಿರುವ ಅಮೆರಿಕಾದ 100 ಡಾಲರ್ ಗಳಲ್ಲಿ ವಾಪಸ್ಸು ಸರ್ಕಾರಕ್ಕೆ ತೆರಿಗೆ ರೂಪದಲ್ಲಿ 50 ಡಾಲರ್ ಬರುತ್ತದೆ ಪೆಡರಲ್ ಬ್ಯಾಂಕ್ ಆ 50 ಡಾಲರ್ ಗಳಿಗೆ 50 ಗ್ರಾಂ ಚಿನ್ನ ಖರೀಧಿಸಿ ಮತ್ತೆ 50 ಡಾಲರ್ ಕರೆನ್ಸಿ ಮುದ್ರಿಸಿ ಚಲಾವಣೆಗೆ ತರುತ್ತದೆ ಇಂಥಹ ಪರಿಸ್ಥಿತಿಯಲ್ಲಿಯೂ 1 ರೂಪಾಯಿ 1 ಡಾಲರಿಗೆ ಸಮವಾಗಿರುತ್ತದೆ

ಭಾರತದ ಮಾರುಕಟ್ಟೆಯಲ್ಲಿ ಚಲಾವಣೆಯಲ್ಲಿರುವ ಕರೆನ್ಸಿ ಕೊರತೆಯಾಗಿ 40 ರೂಪಾಯಿಗಳಷ್ಟು ಕರೆನ್ಸಿ ಬೇಡಿಕೆ ಸೃಷ್ಟಿಯಾಗಿ ಆ 40 ರೂಪಾಯಿ ಮುದ್ರಿಸಲು ತೆರಿಗೆ ರೂಪದಲ್ಲಿ ಸರ್ಕಾರಕ್ಕೆ ಹಣ ವಾಪಸ್ಸು ಬರದಿದ್ದ ಪರಿಸ್ಥಿತಿಯಲ್ಲಿ 40 ರೂಪಾಯಿ ಮೌಲ್ಯದ ಚಿನ್ನ ಖರೀಧಿಸಿ 40 ರೂಪಾಯಿ ಕರೆನ್ಸಿ ಮುದ್ರಿಸಿ ಚಲಾವಣೆಗೆ ತರಲು ಸಾಧ್ಯವಿಲ್ಲ ಆಗ ಸರ್ಕಾರ ರೂಪಾಯಿ ಮೌಲ್ಯವನ್ನು ಕುಗ್ಗಿಸಿ 40 ರೂಪಾಯಿ ಕರೆನ್ಸಿಯನ್ನು ಮುದ್ರಿಸಿ ಚಲಾವಣೆಗೆ ತರುತ್ತದೆ
ಆಗ ಮಾರುಕಟ್ಟೆಯಲ್ಲಿ 150 ರೂಪಾಯಿ ಕರೆನ್ಸಿ ಚಲಾವಣೆಯಲ್ಲಿ ಇರುತ್ತದೆ ರಿಸರ್ವ್ ಬ್ಯಾಂಕಿನಲ್ಲಿ 110 ಗ್ರಾಂ ಚಿನ್ನ ಮಾತ್ರವಿರುತ್ತದೆ
ಆಗ 1ರೂಪಾಯಿಯಾಗಿದ್ದ 1ಗ್ರಾಂ ಚಿನ್ನ 1ರೂಪಾಯಿ 40 ಪೈಸೆಯಾಗುತ್ತದೆ
1ಗ್ರಾಂ ಚಿನ್ನಕ್ಕೆ 1 ಡಾಲರ್ ಇರುವುದ್ದರಿಂದ 1ಡಾಲರಿನ ಮುಖ ಬೆಲೆ 1ರೂಪಾಯಿ 40 ಪೈಸೆಯಾಗುತ್ತದೆ

ಅಮೆರಿಕಾದಲ್ಲಿ ಜನರು ತೆರಿಗೆಯನ್ನು ಸರಿಯಾಗಿ ಪಾವತಿಸುತ್ತಿರುವುದು ಭಾರತದಲ್ಲಿ ಜನರು ತೆರಿಗೆಯನ್ನು ಸರಿಯಾಗಿ ಪಾವತಿಸದಿರುವುದು ರೂಪಾಯಿ ಬೆಲೆ ಡಾಲರಿನ ಮುಂದೆ ಕಡಿಮೆಯಾಗಲು ಕಾರಣ ಆದುದ್ದರಿಂದ ನರೇಂದ್ರ ಮೋದಿಯವರು ತೆರಿಗೆ ವ್ಯವಸ್ಥೆ ಸುಧಾರಣೆ ಮಾಡಲು ನೋಟ್ ಬ್ಯಾನ್ ಮಾಡಿದ್ದು GST ಕಾಯಿದೆ ಮಾಡಿದ್ದು
ಇದೆಲ್ಲ ಸಾಮಾನ್ಯ ಜನರಿಗೆ ಅರ್ಥವಾಗುವುದಿಲ್ಲ ಅರ್ಥಶಾಸ್ತ್ರಜ್ಞರು ಅರ್ಥ ಮಾಡಿಸುವುದಿಲ್ಲ ಬದಲಾಗಿ ರಾಜಕೀಯ ಮಾಡಿಕೊಂಡು ಪುಡಾರಿಯಂತೆ ವರ್ತಿಸುತ್ತಾರೆ ಜನಸಾಮಾನ್ಯರನ್ನು ಅಜ್ಞಾನದಲ್ಲಿ ಇಡುತ್ತಾರೆ ಮಾದ್ಯಮಗಳಂತೂ ಬ್ರಹ್ಮಜ್ಞಾನಿಗಳಂತೆ ವರ್ತಿಸುತ್ತವೆ ಏನು ತಿಳಿಯದಿದ್ದರು

ಇಲ್ಲಿ ಗಮನಿಸಬೇಕಾದ ವಿಷಯ ಡಾಲರಿನ ಮುಖಬೆಲೆ ಮತ್ತು ಮಾರುಕಟ್ಟೆ ಬೆಲೆ ನಡುವೆ ವೆತ್ಯಾಸವಿದೆ ಡಾಲರಿನ ಪೂರೈಕೆ ಮತ್ತು ಬೇಡಿಕೆಗೆ ಅನುಗುಣವಾಗಿ ಮಾರುಕಟ್ಟೆ ಬೆಲೆ ನಿರ್ಧಾರವಾಗುತ್ತದೆ ಆದರೆ ಮುಖಬೆಲೆ ಚಿನ್ನದ ಆಧಾರದ ಮೇಲೆ ನಿರ್ಧಾರವಾಗುತ್ತದೆ.....
#GST

after executing orainstRoot.sh

[oracle@rac1 oraInventory]$ su - root
Password:
[root@rac1 ~]# /u01/app/oraInventory/sectime/orainstRoot.sh
Changing permissions of /u01/app/oraInventory/sectime.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory/sectime to oinstall.
The execution of the script is complete.
[root@rac1 ~]#

[root@rac1 ~]# /u01/app/oraInventory/sectime/orainstRoot.sh
Changing permissions of /u01/app/oraInventory/sectime.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory/sectime to oinstall.
The execution of the script is complete.
[root@rac1 ~]# /u01/app/11.2.0/grid/root.sh
2017-07-29 22:09:29: Parsing the host name
2017-07-29 22:09:29: Checking for super user privileges
2017-07-29 22:09:29: User has super user privileges
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
/home/oracle/.bash_profile: line 29: alias: alias: not found
LOCAL ADD MODE
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
root wallet
root wallet cert
root cert export
peer wallet
profile reader wallet
pa wallet
peer wallet keys
pa wallet keys
peer cert request
pa cert request
peer cert
pa cert
peer root cert TP
profile reader root cert TP
pa root cert TP
peer pa cert TP
pa peer cert TP
profile reader pa cert TP
profile reader peer cert TP
peer user cert
pa user cert
Adding daemon to inittab

CRS-4124: Oracle High Availability Services startup failed.
CRS-4000: Command Start failed, or completed with errors.
ohasd failed to start: Inappropriate ioctl for device
ohasd failed to start at /u01/app/11.2.0/grid/crs/install/rootcrs.pl line 443.
[root@rac1 ~]#
[root@rac1 ~]#

Thursday, 27 July 2017

*** NOTES 19/06/2017 12:46:10 sa Action Type: PM Team
AutoClarify Fault Raised By OMNIBUS User cwhpopsdba
==================================================
GAS Link : http://omnihist2.nat.bt.com/cgi-bin/alarmmis/new/gas3.pl?action=Lookup&help_tag=GASTAG:NOGASID&project=BTPSCRMHELPDESK&class=&nodealias=blp07768023&summary=Database%20Entity%20Failed:%20APP07768%20AUTOCLARIFY:DBAORA2L:3%20~%20EMGC-EM00078%20hrcath1%20CRIT%20Database_Instance%20Database_Limits%20~%20Metrics%20Process%20Limit%20%%20is%20at%2091%20
Event ID: 750446762
PROJECT: BTPSCRMHELPDESK
APPLICATION: HR Helpdesk
APPID: APP07768
HELP: GASTAG:NOGASID
NODE: blp07768023
IP ADDRESS: 10.52.136.134
PROBE: trapd from hws000a005
SITE: Reigate Data Centre,Chesterfield Park,Buckland Road,Reigate,SURREY,RH2 9TB
BUILDING: HQL-UB
SKYLINE: RH0008A1
TALLY: 2
FIRST: 19/06/17,12:42
LAST: 19/06/17,12:42
SUBPROJECT: SPSERV,SPAPP,SPCOMP
SUMMARY: Database Entity Failed: APP07768 AUTOCLARIFY:DBAORA2L:3 ~ EMGC-EM00078 hrcath1 CRIT Database_Instance Database_Limits ~ Metrics Process Limit % is at 91

*** RESEARCH LOG 19/06/2017 13:25:16 slnxk36 Action Type: Action Taken
*** Master CWHPOPSDBA Noman Khan 07877 766 748 slnxk36
looking for log
################
RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION LIMIT_VALUE
------------------------------ ------------------- --------------- ----------------------------------------
processes 366 371 400>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>to high
sessions 384 392 624

*** RESEARCH LOG 19/06/2017 13:27:38 slnxk36 Action Type: Action Taken
*** Master CWHPOPSDBA Noman Khan 07877 766 748 slnxk36
Inactive session
###########
USERNAME STATUS COUNT(*)
------------------------------ -------- ----------
PAYROLL INACTIVE 4
CA_CWK_CONVERSION INACTIVE 6
TREASURY INACTIVE 6
ARK_USER INACTIVE 6
OSDK_HISTORY INACTIVE 6
CA_COMMON_SCHEMA INACTIVE 6
PEN_DOCUMENTUM INACTIVE 8
OSDK_LANDING INACTIVE 10
CA_CONTINGENT_WORKERS INACTIVE 16
ABSENCE_LEAVE INACTIVE 48
CA_HEALTH_AND_SAFETY INACTIVE 60
CA_CONTRACTS_AUTOMATION INACTIVE 62
CA_PAID_LEAVERS INACTIVE 180
CA_EXECUTIVE_SHARES INACTIVE 186

*** RESEARCH LOG 19/06/2017 13:36:21 slnxk36 Action Type: Action Taken
*** Master CWHPOPSDBA Noman Khan 07877 766 748 slnxk36
high number of inactive session so passing back to ASg please recycle your application server
########
*** Changed to Priority 5 at 27/07/2017 10:05:07 *** nurqk00 : reducing to p5 as it is non-prod server and no service impact to prod

Sunday, 23 July 2017

TEMP consuming queries findout method.

How to find query which consumed high temp .

It might be useful .

Thanks & Regards

Rakesh

Rakesh Karam| TCS | Application DBA

AS&M| BT Technology, Service & Operations|TelOff: 03366881494| Mob: +918792287671|E: rakesh.karam@bt.com

From: Karam,R,Rakesh,TAJ C
Sent: 21 July 2017 20:18
To: Karam,R,Rakesh,TMR C (rakesh.karam@bt.com)
Subject: IDENTIFYING QUERY WHICH CONSUMED WHOLE TEMP - BX409105

*** NOTES 11/07/2016 09:21:34 sa Action Type: PM Team

AutoClarify Fault Raised By OMNIBUS User cwhpopsdba

==================================================

Search for Guided Actions on the BT Operations (Non-DBA) Guided Actions System :

http://omnihist2.nat.bt.com/cgi-bin/alarmmis/new/gas3.pl?action=Lookup&project=THEBTPEOPLESYSTEM&class=&nodealias=dyl03839dat01&summary=Database%20Entity%20Failed:%20AUTOCLARIFY:DBAORA2L:2%20~%20HP1D%20elmd1%20ORA-01652%20~%20ORA-1652:%20

Event ID: 668107361

PROJECT: THEBTPEOPLESYSTEM

APPLICATION: The BT People System

APPID: APP03839

NODE: dyl03839dat01

IP ADDRESS: 10.35.33.100

PROBE: trapd from dycol01

SITE: Derby Data Centre,Raynesway,Alvaston,Derby,DERBY,DE21 7BX

BUILDING: RYN-DE

SKYLINE: DE0070A1

TALLY: 1

FIRST: 11/07/16,09:18

LAST: 11/07/16,09:18

SUBPROJECT: NULL DATA

SUMMARY: Database Entity Failed: AUTOCLARIFY:DBAORA2L:2 ~ HP1D elmd1 ORA-01652 ~ ORA-1652:

*** RESEARCH LOG 11/07/2016 09:23:33 ccaxh08 Action Type: Action Taken

*** Master CWHPOPSDBA Andrew Heaps 0114 277 4032 ccaxh08

alert log shows

Mon Jul 11 09:18:00 2016

ORA-1652: unable to extend temp segment by 8 in tablespace PSTEMP

*** RESEARCH LOG 11/07/2016 09:24:41 ccaxh08 Action Type: Action Taken

*** Master CWHPOPSDBA Andrew Heaps 0114 277 4032 ccaxh08

database ok

log switching ok

NAME DATABASE_ROLE OPEN_MODE HOST_NAME INSTANCE_NAME STATUS STARTUP_TIME

-------- ---------------- ---------- -------------- -------------- -------- -----------------

ELM PRIMARY READ WRITE dyl03839dat01 elmd1 OPEN 08-03-16 01:02:53

SQL> SQL> alter system switch logfile;

System altered.

*** RESEARCH LOG 11/07/2016 09:25:58 ccaxh08 Action Type: Action Taken

*** Master CWHPOPSDBA Andrew Heaps 0114 277 4032 ccaxh08

FILE_NAME Size(MB) AUT MaxSize(MB)

---------------------------------------------------------------------- ---------- --- -----------

+DATA_DG01/elm_dy/tempfile/pstemp.1024.747673845 12288 YES 12288

+DATA_DG01/elm_dy/tempfile/pstemp.1025.747673849 12288 YES 12288

Temp tablespace - not service affecting

*** RESEARCH LOG 11/07/2016 11:43:55 ccaxh08 Action Type: Action Taken

*** Master CWHPOPSDBA Andrew Heaps 0114 277 4032 ccaxh08

SQL> select distinct to_char (timestamp, 'dd-mm-yy hh24:mi:ss')as timestamp, SQL_ID, TEMP_SPACE

from DBA_HIST_SQL_PLAN

where timestamp like '%11-JUL-16%'

and TEMP_SPACE is not null order by timestamp;

2 3 4

TIMESTAMP SQL_ID TEMP_SPACE

----------------- ------------- ----------

11-07-16 03:46:25 bmhc6q7hcfvuc 3064000

11-07-16 03:46:54 g42puaptcfz0z 2606000

11-07-16 03:46:54 g42puaptcfz0z 30589000

11-07-16 09:09:50 bddjks97k003q 36357000

11-07-16 09:09:50 bddjks97k003q 89277000

11-07-16 09:09:50 bddjks97k003q 1.8447E+19

11-07-16 09:35:15 39vr01mym6bs6 36357000

11-07-16 09:35:15 39vr01mym6bs6 89277000

11-07-16 09:35:15 39vr01mym6bs6 1.8447E+19

11-07-16 10:33:50 9rq12x1x46qm8 19497000

10 rows selected.

bddjks97k003q

39vr01mym6bs6

checking sql

Using the report name awrsqlrpt_1_46522_46523.txt

WORKLOAD REPOSITORY SQL Report

Snapshot Period Summary

DB Name DB Id Instance Inst Num Startup Time Release RAC

------------ ----------- ------------ -------- --------------- ----------- ---

ELM 3884532509 elmd1 1 08-Mar-16 01:02 11.1.0.7.0 YES

Snap Id Snap Time Sessions Curs/Sess

--------- ------------------- -------- ---------

Begin Snap: 46522 11-Jul-16 09:00:08 215 3.9

End Snap: 46523 11-Jul-16 10:00:17 217 3.9

Elapsed: 60.14 (mins)

DB Time: 37.17 (mins)

SQL Summary DB/Inst: ELM/elmd1 Snaps: 46522-46523

Elapsed

SQL Id Time (ms)

------------- ----------

bddjks97k003q 490,155

Module: QUERY_MANAGER

QUERY_VIEWER

SELECT E.LM_HR_EMPLID, D.NAME, G.LM_HR_DEPTID, A.BT_LM_INSTR_SKILL, B.LM_CRSE_CO

DE, B.LM_CS_LONG_NM, C.LM_ROLE, B.LM_CI_STATUS, F.LM_ACTIVE, TO_CHAR(SYSDATE,'YY

YY-MM-DD'), TO_CHAR(SYSDATE,'YYYY-MM-DD'),A.LM_PERSON_ID,A.LM_CI_ID,B.LM_CI_ID,T

O_CHAR(B.EFFDT,'YYYY-MM-DD'),C.LM_ROLE_ID FROM PS_LM_INSTR_QUAL A, PS_LM_CI_T

-------------------------------------------------------------

SQL ID: bddjks97k003q DB/Inst: ELM/elmd1 Snaps: 46522-46523

-> 1st Capture and Last Capture Snap IDs

refer to Snapshot IDs witin the snapshot range

-> SELECT E.LM_HR_EMPLID, D.NAME, G.LM_HR_DEPTID, A.BT_LM_INSTR_SKILL, B....

Plan Hash Total Elapsed 1st Capture Last Capture

# Value Time(ms) Executions Snap ID Snap ID

--- ---------------- ---------------- ------------- ------------- --------------

1 3324042429 490,155 1 46523 46523

-------------------------------------------------------------

Plan 1(PHV: 3324042429)

-----------------------

Plan Statistics DB/Inst: ELM/elmd1 Snaps: 46522-46523

-> % Total DB Time is the Elapsed Time of the SQL statement divided

into the Total Database Time multiplied by 100

Stat Name Statement Per Execution % Snap

---------------------------------------- ---------- -------------- -------

Elapsed Time (ms) 490,155 490,154.8 22.0

CPU Time (ms) 328,234 328,234.1 27.9

Executions 1 N/A N/A

Buffer Gets 72,874 72,874.0 0.3

Disk Reads 71,283 71,283.0 9.5

Parse Calls 1 1.0 0.0

Rows 0 0.0 N/A

User I/O Wait Time (ms) 4,338 N/A N/A

Cluster Wait Time (ms) 0 N/A N/A

Application Wait Time (ms) 1 N/A N/A

Concurrency Wait Time (ms) 0 N/A N/A

Invalidations 0 N/A N/A

Version Count 1 N/A N/A

Sharable Mem(KB) 187 N/A N/A

-------------------------------------------------------------

Execution Plan

--------------------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------------------------

| 0 | SELECT STATEMENT | | | | | 18E(100)| |

| 1 | SORT ORDER BY | | 18E| 15E| 15E| 18E (0)|999:59:59 |

| 2 | FILTER | | | | | | |

| 3 | MERGE JOIN | | 18E| 15E| | 18E (0)|999:59:59 |

| 4 | MERGE JOIN | | 18E| 15E| | 18E (0)|999:59:59 |

| 5 | SORT JOIN | | 18E| 15E| 15E| 18E (0)|999:59:59 |

| 6 | MERGE JOIN CARTESIAN | | 18E| 15E| | 18E (0)|999:59:59 |

| 7 | MERGE JOIN CARTESIAN | | 18E| 15E| | 18E (0)|999:59:59 |

| 8 | MERGE JOIN CARTESIAN | | 18E| 15E| | 18E (0)|999:59:59 |

| 9 | MERGE JOIN CARTESIAN | | 87P| 9636P| | 464T (2)|999:59:59 |

| 10 | MERGE JOIN CARTESIAN | | 22G| 2137G| | 48M (2)|188:36:00 |

| 11 | MERGE JOIN CARTESIAN | | 60645 | 5093K| | 1249 (1)| 00:00:18 |

| 12 | TABLE ACCESS FULL | PS_LM_ROLE_TBL | 13 | 299 | | 3 (0)| 00:00:01 |

| 13 | BUFFER SORT | | 4665 | 287K| | 1246 (1)| 00:00:18 |

| 14 | TABLE ACCESS FULL | PS_LM_CI_TBL | 4665 | 287K| | 96 (2)| 00:00:02 |

| 15 | BUFFER SORT | | 374K| 5488K| | 48M (2)|188:35:59 |

| 16 | TABLE ACCESS FULL | PS_LM_PERSON | 374K| 5488K| | 800 (2)| 00:00:12 |

| 17 | BUFFER SORT | | 3850K| 84M| | 464T (2)|999:59:59 |

| 18 | TABLE ACCESS FULL | PS_LM_PERSON_ATTRB | 3850K| 84M| | 20436 (2)| 00:04:47 |

| 19 | BUFFER SORT | | 1156K| 23M| | 18E (0)|999:59:59 |

| 20 | TABLE ACCESS FULL | PS_LM_ORGANIZATION | 1156K| 23M| | 6046 (3)| 00:01:25 |

| 21 | BUFFER SORT | | 8668 | 135K| | 18E (0)|999:59:59 |

| 22 | TABLE ACCESS FULL | PS_LM_INSTR_QUAL | 8668 | 135K| | 16 (0)| 00:00:01 |

| 23 | BUFFER SORT | | 374K| 1829K| | 18E (0)|999:59:59 |

| 24 | INDEX FULL SCAN | PS_LM_PERSON | 374K| 1829K| | 5 (20)| 00:00:01 |

| 25 | SORT JOIN | | 740K| 31M| 85M| 9196 (3)| 00:02:09 |

| 26 | TABLE ACCESS FULL | PS_LM_PERSON_NAME | 740K| 31M| | 3942 (3)| 00:00:56 |

| 27 | SORT JOIN | | 453K| 10M| 34M| 22938 (4)| 00:05:22 |

| 28 | TABLE ACCESS FULL | PS_LM_PERSON_ATTRB | 453K| 10M| | 20849 (4)| 00:04:52 |

| 29 | INDEX RANGE SCAN | PSBLM_PERSON_NAME | 1 | 9 | | 1 (0)| 00:00:01 |

| 30 | SORT AGGREGATE | | 1 | 23 | | | |

| 31 | INDEX RANGE SCAN | PS_LM_CI_TBL | 2 | 46 | | 1 (0)| 00:00:01 |

| 32 | SORT AGGREGATE | | 1 | 25 | | | |

| 33 | INDEX RANGE SCAN | PS_LM_PERSON_ATTRB | 11 | 275 | | 1 (0)| 00:00:01 |

| 34 | SORT AGGREGATE | | 1 | 24 | | | |

| 35 | INDEX RANGE SCAN | PS_LM_ORGANIZATION | 3 | 72 | | 1 (0)| 00:00:01 |

| 36 | TABLE ACCESS BY INDEX ROWID | PS_LM_PERSON_ATTRB | 1 | 17 | | 1 (0)| 00:00:01 |

| 37 | INDEX RANGE SCAN | PS_LM_PERSON_ATTRB | 1 | | | 1 (0)| 00:00:01 |

| 38 | SORT AGGREGATE | | 1 | 25 | | | |

| 39 | INDEX RANGE SCAN | PS_LM_PERSON_ATTRB | 11 | 275 | | 1 (0)| 00:00:01 |

| 40 | SORT AGGREGATE | | 1 | 19 | | | |

| 41 | FILTER | | | | | | |

| 42 | TABLE ACCESS BY INDEX ROWID| PS_LM_PERSON_ATTRB | 1 | 19 | | 1 (0)| 00:00:01 |

| 43 | INDEX RANGE SCAN | PS_LM_PERSON_ATTRB | 1 | | | 1 (0)| 00:00:01 |

| 44 | SORT AGGREGATE | | 1 | 25 | | | |

| 45 | INDEX RANGE SCAN | PS_LM_PERSON_ATTRB | 1 | 25 | | 1 (0)| 00:00:01 |

| 46 | TABLE ACCESS BY INDEX ROWID| PS_LM_PERSON_ATTRB | 1 | 19 | | 1 (0)| 00:00:01 |

| 47 | INDEX RANGE SCAN | PS_LM_PERSON_ATTRB | 1 | | | 1 (0)| 00:00:01 |

| 48 | SORT AGGREGATE | | 1 | 25 | | | |

| 49 | INDEX RANGE SCAN | PS_LM_PERSON_ATTRB | 1 | 25 | | 1 (0)| 00:00:01 |

--------------------------------------------------------------------------------------------------------------

Full SQL Text

SQL ID SQL Text

------------ -----------------------------------------------------------------

bddjks97k003 SELECT E.LM_HR_EMPLID, D.NAME, G.LM_HR_DEPTID, A.BT_LM_INSTR_SKIL

LL, B.LM_CRSE_CODE, B.LM_CS_LONG_NM, C.LM_ROLE, B.LM_CI_STATUS, F

.LM_ACTIVE, TO_CHAR(SYSDATE, 'YYYY-MM-DD'), TO_CHAR(SYSDATE, 'YYY

Y-MM-DD'), A.LM_PERSON_ID, A.LM_CI_ID, B.LM_CI_ID, TO_CHAR(B.EFFD

T, 'YYYY-MM-DD'), C.LM_ROLE_ID FROM PS_LM_INSTR_QUAL A, PS_LM_CI_

TBL B, PS_LM_ROLE_TBL C, PS_LM_PERS_NAME_VW D, PS_LM_PERSON E, PS

_LM_PERSON_ATTRB F, PS_LM_ORGANIZATION G WHERE A.LM_CI_ID = B.LM_

CI_ID AND B.EFFDT = (SELECT MAX(B_ED.EFFDT) FROM PS_LM_CI_TBL B_E

D WHERE B.LM_CI_ID = B_ED.LM_CI_ID AND B_ED.EFFDT <= SYSDATE) AND

C.LM_ROLE_ID = A.LM_ROLE_ID AND C.LM_ROLE_TYPE = '0020' AND A.LM

_PERSON_ID = D.LM_PERSON_ID AND D.LM_PERSON_ID = E.LM_PERSON_ID A

ND A.LM_PERSON_ID = F.LM_PERSON_ID AND F.EFFDT = (SELECT MAX(F_ED

.EFFDT) FROM PS_LM_PERSON_ATTRB F_ED WHERE F.LM_PERSON_ID = F_ED.

LM_PERSON_ID AND F.LM_EMPL_RCD = F_ED.LM_EMPL_RCD AND F_ED.EFFDT

<= SYSDATE) AND G.LM_ORGANIZATION_ID = F.LM_ORGANIZATION_ID AND G

.EFFDT = (SELECT MAX(G_ED.EFFDT) FROM PS_LM_ORGANIZATION G_ED WHE

RE G.LM_ORGANIZATION_ID = G_ED.LM_ORGANIZATION_ID AND G_ED.EFFDT

<= SYSDATE) AND G.LM_HR_DEPTID LIKE 'BA%' AND F.LM_ACTIVE = 'Y' A

ND A.BT_LM_INSTR_SKILL = '01' AND B.LM_CI_STATUS = '10' AND C.LM_

ROLE = 'Instructor' OR C.LM_ROLE = 'External Associate' OR C.LM_R

OLE = 'Internal Associate' ORDER BY 1

Report written to awrsqlrpt_1_46522_46523.txt

WORKLOAD REPOSITORY SQL Report

Snapshot Period Summary

DB Name DB Id Instance Inst Num Startup Time Release RAC

------------ ----------- ------------ -------- --------------- ----------- ---

ELM 3884532509 elmd1 1 08-Mar-16 01:02 11.1.0.7.0 YES

Snap Id Snap Time Sessions Curs/Sess

--------- ------------------- -------- ---------

Begin Snap: 46522 11-Jul-16 09:00:08 215 3.9

End Snap: 46523 11-Jul-16 10:00:17 217 3.9

Elapsed: 60.14 (mins)

DB Time: 37.17 (mins)

SQL Summary DB/Inst: ELM/elmd1 Snaps: 46522-46523

Elapsed

SQL Id Time (ms)

------------- ----------

39vr01mym6bs6 614,101

Module: PSQRYSRV@dyl03839app05 (TNS V1-V3)

xyzzy

SELECT E.LM_HR_EMPLID, D.NAME, G.LM_HR_DEPTID, A.BT_LM_INSTR_SKILL, B.LM_CRSE_CO

DE, B.LM_CS_LONG_NM, C.LM_ROLE, B.LM_CI_STATUS, F.LM_ACTIVE, TO_CHAR(SYSDATE,'YY

YY-MM-DD'), TO_CHAR(SYSDATE,'YYYY-MM-DD'),A.LM_PERSON_ID,A.LM_CI_ID,B.LM_CI_ID,T

O_CHAR(B.EFFDT,'YYYY-MM-DD'),C.LM_ROLE_ID FROM PS_LM_INSTR_QUAL A, PS_LM_CI_T

-------------------------------------------------------------

SQL ID: 39vr01mym6bs6 DB/Inst: ELM/elmd1 Snaps: 46522-46523

-> 1st Capture and Last Capture Snap IDs

refer to Snapshot IDs witin the snapshot range

-> SELECT E.LM_HR_EMPLID, D.NAME, G.LM_HR_DEPTID, A.BT_LM_INSTR_SKILL, B....

Plan Hash Total Elapsed 1st Capture Last Capture

# Value Time(ms) Executions Snap ID Snap ID

--- ---------------- ---------------- ------------- ------------- --------------

1 3324042429 614,101 1 46523 46523

-------------------------------------------------------------

Plan 1(PHV: 3324042429)

-----------------------

Plan Statistics DB/Inst: ELM/elmd1 Snaps: 46522-46523

-> % Total DB Time is the Elapsed Time of the SQL statement divided

into the Total Database Time multiplied by 100

Stat Name Statement Per Execution % Snap

---------------------------------------- ---------- -------------- -------

Elapsed Time (ms) 614,101 614,100.8 27.5

CPU Time (ms) 340,203 340,203.3 28.9

Executions 1 N/A N/A

Buffer Gets 72,878 72,878.0 0.3

Disk Reads 69,627 69,627.0 9.3

Parse Calls 1 1.0 0.0

Rows 0 0.0 N/A

User I/O Wait Time (ms) 1,297 N/A N/A

Cluster Wait Time (ms) 0 N/A N/A

Application Wait Time (ms) 14 N/A N/A

Concurrency Wait Time (ms) 0 N/A N/A

Invalidations 0 N/A N/A

Version Count 1 N/A N/A

Sharable Mem(KB) 187 N/A N/A

-------------------------------------------------------------

Execution Plan

--------------------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------------------------

| 0 | SELECT STATEMENT | | | | | 18E(100)| |

| 1 | SORT ORDER BY | | 18E| 15E| 15E| 18E (0)|999:59:59 |

| 2 | FILTER | | | | | | |

| 3 | MERGE JOIN | | 18E| 15E| | 18E (0)|999:59:59 |

| 4 | MERGE JOIN | | 18E| 15E| | 18E (0)|999:59:59 |

| 5 | SORT JOIN | | 18E| 15E| 15E| 18E (0)|999:59:59 |

| 6 | MERGE JOIN CARTESIAN | | 18E| 15E| | 18E (0)|999:59:59 |

| 7 | MERGE JOIN CARTESIAN | | 18E| 15E| | 18E (0)|999:59:59 |

| 8 | MERGE JOIN CARTESIAN | | 18E| 15E| | 18E (0)|999:59:59 |

| 9 | MERGE JOIN CARTESIAN | | 87P| 9636P| | 464T (2)|999:59:59 |

| 10 | MERGE JOIN CARTESIAN | | 22G| 2137G| | 48M (2)|188:36:00 |

| 11 | MERGE JOIN CARTESIAN | | 60645 | 5093K| | 1249 (1)| 00:00:18 |

| 12 | TABLE ACCESS FULL | PS_LM_ROLE_TBL | 13 | 299 | | 3 (0)| 00:00:01 |

| 13 | BUFFER SORT | | 4665 | 287K| | 1246 (1)| 00:00:18 |

| 14 | TABLE ACCESS FULL | PS_LM_CI_TBL | 4665 | 287K| | 96 (2)| 00:00:02 |

| 15 | BUFFER SORT | | 374K| 5488K| | 48M (2)|188:35:59 |

| 16 | TABLE ACCESS FULL | PS_LM_PERSON | 374K| 5488K| | 800 (2)| 00:00:12 |

| 17 | BUFFER SORT | | 3850K| 84M| | 464T (2)|999:59:59 |

| 18 | TABLE ACCESS FULL | PS_LM_PERSON_ATTRB | 3850K| 84M| | 20436 (2)| 00:04:47 |

| 19 | BUFFER SORT | | 1156K| 23M| | 18E (0)|999:59:59 |

| 20 | TABLE ACCESS FULL | PS_LM_ORGANIZATION | 1156K| 23M| | 6046 (3)| 00:01:25 |

| 21 | BUFFER SORT | | 8668 | 135K| | 18E (0)|999:59:59 |

| 22 | TABLE ACCESS FULL | PS_LM_INSTR_QUAL | 8668 | 135K| | 16 (0)| 00:00:01 |

| 23 | BUFFER SORT | | 374K| 1829K| | 18E (0)|999:59:59 |

| 24 | INDEX FULL SCAN | PS_LM_PERSON | 374K| 1829K| | 5 (20)| 00:00:01 |

| 25 | SORT JOIN | | 740K| 31M| 85M| 9196 (3)| 00:02:09 |

| 26 | TABLE ACCESS FULL | PS_LM_PERSON_NAME | 740K| 31M| | 3942 (3)| 00:00:56 |

| 27 | SORT JOIN | | 453K| 10M| 34M| 22938 (4)| 00:05:22 |

| 28 | TABLE ACCESS FULL | PS_LM_PERSON_ATTRB | 453K| 10M| | 20849 (4)| 00:04:52 |

| 29 | INDEX RANGE SCAN | PSBLM_PERSON_NAME | 1 | 9 | | 1 (0)| 00:00:01 |

| 30 | SORT AGGREGATE | | 1 | 23 | | | |

| 31 | INDEX RANGE SCAN | PS_LM_CI_TBL | 2 | 46 | | 1 (0)| 00:00:01 |

| 32 | SORT AGGREGATE | | 1 | 25 | | | |

| 33 | INDEX RANGE SCAN | PS_LM_PERSON_ATTRB | 11 | 275 | | 1 (0)| 00:00:01 |

| 34 | SORT AGGREGATE | | 1 | 24 | | | |

| 35 | INDEX RANGE SCAN | PS_LM_ORGANIZATION | 3 | 72 | | 1 (0)| 00:00:01 |

| 36 | TABLE ACCESS BY INDEX ROWID | PS_LM_PERSON_ATTRB | 1 | 17 | | 1 (0)| 00:00:01 |

| 37 | INDEX RANGE SCAN | PS_LM_PERSON_ATTRB | 1 | | | 1 (0)| 00:00:01 |

| 38 | SORT AGGREGATE | | 1 | 25 | | | |

| 39 | INDEX RANGE SCAN | PS_LM_PERSON_ATTRB | 11 | 275 | | 1 (0)| 00:00:01 |

| 40 | SORT AGGREGATE | | 1 | 19 | | | |

| 41 | FILTER | | | | | | |

| 42 | TABLE ACCESS BY INDEX ROWID| PS_LM_PERSON_ATTRB | 1 | 19 | | 1 (0)| 00:00:01 |

| 43 | INDEX RANGE SCAN | PS_LM_PERSON_ATTRB | 1 | | | 1 (0)| 00:00:01 |

| 44 | SORT AGGREGATE | | 1 | 25 | | | |

| 45 | INDEX RANGE SCAN | PS_LM_PERSON_ATTRB | 1 | 25 | | 1 (0)| 00:00:01 |

| 46 | TABLE ACCESS BY INDEX ROWID| PS_LM_PERSON_ATTRB | 1 | 19 | | 1 (0)| 00:00:01 |

| 47 | INDEX RANGE SCAN | PS_LM_PERSON_ATTRB | 1 | | | 1 (0)| 00:00:01 |

| 48 | SORT AGGREGATE | | 1 | 25 | | | |

| 49 | INDEX RANGE SCAN | PS_LM_PERSON_ATTRB | 1 | 25 | | 1 (0)| 00:00:01 |

--------------------------------------------------------------------------------------------------------------

Full SQL Text

SQL ID SQL Text

------------ -----------------------------------------------------------------

39vr01mym6bs SELECT E.LM_HR_EMPLID, D.NAME, G.LM_HR_DEPTID, A.BT_LM_INSTR_SKIL