Thursday, 8 February 2018

https://knome.ultimatix.net/blogposts/410903-guj-rapdrp-technical-session-on-digital-machine-learning
https://knome.ultimatix.net/blogposts/398213-looking-for-opportunity-in-machine-learningdata-science
https://knome.ultimatix.net/blogposts/396888-want-associates-with-experience-in-machine-learning-with-python-immediate-requirement
https://knome.ultimatix.net/blogposts/377477-a-complete-tutorial-to-learn-data-science-with-python-from-scratch
https://knome.ultimatix.net/blogposts/376158-deep-learning-specialization-coursera
machine learning

Miscellenous

MAXQUERYLEN : Identifies the length of the longest query (in seconds) executed in the instance during the period. 
You can use this statistic to estimate the proper setting of the UNDO_RETENTION initialization parameter. 
The length of a query is measured from the cursor open time to the last fetch/execute time of the cursor. 
Only the length of those cursors that have been fetched/executed during the period are reflected in the view.

Query which orders the MAXQUERYLEN column of v$undostat data in descending order  .
 select *
from v$undostat us , v$sql s
where us.MAXQUERYID = s.sql_id 
order by  UNDOBLKS desc;
We can use maxqueryid column present in v$undostat to join with v$sql view in order to get sql query which is using undo space.
How do you get the undo usage ?
UNDOBLKS column present in the v$undostat gives the number of undo blocks are being used currently. you have to multiply with size of block to get the usage.


how total undo size is calculated.
Content column present in dba_tablespaces provides information regarding whether tablespace is a temporary tablespace , permanent tablespace or undo tablespaces.
there you can retrive all undo tablespaces.  sometimes tablespace may be offline . so filter only online undo tablespace using status column of dba_tablespaces
now I need all the datafiles associated to these undo tablespaces to get bytes or size of datafiles. this we can get from v$datafile but concern is v$datafile doesn't contain
any undotablespace name or any tablespace name . it contain tablespace number hence I need to combine tablespace_name of dba_tablespaces to name column of v$tablespace 
which contain tablespace name with it id. so here I am getting id of tablespace with I need to combine with v$datafile to get total bytes used for undo tablespace.




SQL> select sum(d.bytes) "undo"
  2  from v$datafile d,
  3  v$tablespace t,
  4  dba_tablespaces s
  5  where s.contents = 'UNDO'
  6  and s.status = 'ONLINE'
  7  and t.name = s.tablespace_name
  8  and d.ts# = t.ts#;

 UNDO
----------
 10485760




HOw do you check whether FTP is configured and running or not ?


I found that I have several services running related to ftp


cat /etc/services | grep ftp
ftp-data        20/tcp
ftp             21/tcp
tftp            69/udp
sftp            115/tcp
ftps-data       989/tcp                         # FTP over SSL (data)
ftps            990/tcp
venus-se        2431/udp                        # udp sftp side effect
codasrv-se      2433/udp                        # udp sftp side effect
frox            2121/tcp                        # frox: caching ftp proxy
zope-ftp        8021/tcp                        # zope management by ftp




The /etc/services file is used to tell what ports are standard for a given service. It does not mean that they are installed. If you look at the file, you can see that ftp data is transferred on port 21 using TCP and that port 21 is the standard ftp port and also uses TCP. It is a tool that client and servers can use to determine what ports to open for a connection. It is also a reference for administration purposes to know what service goes w/ what ports.

HTH

Forrest


/etc/services file contain service port number and protocol.

if you want to view running service use nmap or netstat command


netstat -antlp | grep ftp
tcp        0      0 0.0.0.0:21              0.0.0.0:*               LISTEN      26142/vsftpd


nmap localhost or IPADDRESS

