http://www.oracle.com/technology/oramag/code/tips2005/010305.html select substr(a.sid,1,10) sid, substr(nvl(b.program,machine),1,30) program, count(*) from v$open_cursor a, v$session b where a.saddr=b.saddr group by substr(a.sid,1,10), substr(nvl(b.program,machine),1,30) order by 3 desc ; Track and Monitor Resources This tip comes from Luis Adalberto, DBA at Universidad Autonoma de Coahuila, in Saltillo, Coahuila, Mexico. Running this query will produce a list of database statements and objects […]
Oracle Concepts and Architecture Database Structures.
Oracle question bank Oracle Concepts and Architecture Database Structures. 1. What are the components of Physical database structure of Oracle Database?. ORACLE database is comprised of three types of files. One or more Data files, two are more Redo Log files, and one or more Control files. 2. What are the components of Logical database […]
C Programming small project
download another project bridge management data-manager-for-education-centres.zip Below is the Project of Address Management written in C with Menu book.h book.h #include<conio.h> #include<stdio.h> #include<stdlib.h> #include<string.h> int getscancode(void) { int code; code=getch(); if (code==0) code=getch(); return(code); } int menuchoice(char menu[10][25],int numb) { int key,num=0,cont=1,posx=(10-(numb+1))/2,posy=(20-18)/2; numb–; _setcursortype(_NOCURSOR); textattr(30); gotoxy(posy,posx+1); cprintf(“%s”,menu[0]); cont=0; while(cont<numb) { textattr(3); gotoxy(posy,posx+2+cont); cprintf(“%s”,menu[cont+1]); cont++; } […]
Ethical Hacking CEH
Ethical Hacking and Countermeasures course mission is to educate, introduce and demonstrate hacking tools for penetration testing purposes only. Prior to attending this course, you will be asked to sign an agreement stating that you will not use the newly acquired skills for illegal or malicious attacks and you will not use such tools in […]
Create Database Manuly on Oracle 10g
1. Create necessary directories mkdir D:\oracle\product\10.2.0\admin\arcl\adump mkdir D:\oracle\product\10.2.0\admin\arcl\bdump mkdir D:\oracle\product\10.2.0\admin\arcl\cdump mkdir D:\oracle\product\10.2.0\admin\arcl\dpdump mkdir D:\oracle\product\10.2.0\admin\arcl\pfile mkdir D:\oracle\product\10.2.0\admin\arcl\udump mkdir D:\oracle\product\10.2.0\db_1\cfgtoollogs\dbca\arcl mkdir D:\oracle\product\10.2.0\db_1\database mkdir D:\oracle\product\10.2.0\flash_recovery_area mkdir D:\oracle\product\10.2.0\oradata\arcl 2. Make necessary files 2.1. first make pfile and save it at the location D:\oracle\product\10.2.0\db_1\database 2.2. then make password file using following cmd orapwd file=D:\oracle\product\10.2.0\db_1\database\PWDarcl.ora password=<password> force=y […]