1- Tablespaces
- create two table spaces (one for tables and other for indexes)
2- Index
-bitmap for repeated value like = 0,1 - Femal, Mail
-B-tree for large value
CREATE OR REPLACE FUNCTION is_number(char_in VARCHAR2) RETURN NUMBER IS
BEGIN
FOR x IN 1 .. LENGTH(char_in) LOOP
— remove , & .
IF SUBSTR(char_in,x,1) in (’,’ , ‘.’ , ‘ ‘) THEN
RETURN 0;
END IF;
END LOOP;
IF [...]
GET POOL INFORMATION
select name,bytes/(1024*1024) MB from v$sgastat where pool=’shared pool’ order by bytes desc;
from the remote:
export DISPLAY=host.name.com:port
from the local
xhost host.name.com
Select to_char(to_date(’01-JAN-1970′) + 1257424753/86400,’DD-MM-YYYY HH:MI:SS’) from dual;
SELECT to_char(TO_DATE(’19700101000000′,’YYYYMMDDHH24MISS’)
+ NUMTODSINTERVAL(1257424753, ‘SECOND’),’DD_MM_YY HH24:MI:SS’) FROM DUAL
نهاية العالم للشيخ عبدالحميد كشك رحمة الله عليه
The end of whole world
كشك رحمة الله عليه
Below are the steps to re-tuning up your database;
Alter database enable restrict session;
1- Backup it firts
2- from each table alter table rebuild online
3- rebuild indexes
Analyze table using pl/slq
declare
tablename varchar2(50);
CURSOR c1 is select table_name from tabs;
BEGIN
open c1;
loop
fetch c1 into tablename;
EXIT WHEN c1%NOTFOUND;
DBMS_OUTPUT.PUT_LINE(’ANALYZE table ‘||tablename||’ [...]
Hi,
I knew that i don’t have a lot of visitors, but i just like to welcome myself back with this blog, and I wish post some useful posts online,
Thanks for reading and welcome you
Yours
Abdulaziz El-Shihabi