Starting Nmap 4.62 ( http://nmap.org ) at 2010-07-18 13:12 PDT
Interesting ports on localhost (127.0.0.1):
Not shown: 1705 closed ports
PORT     STATE SERVICE
21/tcp   open  ftp
22/tcp   open  ssh
25/tcp   open  smtp
80/tcp   open  http
......
.....
....




[root@localhost ~]# find / -name groupadd 2>/null/dev
bash: /null/dev: No such file or directory
[root@localhost ~]# find / -name groupadd
/usr/sbin/groupadd
[root@localhost ~]# echo $PATH
/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/o/bin
[root@localhost ~]# set PATH=$PATH:groupadd -g 1200 asmadmin
[root@localhost ~]# groupadd -g 1201 asmdba
bash: groupadd: command not found
[root@localhost ~]# groupadd -g 1202 asmoper
bash: groupadd: command not found
[root@localhost ~]#
[root@localhost ~]#
[root@localhost ~]# set PATH=$PATH:/usr/sbin
[root@localhost ~]# echo $PATH
/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/o/bin
[root@localhost ~]# export PATH=$PATH:/usr/sbin
[root@localhost ~]# echo $PATH
/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/o/bin:/usr/sbin
[root@localhost ~]# groupadd -g 1200 asmadmin
[root@localhost ~]#


C100129463

CREATE SEQUENCE CA_PAID_LEAVERS.GENERATE_SCH_ID
  START WITH 6000
  MAXVALUE 9999999999999999999999999999
  MINVALUE 6000
  NOCYCLE
  CACHE 20
  ORDER;

select * from dba_tables where table_name=PS_LOCATION_TBL@;
select * from PS_LOCATION_TBL@HR8_SOURCE.NAT.BT.COM;
select * from dba_db_links;

PUBLIC
Specify PUBLIC to create a public database link visible to all users. If you omit this clause, then the database link is private and is available only to you.
The data accessible on the remote database depends on the identity the database link uses when connecting to the remote database:
  • If you specify CONNECT TO user IDENTIFIED BY password, then the database link connects with the specified user and password.
  • If you specify CONNECT TO CURRENT_USER, then the database link connects with the user in effect based on the scope in which the link is used.
  • If you omit both of those clauses, then the database link connects to the remote database as the locally connected user.


    SELECT name, value
    FROM gv$parameter

    WHERE (name LIKE '%link%')

    OR (name IN ('global_names', 'dblink_encrypt_login')); 
PS interface ?

    How do you reset essentials in workspace ?

    windows->workspace->reset essentials

  what is that 2 square brackets that is present at the bottom?

one is foreground color and other is background colour


what is color picker dialogue box ?


if you want exact colour of a things present in photo . how do u get that ?

eye dropper tool.


sometime you wanna to fill enter foreground or background with one colour then how do you achive that?

edit->fill->there u have options


what is the use of gradient tool?


how do make use rectangular marquee tool?


how to deselect selected area?

what is add to selection , subtract from selection, intersect  with selection?


where the brightness menu appears?

image--> brightness

what is revert and wr is  it?

select any image with rectangular maquee tool . go to select ---> modift --- feather .wht is the use of it?


wt is the use of load selection and save selection?


Peoplesoft


Components of a PeopleSoft System


 PeopleSoft is a chain of linked technologies that stretch between the user and the database.


The database is fundamental to the entire structure, but the technology stack stretches out through the BEA Tuxedo Application Server and the Java servlet to the user's browser


How do you memorise Peoplesoft Diagram ?


1) Peoplesoft schema it contains peoplesoft tables and application tables


of course who will monitor application tables.
Peoplesoft tools Application server 


there will be webserver it is java enabled web browser between the Internet browser and Peoplesoft tool application 


How people soft applications connect webserver . it is through Jolt and how webserver will connect to internet browser it is through HTTP.


what ever I have explained above is Application execution part . 


There are actually 2 parts 
1) application Execution part.
2) application Development part. 


Application development part also contains people soft  application server that server host application development tools. it is through Tuxedo

How do you search for a file.. in liux. 


There are 3 types 


1) using find command.


2) Using locate command


3)  which command


1)
$ find / -name uuencode 2>/dev/null
/usr/bin/uuencode


2) $ locate uuencode
/usr/bin/uuencode
/usr/share/man/man1/uuencode.1.gz
/usr/share/man/man1p/uuencode.1p.gz
/usr/share/man/man5/uuencode.5.gz




3)which uuencode


