Re: 오늘의 마지막 문제. hr 계정으로 접속해서 다양한 SQL을 실행하는데 ...

<p>[HR 계정 접속]</p><div class="figure-img" data-ke-type="image" data-ke-style="alignLeft" data-ke-mobilestyle="widthOrigin"><img src="https://t1.daumcdn.net/cafeattach/zchT/a0d8fb3e85dddbfcdc5b0230411927e61b6d4d48" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/a0d8fb3e85dddbfcdc5b0230411927e61b6d4d48" data-origin-width="641" data-origin-height="431"></div><p> </p><p>[세션 모니터에서 해당 HR계정의 세션 확인]</p><div class="figure-img" data-ke-type="image" data-ke-style="alignLeft" data-ke-mobilestyle="widthOrigin"><img src="https://t1.daumcdn.net/cafeattach/zchT/392e1953c105390c6d374b1fe47639fb96cfe791" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/392e1953c105390c6d374b1fe47639fb96cfe791" data-origin-width="1497" data-origin-height="755"></div><p> </p><p>[SQL Trace 수행]</p><div class="figure-img" data-ke-type="image" data-ke-style="alignLeft" data-ke-mobilestyle="widthOrigin"><img src="https://t1.daumcdn.net/cafeattach/zchT/4ed2f961a3317cf591d25566635281a4fb274ec4" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/4ed2f961a3317cf591d25566635281a4fb274ec4" data-origin-width="617" data-origin-height="179"></div><p> </p><p>[해당 세션에서 다양한 SQL 수행]</p><div class="figure-img" data-ke-type="image" data-ke-style="alignLeft" data-ke-mobilestyle="widthOrigin"><img src="https://t1.daumcdn.net/cafeattach/zchT/8d92b548f204cc8705aaf008d698d6f7041d8933" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/8d92b548f204cc8705aaf008d698d6f7041d8933" data-origin-width="643" data-origin-height="944"></div><p> </p><p>[SQL Trace 종료]</p><div class="figure-img" data-ke-type="image" data-ke-style="alignLeft" data-ke-mobilestyle="widthOrigin"><img src="https://t1.daumcdn.net/cafeattach/zchT/6e4431ed92c4c24d64ccb68507b7f5f2c8bb03dd" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/6e4431ed92c4c24d64ccb68507b7f5f2c8bb03dd" data-origin-width="415" data-origin-height="178"></div><p> </p><p>[SQL Trace 확인]</p><div class="figure-img" data-ke-type="image" data-ke-style="alignLeft" data-ke-mobilestyle="widthOrigin"><img src="https://t1.daumcdn.net/cafeattach/zchT/000e8e21b89590b7495772727e55148d33b22b31" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/000e8e21b89590b7495772727e55148d33b22b31" data-origin-width="426" data-origin-height="194"></div><div class="figure-img" data-ke-type="image" data-ke-style="alignLeft" data-ke-mobilestyle="widthOrigin"><img src="https://t1.daumcdn.net/cafeattach/zchT/f3d885c3e54d2b457404e9730cc1722e56889dd6" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/f3d885c3e54d2b457404e9730cc1722e56889dd6" data-origin-width="213" data-origin-height="228"></div><div class="figure-img" data-ke-type="image" data-ke-style="alignLeft" data-ke-mobilestyle="widthOrigin"><img src="https://t1.daumcdn.net/cafeattach/zchT/7075791bc9626913874580a41f64deea70bf3159" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/7075791bc9626913874580a41f64deea70bf3159" data-origin-width="609" data-origin-height="382"></div><div class="figure-img" data-ke-type="image" data-ke-style="alignLeft" data-ke-mobilestyle="widthOrigin"><img src="https://t1.daumcdn.net/cafeattach/zchT/ec8ad25c6df42e0106284e4c7bcae0807b9decfb" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/ec8ad25c6df42e0106284e4c7bcae0807b9decfb" data-origin-width="933" data-origin-height="830"></div><p> </p><p>[CURSOR 탭에서 오래 수행된 SQL 순으로 확인]</p><div class="figure-img" data-ke-type="image" data-ke-style="alignLeft" data-ke-mobilestyle="widthOrigin"><img src="https://t1.daumcdn.net/cafeattach/zchT/b11c35f9c94ee41b77daf31ea705b6564b4c42cf" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/b11c35f9c94ee41b77daf31ea705b6564b4c42cf" data-origin-width="1403" data-origin-height="694"></div>