Category Archives: sql

ORA-00020: maximum number of processes: cannot connect as sysdba?!

Database reach max process or sessions, son no new login is available, first your sysadmin cant  access too for solve the problem seting new process value, is a production  enviroment so we dont want to kill the instance as a first step to solve the problem .

Continue reading

Advertisements

A Round trip with Oracle Particioning


We are going to make a trip arround partiotioning in Oracle, why use partitioning?, types, despartitioning, how check some info about particioned tables…allways usefull tips for use day to day at work.

Continue reading

Oracle 10g Client on Windows 7

So we want use old sqlplusw, cause is light, fast than any sql developer for some admin duties, but wait! ORACLE baned this software since Oracle 11g, but no problem you can donwload from here 10.2.0.4 client. This client bring a compatibility problem with windows 7 for solve ….

Continue reading