Skip to main content

Posts

Showing posts with the label Oracle
IPFS powers the Distributed Web A peer-to-peer hypermedia protocol designed to preserve and grow humanity's knowledge by making the web upgradeable, resilient, and more open. The web of tomorrow needs IPFS today IPFS aims to surpass HTTP in order to build a better web for all of us. Today's web is inefficient and expensive HTTP downloads files from one server at a time — but peer-to-peer IPFS retrieves pieces from multiple nodes at once, enabling substantial bandwidth savings. With  up to 60% savings for video,  IPFS makes it possible to efficiently distribute high volumes of data without duplication. Today's web can't preserve humanity's history The average lifespan of a web page is 100 days  before it's gone forever. The medium of our era shouldn't be this fragile. IPFS makes it simple to set up resilient networks for mirroring data, and thanks to content addressing, files stored using IPFS are automatically versioned. Today's web is centralized, limit...

Pull Oracle Tablespace Size

select owner, table_name, round((num_rows*avg_row_len)/1024) "Size in KB" from All_tables where owner = 'SAPR3' order by "Size in KB" desc; SELECT DS.TABLESPACE_NAME, SEGMENT_NAME, ROUND(SUM(DS.BYTES) / 1024) "SIZE in KB"   FROM DBA_SEGMENTS DS   WHERE SEGMENT_NAME IN (SELECT TABLE_NAME FROM ALL_TABLES where OWNER='SAPR3')  GROUP BY DS.TABLESPACE_NAME,        SEGMENT_NAME;

Oracle Fragmentation

select    table_name,round((blocks*8),2) "size (kb)" ,    round((num_rows*avg_row_len/1024),2) "actual_data (kb)",    (round((blocks*8),2) - round((num_rows*avg_row_len/1024),2)) "wasted_space (kb)" from    dba_tables where    (round((blocks*8),2) > round((num_rows*avg_row_len/1024),2)) order by 4 desc;

How to reset password for user "sys" in Oracle?

How to reset password for user "sys" in Oracle? Solution: Delete pwdniku.ora from /$ORACLE_HOME/dbs folder  Run command orapwd file=/$ORACLE_HOME/dbs/orapwniku.ora password=system entries=10  Connect to Oralce using sqlplus /nolog  Run command inside SQL prompt: connect sys/system as sysdba  Run command: alter user system identified by system;  At this point your user "system" password has been changed to system in this example  Connect to SQLPLUS: sqlplus system/system  Run command: alter user sys identified by system;  Your sys password now has been changed

Set Oracle user expiry unlimted

ALTER PROFILE "DEFAULT" LIMIT   SESSIONS_PER_USER UNLIMITED   CPU_PER_SESSION UNLIMITED   CPU_PER_CALL UNLIMITED   CONNECT_TIME UNLIMITED   IDLE_TIME UNLIMITED   LOGICAL_READS_PER_SESSION UNLIMITED   LOGICAL_READS_PER_CALL UNLIMITED   COMPOSITE_LIMIT UNLIMITED   PRIVATE_SGA UNLIMITED   FAILED_LOGIN_ATTEMPTS 10   PASSWORD_LIFE_TIME UNLIMITED  PASSWORD_REUSE_TIME UNLIMITED   PASSWORD_REUSE_MAX UNLIMITED   PASSWORD_LOCK_TIME 1   PASSWORD_GRACE_TIME 7   PASSWORD_VERIFY_FUNCTION NULL; to verify column limit format a20 select profile,resource_name,limit from dba_profiles where profile='DEFAULT';

Kill Oracle Sessions

select inst_id,sid,serial# from gv$session where username='DBSNMP';    INST_ID        SID    SERIAL# ---------- ---------- ----------          1        282        730          1        284      18914          1        305      28470 alter system kill session '282,730,@1';