How to signal the end of stdin input in bash
















  • Ctrl+C sends a kill signal to the running process.
  • Ctrl+D sends an End of Transmission character.


  • How to get windows server uptime ?

    Event : Cache buffer chains



    how to replace gap between lines notepad++ 
    find - \r\n\r\n
    replace with - \r\n




           Following Text type are good in outlook :

    Gill SANS mt Microsoft new tai lue Microsoft tai le Microsoft yahei Dubai EBRIMA



    A look at world’s 100 most powerful technology companies



        Accenture (Ireland)
    2)      Acer (Taiwan)
        Adobe (US)
    4)      Advanced Micro Devices (AMD) (US)
    5)      Advantest (Japan)
    6)      Akamai Technologies (US)
    7)      Alphabet (US)
    8)      Amazon (US)
    9)      Amdocs (US)
    10)  Analog Devices (US)

    11)  Apple (US)
    12)  Applied Materials (US)
    13)  ARRIS International (US)
    14)  ASE Group (Taiwan)
    15)  ASM Pacific Technology (Hong Kong)
    16)  ASUS (Taiwan)
    17)  Atos (France)
    18)  Autodesk (US)
    19)  CA Technologies (US)
    20)  Canon (Japan)
    21)  Capgemini (France)
    22)  Celestica (Canada)
    23)  CGI (Canada)
    24)  Cisco (US)
    25)  Cognizant (US)
    26)  CommScope (US)
    27)  Computacenter (UK)
    28)  Computershare (Australia)
    29)  dormakaba (Switzerland)
    30)  DXC Technology (US)
    31)  eBay Inc. (US)
    32)  Ericsson (Sweden)
    33)  Facebook (US)
    34)  FUJIFILM (Japan)
    35)  Fujikura Ltd. (Japan)
    36)  Fujitsu Ltd. (Japan)
    37)  Gemalto (Netherlands)
    38)  HCL Technologies Ltd. (India)
    39)  Hewlett Packard Enterprise (US)
    40)  HP (US)
    41)  IBM (US)
    42)  Infineon Technologies (Germany)
    43)  Infosys (India)
    44)  Intel (US)
    45)  Intuit (US)
    46)  Lam Research (US)
    47)  Leidos (US)
    48)  Lenovo (China)
    49)  LG Electronics (Korea; Republic (S. Korea)
    50)  LITE-ON Technology (Taiwan)
    51)  ManTech International Corporation (US)
    52)  Mastercard (US)
    53)  Micron Technology (US)
    54)  Microsoft (US)
    55)  Motorola Solutions (US)
    56)  Nanya Technology (Taiwan)
    57)  National Instruments (US)
    58)  NCR Corporation (US)
    59)  NEC (Japan)
    60)  Nokia (Finland)
    61)  Nvidia (US)
    62)  NXP Semiconductors (Netherlands)
    63)  OKI Electric Industry Co., Ltd. (Japan)
    64)  ON Semiconductor (US)
    65)  Oracle (US)
    66)  PEGATRON Corporation (Taiwan)
    67)  Powertech Technology Inc. (Taiwan)
    68)  Qisda Corporation (Taiwan)
    69)  Qualcomm (US)
    70)  Quanta Computer (Taiwan)
    71)  Renesas Electronics Corporation (Japan)
    72)  ROHM (Japan)
    73)  Salesforce (US)
    74)  Samsung Electronics (Korea; Republic S. Korea)
    75)  SAP (Germany)
    76)  Seiko Epson Corporation (Japan)
    77)  Sharp Corporation (Japan)
    78)  Siliconware Precision Industries Ltd. (SPIL) (Taiwan)
    79)  SK Hynix Inc (Korea; Republic S. Korea)
    80)  Sony (Japan)
    81)  Sopra Steria (France)
    82)  STMicroelectronics (Switzerland)
    83)  Symantec Corporation (US)
    84)  Taiwan Semiconductor Manufacturing Co., Ltd. (TSMC) (Taiwan)
    85)  Tata Consultancy Services (India)
    86)  Tech Mahindra (India)
    87)  Tencent (China)
    88)  Teradata (US)
    89)  Texas Instruments (US)



    https://www.linkedin.com/pulse/linkedin-top-companies-2018-where-india-wants-work-now-abhigyan-chand/?trk=li_fb_apac-in_bcs_topcompanies18_facebook_blogpaid&utm_campaign=topcompanies18&utm_medium=social&utm_source=facebook&utm_content=blogpaid







       

    No comments:

    Post a Comment